[Qgis-user] PostGIS raster layer filtered by attribute

[Alessandro Pasotti]

On Fri, Nov 4, 2022 at 12:18 PM <Dirk.Pispers at stadt-koeln.de> wrote:
>
> Thanks to Thayer and Alesandro.
> I made a lot of tests today. Not all is working, but it's on a good way.
>
> I did not see the "Filter" option on the raster layer in QGIS 3.22 because I searched in the layer properties analog to where the filter is placed for vector layers.
> The filter option works in general but throws a lot of critical errors, when no raster is in  the result of the filter query.
>
> Another solution I tried is to use a view where the raster table is filtered.
> This works in QGIS 3.10 but not in 3.22, where QGIS generates an invalid query against the PostgreSQL catalog when adding the raster layer.
>

Sounds like a bug to me.

Can you file a ticket with all the necessary information and a minimal
SQL dump to reproduce the issue?


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it