Defintion expression in Flex and defintion queries in the feature class

[AndrewEdmonds]

Here's a <definitionexpression> problem I hope somebody can help me with...

We have a single feature class from which we generate four web map services based upon a definition query on the STATUS field:

http://gis.ncdcr.gov/ArcGIS/rest/services/NC_National_Register/MapServer/0
http://gis.ncdcr.gov/ArcGIS/rest/services/NC_Study_List/MapServer/0
http://gis.ncdcr.gov/ArcGIS/rest/services/NC_Determined_Eligible/MapServer/0
http://gis.ncdcr.gov/ArcGIS/rest/services/NC_Surveyed_Only/MapServer/0

The first three services are defined using a single parameter, ie Status LIKE 'NR%'.  The last has four parameters (Status = 'SO' OR Status = 'SD' OR Status = 'SA' OR Status = 'BF').  The last is also the only of the four with a scale dependency attached to the display.

I have created a Flex site that further applies a <defintionexpression> against these four WMSs.

The definition expression works for the first three services, but not the last - all data in the service display.  Here's the code from the config file:

    <layer label="Surveyed" type="dynamic" visible="true" alpha="1"              url="http://gis.ncdcr.gov/ArcGIS/rest/services/NC_Surveyed_Only/MapServer" >   <sublayer id="0" popupconfig="popups/PopUp_Surveyed.xml"  definitionexpression="Descriptio LIKE '%Rosenwald%'"  />     </layer>                  <layer label="Determined Eligible" type="dynamic" visible="true" alpha="1"              url="http://gis.ncdcr.gov/ArcGIS/rest/services/NC_Determined_Eligible/MapServer" >   <sublayer id="0" popupconfig="popups/PopUp_DOEs.xml"  definitionexpression="Descriptio LIKE '%Rosenwald%'"  />   <sublayer id="1" popupconfig="popups/PopUp_DOEs_Bdys.xml" definitionexpression="Descriptio LIKE '%Rosenwald%'"  />     </layer>             <layer label="Study List" type="dynamic" visible="true" alpha="1"              url="http://gis.ncdcr.gov/ArcGIS/rest/services/NC_Study_List/MapServer" >   <sublayer id="0"   popupconfig="popups/PopUp_SLs.xml"   definitionexpression="Descriptio LIKE '%Rosenwald%'"  />   <sublayer id="1"   popupconfig="popups/PopUp_SLs_Bdys.xml"   definitionexpression="Descriptio LIKE '%Rosenwald%'"  />     </layer>             <layer label="National Register" type="dynamic" visible="true" alpha="1"              url="http://gis.ncdcr.gov/ArcGIS/rest/services/NC_National_Register/MapServer" >   <sublayer id="0" popupconfig="popups/PopUp_NRs.xml"  definitionexpression="Descriptio LIKE '%Rosenwald%'"  />   <sublayer id="1" popupconfig="popups/PopUp_NRs_Bdys.xml"  definitionexpression="Descriptio LIKE '%Rosenwald%'"  />     </layer>

Oddly, the pop-ups appear to work only for those points (in the last service) queried by the defintionexpression.

I suspect the problem has something to do with the multiple parameters, but does anyone know for sure?

Thanks.

[AndrewEdmonds · Accepted solution]

User error.  I'm posting the solution here in case anyone else ever runs into this.

The definition query used in ArcGIS to generate the fourth WMS - Status = 'SO' OR Status = 'SD' OR Status = 'SA' OR Status = 'BF' - was not contained within parentheses.  So, when we applied the definitionexpression in Flex against it, we got the equivalent of this:

Status = 'SO' OR Status = 'SD' OR Status = 'SA' OR Status = 'BF' AND definitionexpression="Descriptio LIKE '%Rosenwald%'"

I added parentheses to the definition query and eveything worked fine.