I have to deal with a QGIS project containing a huge number of layers. To bring order into the project and filter the information respectively layers I need, I am looking for a way to filter the layers by their name (using a substring of the name) either:
- in the Layers panel using the expression builder or
- in the DB Manager using SQL to create a virtual layer (with the UNION function?)
I tried several ways/expressions in both methods, but could not find a way to achieve my goal.