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.

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.