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; } } }

Query Widget - Problem with SQL String

RichardLittlefield

I'm using the query widget to perform a query. However I can't seem to get my query string to do what I want. I want it to say "[field name] IS NOT NULL", how do I say that in ArcGIS Viewer for Flex?

Also the wild card character in ArcGIS Viewer for Flex is the %, correct?

Thank you.

Trouver plus de publications taguées avec

Accepted answers

GeorgeHaskett

Are the values in your attribute table <NULL> or are they simply blank, there is a difference.

I just tested an example in one of my maps and this is how I wrote the query, with CLOSEDATE as the [FIELDNAME].

NOT CLOSEDATE is NULL

This worked for me. Let me know if this format works for you.

Haskett

All comments

RichardLittlefield

Are the values in your attribute table <NULL> or are they simply blank, there is a difference.

I just tested an example in one of my maps and this is how I wrote the query, with CLOSEDATE as the [FIELDNAME].

NOT CLOSEDATE is NULL

This worked for me. Let me know if this format works for you.

Haskett

Thank you very much! It works for me.

GeorgeHaskett

Also, as for the wildcard question, here is a query I just tested and it works for my setup.

ADDRESSLINE1 LIKE '503%'

Haskett

GeorgeHaskett

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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