NEREN RETS Query Issue

neren
phRETS
query
retag add tags

I'm using the following URL: http://neren.rets.paragonrels.com/ret... And the PHPRETs Class to connect.

I have no problem connecting, and getting data but when I try to limit data returned from Property->RE_1 in the Query with (L_Status=|Active,Pending) I get a 20206 error "Invalid Query Syntax". The syntax is valid according to the specification and also worked on INNOVIA so the question is, "Where am I going wrong?". I have tried various combinations with number equivelents and without as well as L_StatusID which throws an unauthorized error.

Ryan

asked 2016-09-21 12:08:01 -0500

edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

3 Answers

Sort by

oldest

newest

most voted

Thank you. I had not come across the underscore nomenclature anywhere in the provided docs or the metadata pull. Much appreciated.

Ryan

answered 2016-09-21 13:26:44 -0500

edit flag offensive 0 remove flag delete link

Comments

It just happens to be the Value assigned to the lookup attached to the field as displayed in the metadata for the lookup.

bwolven (2016-09-21 17:27:33 -0500) edit

add a comment see more comments

in an email from Neren on 9/15

The Listing Status option of "Active Under Contract" has been moved from the Status Category of "Active" to the Status Category "Pending". In addition, the Status Category name of "Pending" has been relabeled "Under Contract". The value for the "Active Under Contract" status option has changed from "1_1" to "3_1".

so i am using (L_Status=|1_0,3_1)

bscdata

answered 2016-09-23 13:01:47 -0500

edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

To search for the Active and Pending you need to send the lookup value no the decoded value: (L_Status=|1_0,3_0) or (L_StatusCatID=|1,3) would be the Paragon equivalent.

bwolven

answered 2016-09-21 12:53:09 -0500

edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

NEREN RETS Query Issue edit

Comments

3 Answers

Comments

Comments

Comments