Ask Your Question
0

Listings dropped for WarrentCounty

asked 2019-04-30 15:51:06 -0500

updated 2019-04-30 15:52:26 -0500

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

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-04-30 17:58:17 -0500

updated 2019-04-30 17:59:44 -0500

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.

edit flag offensive 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 gravatar imagebrokersolutions ( 2019-05-01 09:55:03 -0500 )edit

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

bwolven gravatar imagebwolven ( 2019-05-01 09:58:51 -0500 )edit

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 gravatar imagebrokersolutions ( 2019-05-01 10:37:02 -0500 )edit

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

bwolven gravatar imagebwolven ( 2019-05-01 10:42:30 -0500 )edit

that fix our issue

brokersolutions gravatar imagebrokersolutions ( 2019-05-01 14:33:59 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-04-30 15:51:06 -0500

Seen: 89 times

Last updated: Apr 30