Good afternoon, how do I unsubscribe from the mailing list? Sincerely, Khalilov Artur
From: Qgis-user <[email protected]> On Behalf Of Andrea Giudiceandrea Sent: Wednesday, January 19, 2022 3:00 PM To: [email protected] Subject: [Qgis-user] Virtual Layer query with "currentExtent" not working anymore Bernd Vogelgesang<https://www.mail-archive.com/[email protected]&q=from:%22Bernd+Vogelgesang%22> Wed, 19 Jan 2022 03:34:05 -0800<https://www.mail-archive.com/[email protected]&q=date:20220119> A while ago, I figured out how to limit a query on a layer by the current map extent as a preparation for another query: SELECT * FROM ASK_Geometrien WHERE st_intersects(ASK_Geometrien.geometry, currentExtent()); Now, when I try it again later, the test fails with "no such function: currentExtent" Hi Bernd, AFAIK there is no currentExtent() inbuilt function. You need to define a custom currentExtent() function that returns the current extent. Please see, for example: https://gis.stackexchange.com/questions/303325/how-to-speed-up-a-query-in-a-virtual-layer-of-qgis Best regards. Andrea Giudiceandrea
_______________________________________________ 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
