First time here? Check out the FAQ!
Ask Your Question
0

Listings dropped for WarrentCounty

  • retag add tags

Hi, Our listings dropped for warren county Loginurl: http://GLOBALMLS-RETS.paragonrels.com... Username: CWS

Our listings dropped from 1777 from 1255 and here are the examples of missing listings. Can you please look into this?mlsnumber :124289,124498,125609

This is the query we are running for residential class But when we run the below query we are only getting 627 listings http://GLOBALMLS-RETS.paragonrels.com...

before it fail when that query ran We used to get 879 residential listings .

Nothing has change from our side. We started this issue from Mon 4/29/2019 11:54 AM, the listings dropped to 1777 to 1543 then later at Mon 4/29/2019 1:54 PM it dropped to 1282.

What happen at 11:54 am yesterday, anything change ? Hope this is more helpful

brokersolutions's avatar
brokersolutions
asked 2019-04-30 15:51:06 -0500, updated 2019-04-30 15:52:26 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

Looks like some of the offices may have had their primary board removed or something.
When I use this query:
(L_ListingID=1+),(L_StatusCatID=|1),(L_Keyword1=|0,1),(L_IdxInclude=|0,2),((LO1_board_id=4)|(LO1_board_id=.EMPTY.))
I get a count of Search Count: 926 for 1F_1 class.
The three you listed above have empty LO1_board_id.

bwolven's avatar
bwolven
answered 2019-04-30 17:58:17 -0500, updated 2019-04-30 17:59:44 -0500
edit flag offensive 0 remove flag delete link
more

Comments

When we run that query we are only getting 626 records http://GLOBALMLS-RETS.paragonrels.com...

Those three listings used to be asscoaited with Board Southern Adirondack Realtors, Inc.

brokersolutions's avatar brokersolutions (2019-05-01 09:55:03 -0500) edit
more
  • delete

Are you sure you ran the query above including this part?
((LO1_board_id=4)|(LO1_board_id=.EMPTY.))

bwolven's avatar bwolven (2019-05-01 09:58:51 -0500) edit
more
  • delete

When i do that http://GLOBALMLS-RETS.paragonrels.com... we are getting 17419 records.We dont want that, we only want Southern Adirondack Realtors, Inc. records .

brokersolutions's avatar brokersolutions (2019-05-01 10:37:02 -0500) edit
more
  • delete

You missed the "(" ... ")" around the board OR statement.

bwolven's avatar bwolven (2019-05-01 10:42:30 -0500) edit
more
  • delete

that fix our issue

brokersolutions's avatar brokersolutions (2019-05-01 14:33:59 -0500) edit
more
  • delete
add a comment see more comments

Your Answer

Login/Signup to Answer