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.