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."


left([rid], 8) = '14010002'

left(rid, 8) = '14010002'


rid is a text field.


Any help would be appreciated.


Thanks in advance.