[Qgis-user] PostGIS raster layer filtered by attribute

[Thayer Young]

 Hi Dirk,
I have not seen a bug report for this yet. Would you like me to issue one?
I was able to reproduce that the provider for views of raster tables did work in 3.10 but stopped working by 3.14.
-Thayer


    On Friday, November 4, 2022 at 08:06:48 AM EDT, Alessandro Pasotti <apasotti at gmail.com> wrote:  
 
 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
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20221108/9e027137/attachment.htm>