topic Re: What SQL conditions does the sublayer definitionexpression recognize? in ArcGIS Viewer for Flex Questions

What SQL conditions does the sublayer definitionexpression recognize?

AndrewEdmonds — Tue, 13 Nov 2012 17:46:35 GMT

What SQL conditions does the sublayer definitionexpression in the config file recognize?

I have tried LIKE, NOT LIKE, <>, and != to no avail. I get a 1095 syntax parsing error on some on these.

Re: What SQL conditions does the sublayer definitionexpression recognize?

AndrewEdmonds — Tue, 13 Nov 2012 18:05:47 GMT

Never mind, LIKE and NOT LIKE appear to work! I must have missed a quotation mark.

Re: What SQL conditions does the sublayer definitionexpression recognize?

AnthonyGiles — Tue, 13 Nov 2012 18:11:14 GMT

Andrew,

Just for info if you ever need to do so in the future, you cannot use < and > in the config file as these are reserved for the opening and closing of tags. You need to use < and >

Regards

Anthony

Re: What SQL conditions does the sublayer definitionexpression recognize?

AndrewEdmonds — Tue, 13 Nov 2012 18:19:25 GMT

Thanks, Anthony. That's useful info.

Re: What SQL conditions does the sublayer definitionexpression recognize?

RhettZufelt — Fri, 10 Dec 2021 21:47:28 GMT

This works:

            <layer label="WastePoints" type="feature" visible="true" alpha="0.3"               
               definitionexpression="PHOTOS LIKE '%100D63_01.jpg'"
               url="http://gis01.wch-rcc.com/ArcGIS/rest/services/rkz/waste_images/MapServer/0"/>

other example for the same layer that work:

definitionexpression="PHOTOS IS NULL"

definitionexpression="PHOTOS = '100D63_01.jpg' "

definitionexpression="PHOTOS IS NOT NULL"

Basically the same coding as ArcMap but, you need to set it equal to definitionexpression and remember to include the single quotes if not comparing NULL(s)

also, this post shows how to code it for "dynamic" layers: http://forums.arcgis.com/threads/64884-Popups-on-multiple-copies-of-same-service-layer?p=248918#post248918

R_