[Qgis-user] Loading filtered database table as temp layer

[Michael Gieding]

Hello Richard,

thank you for the addition. But I fear, that this is not suitable for my target group.
Difficult enough for them to get the basics in QGIS. So it would be nice to offer a simple
tool for their work.
Maybe a good chance for me to dive into plugin programming. Seems to be a reachable
goal.


Kind regards,
Michael Gieding


________________________________________
Von: Richard McDonnell <richard.mcdonnell at opw.ie>
Gesendet: Dienstag, 4. Mai 2021 10:58
An: Michael Gieding; QGIS-User Mailinglist
Cc: thayeray at yahoo.com
Betreff: RE: Loading filtered database table as temp layer

Hi Michael,

To add to Thayer's message.

There is currently no way to do exactly what you are looking for, but, I would suggest the following as an alternative, which is simple enough to follow…



There are three ways to load a filtered layer into QGIS

Firstly, You can load a Layer using SQL Filter using the either the Data Source Manager or DB Manager.

1.       Data Source Manager will allow you to use the Set Filter option on your selected Table

2.       DB Manager will do the same when you highlight the Layer you want to load and click on the SQL Window [cid:image002.png at 01D740CC.14351C50]

3.       Load the Layer in in its entirety, then use the Filter option by right clicking on the layer and selecting Filter.



Whichever of the above you use, the Filtered Layers can be temporally saved out as whatever format you would like while being worked on. This can be achieved by right clicking on the layer, selecting Export => Save Feature As



I Hope that helps in some way.



Regards,



Richard







——
Richard McDonnell MSc GIS, FME Certified Professional
FRM Data Management

——
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 46 942 2409
https://gov.ie/opw