nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filtering with URL Paramaters using Contains or Wildcard

DarraghOSullivan

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?

Vind meer berichten getagd met

ArcGIS Online

Accepted answers

Shen_Zhang

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:

Screenshot 2024-09-02 at 16.14.24.png

All comments

DarraghOSullivan

Super, thanks again

Shen_Zhang

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

DarraghOSullivan

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

Shen_Zhang

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:

Screenshot 2024-09-02 at 16.14.24.png

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.