Select to view content in your preferred language

Filter One Layer by a Value Existing in Multiple Fields

222
0
02-19-2025 10:51 AM
Labels (1)
AnninaRupe1
Frequent Contributor

I have created a hub in Experience Builder that contains several pages. The main ones are a map page and a summary page.

On the map page, I have a map with an editable hosted feature layer where we are keeping track of practices that have been implemented on tracts of land. Each record contains a polygon and many attributes, including Practice 1, Practice 2, Practice 3, Practice 4, and Practice 5. The user fills out the record by selecting an implemented practice from a domain list under the "Practice 1" field. If there are multiple practices implemented on the tract, they repeat the process for each subsequent practice in the subsequent practice fields. Each practice field has the exact same domain list.

On the summary page, users can see the attribute table of the hosted feature layer. I'm building different filters so the user can summarize fields in the ExB or export the filtered table to CSV for further analysis. They need the capability of filtering by the different practices across all 5 of the practice fields. This can be done in the Filter widget by creating a "Clause Set" and asking for user input, which allows the user to select a value from the list. However, the user has to select the practice 5 times to search all 5 practice fields for one type of practice. I was wondering if there is a way to select the practice once but filter all 5 fields?

Here's the filter that works (but is unneccessarily duplicative):

AnninaRupe1_1-1739990858686.png

I've tried creating a Group Filter but even though I've selected all 5 fields in the "All fields" section, the "Main field" is the only one that's being filtered. Below is an example of what this looks like. I've selected "No-till" from the list, but the only records showing in the filtered list are the ones that have "No-till" in the first practice field (purple lines), not in 2 or 3. 

AnninaRupe1_0-1739990350084.png

 

0 Kudos
0 Replies