topic How to use parametrized query layers in ArcGIS Enterprise Questions

How to use parametrized query layers

jesdial — Wed, 14 Jun 2023 22:57:55 GMT

Dear all

I have created a parametrized query layer and published it as a mapservice. Is it possible to modify the values of the query layer parameters in the "query" operation? I have tried the "Parameters value" in the Query operation...but does not work (the values returned by the service coincide with those set as default in the "Query Parameters" option in ArcGIS Pro).

Best regards

Jesús de Diego

Re: How to use parametrized query layers

jesdial — Thu, 15 Jun 2023 06:32:52 GMT

OK; forget this... I was not introducing the correct format in the Parameters Value option in the service rest interface.

Regards

Jesús

Re: How to use parametrized query layers

Jesse — Thu, 10 Aug 2023 19:22:49 GMT

Hey there,

Could you potentially post your working example? I find myself in the same predicament but could use an example to help guide my thinking.

Thanks!

Re: How to use parametrized query layers

jesdial — Fri, 11 Aug 2023 18:42:06 GMT

Hi Jesse

Sorry for the late responst, first of all. If you already created and published the parametrized query layer, you can access to the layer REST end point in the service and open the "Query" operation.

The Where clause should be : 1 = 1 (or any other where clause you want to use, but do not leave this value blank).

Then you have to fill the “Parameter Values” parameter. The appropriate way of filling it would be :

{ “Param Name” : "String Param Value" , “Param Name” : Param Value…}

Hope this helps

Jesús de Diego

Re: How to use parametrized query layers

Jesse — Tue, 15 Aug 2023 15:34:07 GMT

MUCH appreciated, thank you for taking the time to respond!!