Skip to main content
Solved

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


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

View original
Did this help you find an answer to your question?

2 replies

andreaatsafe
Safer
Forum|alt.badge.img+12
  • Safer
  • Best Answer
  • July 14, 2021

Hi @har40428​ ,

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

 

Here's an example:

AGOL_Where_Clause-Andrea


  • Author
  • July 16, 2021

Thank you - that worked


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings