[Qgis-user] Use form with checkboxes to alter a query?

Bernd Vogelgesang bernd.vogelgesang at gmx.de
Thu Dec 12 09:12:17 PST 2019


Hi,

I have a layer with over 150 polygons, where 20 to 30 of them change
their access status on a daily base. The information about the status
comes in a quiet unstructured pdf, so there is no way to automatically
read that in.

At the moment, I query the layer through a virtual layer like this to
show the subset of restricted areas:

SELECT *
FROM areas
WHERE name IN ('a','b','c','l','p', 'x','y','z')

It is quite a tedious job to fiddle in the names into the query string
every time, so I wonder if anyone knows a way, how to connect a form
with check boxes of those area names, so when I submit it,
only the checked names will be inserted in that query.

I'm quite sure that this should be possible somehow, but I lack of any
idea where to start. Or maybe solve this on a complete different way?

Cheers,
Bernd


--
Dipl.-Geogr.
Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374


More information about the Qgis-user mailing list