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.

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