topic Re: How to write two where clause in URL Parameter? in ArcGIS Experience Builder Questions

How to write two where clause in URL Parameter?

GeeteshSingh07 — Tue, 05 Mar 2024 08:53:55 GMT

Hi Everyone, I am looking for a way to write two 'where clauses' in the URL parameter. Using this URL, the feature ID with UID=4 will be selected. https://experience.arcgis.com/experience/fd354455c7154e8d8a554f7c6da465ba/?draft=true#data_s=where:dataSource_1-states_new_7065:UID=4 I want to set the query "WHERE UID =4,5,6,7", then, is there a way to achieve this? Reference: https://doc.arcgis.com/en/experience-builder/latest/build-apps/url-parameters.htm#GUID-ADD3075D-D8DE-4A32-85F2-598A34F830CB:~:text=When%20the%20selection%20type%20is%20id%2C%20you%20are%20selecting%20features%20by%20their%20recordIDs.%20If%20you%20are%20selecting%20multiple%20records%20from%20the%20same%20data%20source%2C%20recordIDs%20are%20separated%20by%20plus%20signs%20(%2B).%20The%20follow%20is%20an%20example%3A As per the document, there are three selection types: id, geometry, and where. Does id only works for ObjectID field or is there a way we can use different field as ID?

Re: How to write two where clause in URL Parameter?

Shen_Zhang — Wed, 06 Mar 2024 07:12:48 GMT

Hi @GeeteshSingh07

The id type only works for OID or FID. If you want to use select for other fields, you should use where clauses, For example in your case:

"WHERE UID =4,5,6,7", you can use

#data_s=where:<dataSource_ID>:UID%20IN%20(4%2C5%2C6%2C7)

And if you want to add another clause, you can use AND to concatenate them, just like any standard where clause does:

#data_s=where:<dataSource_ID>:UID IN (4,5,6,7) AND City = ’LA’

And please encode the data_s parameter value to make sure it work, like the following:

#data_s=where:<dataSource_ID>:UID%20IN%20(4%2C5%2C6%2C7)%20AND%20City%20%3D%20’LA’%20

Furthermore, if you're not sure how to write a SQL clause, you can use Select widget to set up a SQL expression. Here are the steps for your reference:

1. Add a table widget and create a sheet with the data you like (so you can see the result from URL parameters)

2. Add a select widget, choose Select by Attributes. Click Add new data and select the same data of that you chose for table

3. Click SQL Expression Builder to set up the clauses.

4. Save the app and go to preview. Click Attribute selection and enable the toggle appeared below.

At this time, you should be able to see the data_s with a where clause. You can try different SQL expressions to explore.

Hope this info can help as you explore URL parameters. Please come to us anytime you run into issues. thanks!

Re: How to write two where clause in URL Parameter?

ArunChetty — Mon, 24 Jun 2024 12:31:26 GMT

Hi @Shen_Zhang . Is there a way to automatically pan and zoom based on data_s=where? Let me explain myself, when I use data_s=id it automatically pan and zoom the ObjectID, but when I use data_s=where it won't do that.

Thanks in advance for any help

Re: How to write two where clause in URL Parameter?

Shen_Zhang — Fri, 28 Jun 2024 00:49:03 GMT

Zoom to feature by data_s where clauses is not supported yet, we're still working on it. Now you can use the zoom_to_selection=true parameter to zoom to a feature selected by id.