[Qgis-user] Adding a form for filtering data with several criteria

[Reetz, Michael (NLPVW)]

Dear group,

I have a table in an SQL Server database with the occurrence data from GBIF for our national parc area (round about 350.000 records since 1986). I've added geometry attributes and integrated the table in a QGIS project.

Now I want to add a form that allows the users to filter the data for taxonomic units from kingdom to species by selecting the values from dropdown lists. I've created the form in the Qt Designer but have no idea how to integrate it in the QGIS project, populate the dropdown lists with values from the table and add a filter command to the "filter" button. I've found some instructions how to use a form with static lists for layer editing but not for filtering data with dynamic lists.

Has anybody an idea where I can find an instruction for this?

Thanks in advance.

Cheers,
Michael



Mit freundlichen Grüßen
Im Auftrag

Michael Reetz

*****************************************
Michael Reetz
Datenbanken und Anwendungsentwicklung
Nationalpark-Verwaltung Niedersächsisches Wattenmeer
Virchowstr. 1 | 26382 Wilhelmshaven
Tel.: +49 (0) 4421 911 291
e-mail: michael.reetz at nlpvw.niedersachsen.de<mailto:michael.reetz at nlpv-wattenmeer.niedersachsen.de>
Web: https://www.<https://www./>nationalpark-wattenmeer.de
[cid:image002.png at 01DADDE8.C7D7A2C0]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240724/91c224ab/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 6526 bytes
Desc: image002.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240724/91c224ab/attachment-0001.png>