Using a left function in a query where clause from a rest service

jasonwriter — Thu, 02 Oct 2014 20:31:09 GMT

I'm trying to use a left function in my where clause of my query to a rest service and can't seem to figure out the syntax. I can query the underlying sql database directly using the left function but not through the esri service. Is this possible? The documentation suggests that it is; "A where clause for the query. Any legal SQL where clause operating on the fields in the layer is allowed."

tried:

left([rid], 😎 = '14010002'

left(rid, 😎 = '14010002'

rid is a text field.

Any help would be appreciated.

Thanks in advance.

topic Using a left function in a query where clause from a rest service in ArcGIS JavaScript Maps SDK Questions

Using a left function in a query where clause from a rest service