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,
[email protected] <[email protected]> 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:[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]> wrote:
On Fri, Nov 4, 2022 at 12:18 PM <[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
ItOpen: 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
