<html><head></head><body><div class="ydpe28b2f86yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;" dir="ltr" data-setdir="false"><div></div>
<div dir="ltr" data-setdir="false">Thanks again Dirk for pointing out this bug. I submitted the report and copied Alessandro. Happy mapping!</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><a href="https://github.com/qgis/QGIS/issues/50841" rel="nofollow" target="_blank" class="">https://github.com/qgis/QGIS/issues/50841</a></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">-Thayer</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><br></div><div><br></div>
</div><div id="ydp8288e3cayahoo_quoted_8278997673" class="ydp8288e3cayahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, November 9, 2022 at 12:42:30 AM EST, Dirk.Pispers@STADT-KOELN.DE <dirk.pispers@stadt-koeln.de> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp8288e3cayiv2083905458"><div>
<div class="ydp8288e3cayiv2083905458WordSection1">
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;">Hi Thayer,</span></p>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;"> </span></p>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;">sorry, I’m very busy at the moment.</span></p>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;">It would be very kind, if you open the issue.</span></p>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;">Thanks.</span></p>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;"> </span></p>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;">Dirk</span></p>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;"> </span></p>
<div id="ydp8288e3cayiv2083905458yqt68434" class="ydp8288e3cayiv2083905458yqt5985913380"><div>
<div style="border-color: rgb(225, 225, 225) currentcolor currentcolor; border-style: solid none none; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p class="ydp8288e3cayiv2083905458MsoNormal"><b><span style="font-size:11.0pt;font-family:sans-serif;">Von:</span></b><span style="font-size:11.0pt;font-family:sans-serif;"> Thayer Young [mailto:thayeray@yahoo.com]
<br clear="none">
<b>Gesendet:</b> Dienstag, 8. November 2022 20:37<br clear="none">
<b>An:</b> Pispers, Dirk <Dirk.Pispers@STADT-KOELN.DE>; Alessandro Pasotti <apasotti@gmail.com><br clear="none">
<b>Cc:</b> qgis-user@lists.osgeo.org<br clear="none">
<b>Betreff:</b> Re: [Qgis-user] PostGIS raster layer filtered by attribute</span></p>
</div>
</div>
<p class="ydp8288e3cayiv2083905458MsoNormal"> </p>
<div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">Hi Dirk,</span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">I have not seen a bug report for this yet. Would you like me to issue one?</span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">I was able to reproduce that the provider for views of raster tables did work in 3.10 but stopped working by 3.14.</span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">-Thayer</span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
</div>
<div id="ydp8288e3cayiv2083905458ydpfbaeeb80yahoo_quoted_8639302243">
<div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">On Friday, November 4, 2022 at 08:06:48 AM EDT, Alessandro Pasotti <<a shape="rect" href="mailto:apasotti@gmail.com" rel="nofollow" target="_blank">apasotti@gmail.com</a>> wrote:
</span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<div>
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">On Fri, Nov 4, 2022 at 12:18 PM <<a shape="rect" href="mailto:Dirk.Pispers@stadt-koeln.de" rel="nofollow" target="_blank">Dirk.Pispers@stadt-koeln.de</a>> wrote:<br clear="none">
><br clear="none">
> Thanks to Thayer and Alesandro.<br clear="none">
> I made a lot of tests today. Not all is working, but it's on a good way.<br clear="none">
><br clear="none">
> 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.<br clear="none">
> The filter option works in general but throws a lot of critical errors, when no raster is in the result of the filter query.<br clear="none">
><br clear="none">
> Another solution I tried is to use a view where the raster table is filtered.<br clear="none">
> 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.<br clear="none">
><br clear="none">
<br clear="none">
Sounds like a bug to me.<br clear="none">
<br clear="none">
Can you file a ticket with all the necessary information and a minimal<br clear="none">
SQL dump to reproduce the issue?</span></p>
<div id="ydp8288e3cayiv2083905458ydpfbaeeb80yqtfd68327">
<p class="ydp8288e3cayiv2083905458MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"><br clear="none">
<br clear="none">
<br clear="none">
-- <br clear="none">
Alessandro Pasotti<br clear="none">
QCooperative: <a shape="rect" href="http://www.qcooperative.net" rel="nofollow" target="_blank">www.qcooperative.net</a><br clear="none">
ItOpen: <a shape="rect" href="http://www.itopen.it" rel="nofollow" target="_blank">www.itopen.it</a></span></p>
</div>
</div>
</div>
</div>
</div></div>
</div>
</div></div></div>
</div>
</div></body></html>