Ask Your Question

Using Neren there seems to be missing Offices

asked 2016-09-29 14:38:18 -0600

When I query properties, I lookup listing office information. I use from Properties field [L_ListOffice1] and match to ActiveOffices field [O_OfficeID] This works for some but others there is no match.. This makes it hard to follow the TOS and display their (listing agents) information.

Am I matching up the wrong fields?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2016-09-29 21:48:49 -0600

I have found the answer - only ActiveOffices is available to me. This is a bit troublesome as I can retrieve closed listings but some are from offices that are current non active members. I have asked Neren and await answer on TOS violation possibility if list property without credits of the non available agency...

edit flag offensive delete link more


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.

Ryan gravatar imageRyan ( 2016-09-30 10:21:16 -0600 )edit

Thanks Ryan, thats the route I took in the end...

berksites gravatar imageberksites ( 2016-10-03 15:44:14 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-29 14:38:18 -0600

Seen: 527 times

Last updated: Sep 29 '16