Re: [Qgis-user] Virtual Layer query with "currentExtent" not working anymore

[Nicolas Cadieux]

Hi,

Look at the unsubscribe link at the bottom of the email.  Next time, I 
recommend you start a new question rather than jump on a old unrelated topic.
Cheers!

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 19 janv. 2022 à 07:11, Халилов Артур Фирдусович  
> a écrit :
> 
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Virtual Layer query with "currentExtent" not working anymore

[Халилов Артур Фирдусович]

Good afternoon,
how do I unsubscribe from the mailing list?

Sincerely,
Khalilov Artur

From: Qgis-user  On Behalf Of Andrea 
Giudiceandrea
Sent: Wednesday, January 19, 2022 3:00 PM
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] Virtual Layer query with "currentExtent" not working 
anymore


Bernd 
Vogelgesang<https://www.mail-archive.com/search?l=qgis-user@lists.osgeo.org=from:%22Bernd+Vogelgesang%22>
 Wed, 19 Jan 2022 03:34:05 
-0800<https://www.mail-archive.com/search?l=qgis-user@lists.osgeo.org=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
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Virtual Layer query with "currentExtent" not working anymore

[Bernd Vogelgesang]

Hi folks,

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"

Has something changed or are there other means to achieve the same goal?

QGIS 3.22.3-Białowieża

Cheers,

Bernd




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user