Within QGIS, you can obviously categorise by a field. This gives you the ability to select individual categories visibility (e.g. a name or similar.) Is there a way that I can cascade this selection to another layer, with an identical set of categories?
I've tried joining and using 'is_layer_visible' and 'is_selected' but this is not working (as presumably that is giving you layer level, not item level filtering.)
I have come up with a temporary solution currently, which is to filter the SQL query for each layer, split the shape files and layers, and put into groups. But this is slow and a big buggy.