Solved

What is the syntax used in the ESRI ArcGIS Portal Feature Service Where Clause:

Forum|Forum|4 years ago
July 14, 2021
2 replies
103 views

har40428

I've connected to my ArcGIS Portal and can read a feature service. I want to add several where clauses to narrow down this read each time. Adding "objectid">0 returns records, adding "workerid"=88 returns records, but I can't figure out the syntax to apply both in the same where clause. When using the REST API directly its just where=ObjectID>0&workerid=88 and this returns multiple records. But in FME it returns 0

Any ideas how i can combine multiple conditions in my where clause?

Best answer by andreaatsafe

Hi @har40428 ,

Try using AND to combine your where clauses - eg."objectid">0 AND "workerid"=88

Here's an example:

AGOL_Where_Clause -Andrea

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.