Ask Your Question

NEREN RETS Query Issue

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

I'm using the following URL: 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.

edit retag flag offensive close merge delete

3 Answers

Sort by ยป oldest newest most voted

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

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.

edit flag offensive delete link more

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

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

edit flag offensive delete link more


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

bwolven gravatar imagebwolven ( 2016-09-21 17:27:33 -0600 )edit

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

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)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-21 12:08:01 -0600

Seen: 881 times

Last updated: Sep 23 '16