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.