<html><head></head><body><div class="ydp988e1af2yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr" data-setdir="false">Hi Dirk,</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I have not seen a bug report for this yet. Would you like me to issue one?</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I was able to reproduce that the provider for views of raster tables did work in 3.10 but stopped working by 3.14.</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="ydpfbaeeb80yahoo_quoted_8639302243" class="ydpfbaeeb80yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Friday, November 4, 2022 at 08:06:48 AM EDT, Alessandro Pasotti <apasotti@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">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?<div class="ydpfbaeeb80yqt0891032533" id="ydpfbaeeb80yqtfd68327"><br clear="none"><br clear="none"><br clear="none">-- <br clear="none">Alessandro Pasotti<br clear="none">QCooperative: www.qcooperative.net<br clear="none">ItOpen: www.itopen.it<br clear="none"></div></div></div>
</div>
</div></body></html>