topic Query REST service with NULL values in ArcGIS REST APIs and Services Questions

Query REST service with NULL values

WadeGivens — Tue, 26 Jul 2011 14:57:31 GMT

Hope this is the right forum for this question. I have a Map Service that I am trying to query at the REST endpoint on the server. In the "Where:" field I have (CropName = 'SOY') AND (IrrigationName Like '%') as my query, which returns 3 results. The problem is there are 10 records that match this query, with 7 of the records having 'NULL' as the value for IrrigationName. Any reason why the query I'm using is not picking up these 7 records as well?

Thanks,
Wade Givens

Re: Query REST service with NULL values

ar4 — Tue, 26 Jul 2011 17:07:43 GMT

Wade

Does that query return the expected results if fired directly at the database ?

What are you expecting? I think by putting in a LIKE you are actually saying

"Where field value is anything except null"

Re: Query REST service with NULL values

SrinivasVinnakota — Tue, 26 Jul 2011 17:09:11 GMT

Does IrrigationName contains 'NULL' string or database <NULL> values? If former what you pass in should work. If it is the latter then you should use IS NULL or IS NOT NULL sql clauses to work with <NULL> values.

If you are interested in retrieving all records irrespective of IrrigationName value then why do you specify this field in the where clause?

Re: Query REST service with NULL values

WadeGivens — Wed, 27 Jul 2011 14:14:52 GMT

Wade

Does that query return the expected results if fired directly at the database ?

What are you expecting? I think by putting in a LIKE you are actually saying

"Where field value is anything except null"

That was it exactly what the problem was. Had to modify query to include (CropName = 'SOY') AND (IrrigationName Like '%') OR (IrrigationName Is Null)

Re: Query REST service with NULL values

ar4 — Mon, 01 Aug 2011 16:42:09 GMT

Glad to see you got it working