Simple Query Builder Is Null
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
-
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 -
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
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
2 Kommentare