[Rets-dev] Newb client query question

[Brad Peterson]

Our product's application has successfully integrated with a Tempo RETS 
1.5 system, and that was a breeze.

But now I'm trying to integrate with an Interealty RETS 1.5 system, and 
I'm pulling my hair out in frustration.  I've spent 3 days researching 
and pouring over the documentation, but I cannot seem to do a meaningful 
query.  I would be very grateful for some guidance in the right direction.

Currently, it seems that this RETS server is very picky about how it 
processes a query.  I also cannot get it to perform a query on what I 
ask it to.  For example, the following requests did not work for me:

Search.asmx/Search?SearchType=Property&Class=1&Query=*&Limit=25  (Result 
was <RETS ReplyCode="20203" ReplyText="Query type is not DMQL or DMQL2.">)
Search.asmx/Search?SearchType=Property&Class=1&Query=(2=1*)&Limit=25&QueryType=DMQL2 
(Result was <RETS ReplyCode="20203" ReplyText="Missing close parenthesis 
on subquery.">)

What finally retrieved results was this:
Search.asmx/Search?SearchType=Property&Class=1&Query=2=1*&Limit=25&QueryType=DMQL2

Unfortunately, it seems that no matter what I put in for the Query, such 
as Query=2=* or Query=123123123=* or Query=*, I get the same results 
over and over. 

So my question is...what am I doing wrong?  If I can just see how to 
query off one field, I can probably go from there and complete 
everything else I need.  But I can't ever seem to get queries to give me 
anything than the same set of results over and over again.

To help, here is some info returned from a 
GetMetadata.asmx/GetMetadata?type=METADATA-SYSTEM&id=* request

<Resource>
  <ResourceID>Property</ResourceID>
  <StandardName>Property</StandardName>
  <VisibleName>Property</VisibleName>
  <Description>MLS Property Table</Description>
...
  <METADATA-CLASS System="LASRETS" Resource="Property" 
Version="13.37.90495" Date="Tue, 26 Sep 2006 19:01:35 GMT">
    <Class>
      <ClassName>1</ClassName>
      <StandardName>ResidentialProperty</StandardName>
      <VisibleName>RES</VisibleName>
      <Description>Residential</Description>
      <METADATA-TABLE System="LASRETS" Resource="Property" Class="1" 
Version="13.37.90495" Date="Tue, 26 Sep 2006 19:01:35 GMT">
        ....
        <Field>
          <SystemName>2</SystemName>
          <StandardName/>
          <LongName>Approximate Acreage</LongName>
          <DBName/>
          <ShortName>Acreage</ShortName>
          <MaximumLength>8</MaximumLength>
          <DataType>Decimal</DataType>
          <Precision>3</Precision>
          <Searchable>1</Searchable>
          <Interpretation>Number</Interpretation>
          <Alignment/>
          <UseSeparator>0</UseSeparator>
          <EditMaskID/>
          <LookupName/>
          <MaxSelect>0</MaxSelect>
          <Units/>
          <Index>0</Index>
          <Minimum/>
          <Maximum/>
          <Default>0</Default>
          <Required>0</Required>
          <SearchHelpID/>
          <Unique>0</Unique>
        </Field>
...


Brad Peterson