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:[email protected]] Gesendet: Dienstag, 8. November 2022 20:37 An: Pispers, Dirk <[email protected]>; Alessandro Pasotti <[email protected]> Cc: [email protected] 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 <[email protected]<mailto:[email protected]>> wrote: On Fri, Nov 4, 2022 at 12:18 PM <[email protected]<mailto:[email protected]>> 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<http://www.qcooperative.net> ItOpen: www.itopen.it<http://www.itopen.it>
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
