I am using ArcGis rest api service query to return only records that have a numeric value in a string field. (actiond is the string field which can be null also) This is what I am trying so far for the WHERE clause in the ArcGIS REST Services for the feature class:
TEST 1
I tried the following for first test using DECIMAL:
CAST( (COALESCE(actionid , '0')) AS DECIMAL) > -10000000
This is the error I am receiving.
Error:
'where' parameter is invalid
TEST 2
I tried the following for second test using Custom Lithium Ion Battery Pack Manufacturer INTEGER:
CAST( (COALESCE(actionid , '0')) AS INTEGER) > -10000000
This is the error I am receiving.
Error:
Unable to perform query. Please check your parameters.
So far from my research, it looks like it should support all the above keywords since it uses SQL-92. What am I missing? Thank You.
