Arcgis rest api service - query to check for numeric in a string field

BenSteele — Tue, 20 Sep 2022 09:44:12 GMT

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.

topic Arcgis rest api service - query to check for numeric in a string field in ArcGIS JavaScript Maps SDK Questions

Arcgis rest api service - query to check for numeric in a string field