Simple Query Builder Is Null

Permanently deleted user

August 14, 2014 00:08

Trying to use the Simple Query Builder to isolate records that contain null values in a particular field.

When I query the REST endpoint and view the json string, here's what I see:

{ "attributes": {

"OBJECTID": 10, "POLICE_INC": "SU13040856",

"DAMAGE_DES": " " },

In the above example, I trying to find those records that yields the DAMAGE_DES: " "

 

But when I try to apply the "Is Null" in the simple query builder, no records are found and/or DAMAGE_DES Equals " " , again, no records are found. And even if I try the "Is Not Null" , which yields records, the output field DAMAGE_DES contains no values?

If the simple query builder converts the json value back to a string, what is being returned? How can I isolate these records?

Walter

0

• 

  Permanently deleted user

  August 14, 2014 00:14

  The simple query builder json to string convertion returns a <SpaceBar> value. Therefore, if you just use a space in the simple query builder, it will return those values that are NULL or Space.

  Walter

  0
• 

  Permanently deleted user

  January 20, 2016 19:53

  A Space will return values with a space in them. Not those whose value IS NULL. There doesn't seem to be a way to search for records where the value IS NULL.

  0

Please sign in to leave a comment.