How to build dynamic SQL based on URL query parameters.

BolekBolek — Thu, 12 Dec 2019 14:38:06 GMT

I have an ArcGIS layer published to my local server at:

I want to dynamically construct the query where clause for this layer based on the URL. For example:

would effectively translate into the following:

where category='cat1'

How can I accomplish this?

The arcgsis documentation touches on the topic:

https://pro.arcgis.com/en/pro-app/help/data/query-layers/update-parameter-values-in-a-query-layer.htm

https://www.esri.com/arcgis-blog/products/sharing-collaboration/sharing-collaboration/using-url-parameters-in-web-apps/

https://developers.arcgis.com/labs/arcgisonline/query-a-feature-layer/

Based on this it seems like it would be possible to pass query parameters like this:

and then refer to them in the definition query:

category=::category

But it doesn't work, ArcMap throws an SQL syntax error complaining about ::category.

topic How to build dynamic SQL based on URL query parameters. in ArcGIS REST APIs and Services Questions