nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What SQL conditions does the sublayer definitionexpression recognize?

AndrewEdmonds

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.

Finde mehr Beiträge mit dem Tag

Accepted answers

AntGiles

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

All comments

rzufelt

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_

AndrewEdmonds

Thanks, Anthony. That's useful info.

AntGiles

AndrewEdmonds

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

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.