Ask Your Question

Ryan's profile - activity

2016-09-30 10:21:16 -0500 commented answer Using Neren there seems to be missing Offices

I used to do a local Join like you but switched to grabbing the Agent & Office name from the Property rows. Unless you want to detailed Agent & Office info, you no longer need the Agent & Office tables. FYI, all the Agent & Office ids have changed.

2016-09-26 13:43:11 -0500 received badge  Famous Question (source)
2016-09-23 11:41:31 -0500 received badge  Notable Question (source)
2016-09-22 09:53:44 -0500 received badge  Popular Question (source)
2016-09-21 18:11:45 -0500 received badge  Scholar (source)
2016-09-21 13:26:44 -0500 answered a question NEREN RETS Query Issue

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

2016-09-21 12:08:01 -0500 asked a question NEREN RETS Query Issue

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.