AnsweredAssumed Answered

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

Question asked by jasonwriter16 on Oct 2, 2014

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], 8) = '14010002'

left(rid, 8) = '14010002'

 

rid is a text field.

 

Any help would be appreciated.

 

Thanks in advance.

Outcomes