[Qgis-user] PostGIS raster layer filtered by attribute

[Thayer Young]

 Thanks again Dirk for pointing out this bug. I submitted the report and copied Alessandro. Happy mapping!
https://github.com/qgis/QGIS/issues/50841
-Thayer


    On Wednesday, November 9, 2022 at 12:42:30 AM EST, Dirk.Pispers at STADT-KOELN.DE <dirk.pispers at stadt-koeln.de> wrote:  
 
 
Hi Thayer,
 
  
 
sorry, I’m very busy at the moment.
 
It would be very kind, if you open the issue.
 
Thanks.
 
  
 
Dirk
 
  
 
Von: Thayer Young [mailto:thayeray at yahoo.com]
Gesendet: Dienstag, 8. November 2022 20:37
An: Pispers, Dirk <Dirk.Pispers at STADT-KOELN.DE>; Alessandro Pasotti <apasotti at gmail.com>
Cc: qgis-user at lists.osgeo.org
Betreff: Re: [Qgis-user] PostGIS raster layer filtered by attribute
 
  
 
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/20221109/bd3b3cff/attachment.htm>