topic Re: Query Widget - Problem with SQL String in ArcGIS Viewer for Flex Questions

Query Widget - Problem with SQL String

RichardLittlefield — Fri, 04 Apr 2014 12:10:04 GMT

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.

Re: Query Widget - Problem with SQL String

GeorgeHaskett — Fri, 04 Apr 2014 15:07:42 GMT

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

Re: Query Widget - Problem with SQL String

GeorgeHaskett — Fri, 04 Apr 2014 15:10:37 GMT

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

ADDRESSLINE1 LIKE '503%'

Haskett

Re: Query Widget - Problem with SQL String

RichardLittlefield — Fri, 04 Apr 2014 15:32:10 GMT

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.