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 · Accepted solution]

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

[GeorgeHaskett]

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

ADDRESSLINE1 LIKE '503%'

Haskett

[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.