topic Re: Filter widget for multiple tables in ArcGIS Experience Builder Questions

Filter widget for multiple tables

doronwen — Tue, 24 Dec 2024 14:24:39 GMT

Can a single filter widget sort more than one table at a time?
I know you can have multiple tables connected to a single filter, but in the widget itself you can add a SQL Expression only to individual tables.

Example: Table A, Table B and Table C all have different data, but they also have a common field named "Region". When a user select region 1 for example, I'd like all three table to be filtered on region 1.
Right now I have 3 filters - one for each table - and I can't find a way around it.

Re: Filter widget for multiple tables

Ke_Xu — Thu, 26 Dec 2024 10:47:19 GMT

Hi @doronwen,

You could create a Group filter. Add three tables and build SQL expressions based on the common filter "Region".

Thanks,

Re: Filter widget for multiple tables

doronwen — Thu, 26 Dec 2024 15:54:11 GMT

Hi @Ke_Xu

Your solution does appears to be what I'm looking for, but I do not see this option in ExB and I'm on 11.1
What version of enterprise are you running?

Re: Filter widget for multiple tables

Ke_Xu — Mon, 30 Dec 2024 01:02:12 GMT

Hi @doronwen,

Group filter was released on ArcGIS Online in February 2024 and ArcGIS Enterprise 11.3.

Thanks,

Re: Filter widget for multiple tables

doronwen — Tue, 31 Dec 2024 14:00:19 GMT

OK, that's the reason I'm not seeing it. I think my organization is pretty far way from upgrading to 11.3.

Thanks @Ke_Xu