topic Consuming Parameterized Query layers from web apps in Publishing and Managing Services Questions

Consuming Parameterized Query layers from web apps

raja-gs — Mon, 31 Jan 2022 05:09:55 GMT

Hello,
We're planning to create a Query layer which would reference data from a registered Oracle DB. I see that Query layer accepts range and discrete parameters. Once a feature layer is published with parameters setup, we're looking to consume that layer/map in our custom web application via ArcGIS JavaScript API v4.22. I don't see any documentation on how to pass parameter values via JavaScript.

Is it even possible or parameters are supported only in ArcPro? What are the clients that support Query layer params? Thanks.

Re: Consuming Parameterized Query layers from web apps

TanuHoque — Tue, 01 Feb 2022 01:44:42 GMT

hi @raja-gs

Here is simple sample that I just came up with and I hope you might find it helpful
https://codepen.io/thoquews/pen/gOXPQbG?editors=1000

This will allow you to aggregate data for any slice or combination of slices. In my example, it is showing total crimes per districts for selected crime types. These results are generated dynamically -- as you realized the polygon layer does NOT have any crime related attributes. I have a point layer that represents crime locations and types. For each request, the results are aggregated dynamically from the point layer and being joined to the polygon layer to visualization.

pls let me know if you have any question.

Re: Consuming Parameterized Query layers from web apps

raja-gs — Tue, 01 Feb 2022 02:49:21 GMT

Thanks so much @TanuHoque ! I tried your sample and it looks like it will work for us. I'll try this out. Thanks again for spending time on this

Re: Consuming Parameterized Query layers from web apps

TanuHoque — Tue, 01 Feb 2022 18:40:25 GMT

I'm glad you found it helpful