topic Re: Filtering with URL Paramaters using Contains or Wildcard in ArcGIS Experience Builder Questions

Filtering with URL Paramaters using Contains or Wildcard

DarraghOSullivan — Fri, 30 Aug 2024 07:51:35 GMT

Is there any way to filter with URL Parameters equivalent to a 'contains' query? My use case is for recreational trails, many of which cross county boundaries, so the County field has multiple values (comma separated). URL parameters are ideal for my use case to filter by county, but using County="Dublin" only returns trails that are entirely within that county. County="*Dublin*" or similar would be ideal. Any ideas?

Re: Filtering with URL Paramaters using Contains or Wildcard

Shen_Zhang — Mon, 02 Sep 2024 08:19:26 GMT

You can use LIKE to filter data with certain patterns, for example here I have a list of countries and I tried to filter countries whose names have "United". I used the following:

?data_filter=<dsID>:COUNTRY LIKE 'United%'

and the encoded version of it would be:

?data_filter=<dsID>:COUNTRY%20LIKE%20%27United%25%27

It gave me the following result:

Re: Filtering with URL Paramaters using Contains or Wildcard

DarraghOSullivan — Mon, 02 Sep 2024 09:18:46 GMT

Thank you @Shen_Zhang , that has worked perfectly! Is there a list of such available operators somewhere?

Re: Filtering with URL Paramaters using Contains or Wildcard

Shen_Zhang — Mon, 02 Sep 2024 09:29:44 GMT

data_filter uses standard WHERE clause syntax, so basically whatever works in WHERE clauses, it should also work here.

Re: Filtering with URL Paramaters using Contains or Wildcard

DarraghOSullivan — Mon, 02 Sep 2024 09:31:11 GMT

Super, thanks again