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.

Vind meer berichten getagd met

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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