[Qgis-user] PostGIS raster layer filtered by attribute

[Alessandro Pasotti]

Please CC @elpaso when you file the bug, I'll assign it to me.

On Tue, Nov 8, 2022 at 8:36 PM Thayer Young <thayeray at yahoo.com> wrote:
>
> 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



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