Search returning 0 results

10 views
Skip to first unread message

Steve Krzysiak

unread,
May 8, 2010, 8:55:18 PM5/8/10
to Appraisal Dashboard
Greetings,
I havent had a chance to give this much thought, but after playing
with AD for quite some time yesterday, I could not get any search
results to show. I added some logging statements in AD and phrets to
see what was going on. Basically, AD would construct the dmql
properly, like this:
2010-05-08 00:16:55,INFO,((STR=*plymouth*),(ZP=60605),(BR=2),(BTH=2))

Using another rets client, this dmql returns my results proper.

Once phrets gets to the point of executing the curl on the encoded
url, the url is this:
http://mredllc-rets.connectmls.com/rets/server/search?SearchType=Property&Class=9&Query=%28%28STR%3D*plymouth*%29%2C%28ZP%3D60605%29%2C%28BR%3D2%29%2C%28BTH%3D2%29%29&QueryType=DMQL2&Count=1&Format=COMPACT-DECODED&Limit=200&StandardNames=0

This query fails, and I'm not sure why. I imagine phrets(which I am
not familiar with) knows what it is doing, so the problem may be in
the hand off from AD to phrets?

Any input is of course appreciated, thank you,
-Steve

kannan kannan

unread,
May 11, 2010, 3:10:37 PM5/11/10
to crt-appraisal-d...@googlegroups.com
in the server.php the last method test can be called to help you find the classes to search, the metadata etc. 

un-comment the stuff you need an call this directly to fine tune to your mls system. for example


On May 11, 2010, at 11:54 AM, Steve Krzysiak wrote:

Nevermind, I see where, everything appears to be working properly now!  I knew it had to be something obvious, thanks Kannan.

On Tue, May 11, 2010 at 1:46 PM, Steve Krzysiak <> wrote:
Hey Kannan, 
OK, so I tried a simple zip code search and the query url I traced from phrets was:
http://mredllc-rets.connectmls.com:80/rets/server/search?SearchType=Property&Class=9&Query=%28%28ZP%3D60605%29%29&QueryType=DMQL2&Count=1&Format=COMPACT-DECODED&Limit=200&StandardNames=0

If I change Class=9 to CLass=DE and it works, I think this is my problem.  Should I be telling AD somewhere about my classes?

Thanks, 
Steve



On Tue, May 11, 2010 at 1:36 PM, Steve Krzysiak <> wrote:
Hi Kannan, 
I thought I was doing a simple search :p  Should I just search by zipcode?  I see no errors from the server, and I think my fields are in order since the AD is generating the proper DMQL.  It seems the conversion in phrets is what creates a bad query url.  I get a query error when using it in a browser, which should not be the case.  I have attached my chicago config, thank you for your help.
-Steve


On Tue, May 11, 2010 at 1:21 PM, kannan dan <kan...@livevaluation.com> wrote:
Steve.
sorry for the delayed response. 
does a simple search work?
can you post the mls config for chicgago that you are using or email it to me and I will get you up and running.

Also turn debugging on and see the response from the server. 
Regards
kannan

Steve Krzysiak

unread,
May 11, 2010, 3:20:28 PM5/11/10
to crt-appraisal-d...@googlegroups.com
Thanks Kannan, I actually have those on hand, just completely forgot to change that config setting.   Actually, now that I think about it, how would a user toggle between different property searches?

kannan kannan

unread,
May 11, 2010, 4:04:11 PM5/11/10
to crt-appraisal-d...@googlegroups.com
Steve,
I assume  you mean classes, like commercial / residential etc?

Look in the AD_RETS_SEARCH_CLASS in the config file. and it may require the mapping array (MAP_RESULT_STD_NAME) change as well. 

We kept it separate because often the rets access is limited to either commercial or residential. 

If your system needs both simultaneously
  • you can expose this via drop down
  • have the mapping to include both classes. or use "if" to select  the proper mapping.
  • Once the standard name is used widely, this process of mapping db names will goaway making our lifes easier. Chris of CRT may be working on that.

if no simultaneous access to resi/commercial is needed you can also have different config file for each like ( resi_il_chicago.php, comm_il_chicago.php)

regards
kannan

Steve Krzysiak

unread,
May 11, 2010, 5:10:55 PM5/11/10
to crt-appraisal-d...@googlegroups.com
I follow, I was actually referring to the more specific ones, like detached single, attached single, etc.  You suggested solutions should work regarding those.
Reply all
Reply to author
Forward
0 new messages