class[ Property] type[ RE_1 ] Fails to Produce All Records

phRETS
property
RE-1
retag add tags

RETS URL: http://neren.rets.paragonrels.com/ret...

Username: del0211

The "Answer" below merely is list of filters that I did not set up, and most importantly, does not state how they need to be changed [and by whom] to get all of the RE_1 Property records available using the bulk queries stated below, or why three L_City's out of 20+ work fine. If there is a filter issue, How can that be remedied? Please also see the comments below and help me to solve the problem.

Software to extract data is: phrets.php

As an example of a score of "L-City" queries that work as expected is the following:

query: [ (L_City=Francestow),(L_State=NH) ] class[ Property] type[ RE_1 ] limit[ 5000 ]

15 MLS records found of 15 without "closed" status: 4478390, 4483929, 4659483, 4668562, 4668895, 4674115, 4674205, 4678569, 4678782, 4679416, 4679541, 4682083, 4683082, 4685084, 4685510

The only variable in the following queries is "L_City" whereby "Francestow" is substituted with "Merrimack", "Nashua" and "Manchester".

The following three queries fail to produce expected results:

query: [ (L_City=Merrimack),(L_State=NH) ] class[ Property] type[ RE_1 ] limit[ 5000 ]

2 MLS records found of 71 without "closed" status: 4619170, 4629832

query: [ (L_City=Nashua),(L_State=NH) ] class[ Property] type[ RE_1 ] limit[ 5000 ]

0 MLS records found of 339 without "closed" status

query: [ (L_City=Manchester),(L_State=NH) ] class[ Property] type[ RE_1 ] limit[ 5000 ]

0 MLS records found of 331 without "closed" status

dcgllc

asked 2018-04-13 12:06:13 -0500, updated 2018-04-13 16:42:21 -0500

edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

Sort by

oldest

newest

most voted

Hello!

We had a chance to review your account, and the RETS profile you're currently attached to has the following filters by default (aside from the ones you are adding to your query): ((L_StatusCatID=1,3),(LV_vow_include=Y))|((L_StatusCatID=2),(L_ClosingDate=2012-01-01+),(LV_vow_include=Y))|((L_StatusCatID=6),(LM_DateTime_7=2012-01-01+),(LV_vow_include=Y))

So the listings have to meet all of the above criteria, AND (L_City=Merrimack),(L_State=NH) OR (L_City=Nashua),(L_State=NH) OR (L_City=Manchester),(L_State=NH).

If you have a specific listing you're wondering why it did not returned, please let us know and we can review the exact listing!

Thank you,

Sadie

answered 2018-04-13 15:05:32 -0500

edit flag offensive 0 remove flag delete link

Comments

I can pull all RE-1 Properties in Merrimack, Nashua and Manchester individually by a query on MLS#. But to pull them in bulk by RE-1 fails. If the filters are consistently applied and still the same for 20+ towns in my profile why do only 3 L_City's fail? I need a solution, not a filter list?

dcgllc (2018-04-13 15:43:42 -0500) edit

If my account has consistent filters, why do none of these four Merrimack examples appear on a bulk query by Property and RE_1: 685990, 4685733, 4685656 and 4685495; and all of them can be queried by individual MLS# [ListingID]. How can this be a filter problem?

dcgllc (2018-04-13 15:52:17 -0500) edit

Where can a list of the filter definitions and effects for the following be found: ((L_StatusCatID=1,3),(LV_vow_include=Y))|((L_StatusCatID=2),(L_ClosingDate=2012-01-01+),(LV_vow_include=Y))|((L_StatusCatID=6),(LM_DateTime_7=2012-01-01+),(LV_vow_include=Y))?

dcgllc (2018-04-13 15:55:32 -0500) edit

So I did review one of the example listings, 4685495. I think the issue is the Max results returned here is 2,500. 4685495 would be in the next 2,500 results. So you would need to utilize offset. Here is an example of how to get the next set of listings, which would include 4695495:

Sadie (2018-04-13 17:01:06 -0500) edit

SearchType=Property&Class=RE_1&Query=(L_city=Merrimack),(L_state=NH)&QueryType=DMQL2&Count=1&Format=COMPACT-DECODED&StandardNames=0&Offset=2501

Also below is a helpful guide as well: RETS Best Practices

Sadie (2018-04-13 17:06:52 -0500) edit

add a comment see more comments

class[ Property] type[ RE_1 ] Fails to Produce All Records edit

Comments

1 Answer

Comments