How to create a query with unique results

[MichaelBell]

I'm using Experience Builder to find features and, hopefully, extract a value from those features.

We have several features with the same reference number. They are different features due to slight differences in other aspects of the data, but geographically they are grouped together.

Basically, imagine a group of houses on the same Street, with a Street attribute. What I'd like to do is select the Street, from a list of unique values, and have all the houses on that street selected, as well as extracting another value from those houses (let's say Town, which would be the same for all the houses on that Street) for use elsewhere.

Any ideas? I've tried a few things, including attempting to build my own widget, lists (doesn't allow for unique values), queries (seems great but, as far as I can tell, doesn't allow for unique values or for the value to be used elsewhere), and now just looking at the filter widget.

[JeffreyThompson2]

I'm having a bit of trouble picturing what exactly you are trying to do. I think this build might be what you are looking for.

1. Add a Select Widget and use an Attribute Selection to select values.
2. Add a List Widget and set it to the Selected Data View of the data.
3. Inside the List Widget, use a Text Widget with Dynamic Text to show your results.

[MichaelBell]

Well that was idiotic of me. And ESRI. But mostly me.

I didn't know (and ESRI don't make it obvious) that text boxes have a dynamic content option. It's not exactly as I wanted, and it'll require some careful coaching with people, but I basically created a text box which linked to the maximum value from the query widget. Users will have to ensure they don't click on entries they're not supposed to (say, from different streets), but it gets us something that's at least usable.