Filter widget for multiple tables

[doronwen]

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. 

[Ke_Xu]

Hi @doronwen,

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

Thanks,

Ke

[doronwen]

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?

[Ke_Xu]

Hi @doronwen,

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

Thanks,

Ke

[doronwen]

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