Re: [Qgis-user] query for Virtual Layer in relation to another layer

- Von: Qgis-user Im Auftrag von Uwe Fischer via Qgis-user Gesendet: Freitag, 4. November 2022 14:19 An: 'Jürgen E. Fischer' Cc: qgis-user Betreff: Re: [Qgis-user] query for Virtual Layer in relation to another layer Moin moin, that's exactly the information I was looking for. Thanks again

Re: [Qgis-user] query for Virtual Layer in relation to another layer

@lists.osgeo.org Betreff: Re: [Qgis-user] query for Virtual Layer in relation to another layer Moin Uwe, On Fri, 04. Nov 2022 at 13:59:35 +0100, Uwe Fischer wrote: > great - it works as expected!! Thank you! > How can I find out about the engine that is used and the SQL syntax > for virtu

Re: [Qgis-user] query for Virtual Layer in relation to another layer

Moin Uwe, On Fri, 04. Nov 2022 at 13:59:35 +0100, Uwe Fischer wrote: > great - it works as expected!! Thank you! > How can I find out about the engine that is used and the SQL syntax for > virtual layers? I'd like to learn about it to be able to build more queries > like this one. Well, || is

Re: [Qgis-user] query for Virtual Layer in relation to another layer

Jürgen, great - it works as expected!! Thank you! How can I find out about the engine that is used and the SQL syntax for virtual layers? I'd like to learn about it to be able to build more queries like this one. Thanks again and best regards, Uwe Jürgen wrote: Not sure which engine

Re: [Qgis-user] query for Virtual Layer in relation to another layer

On Fri, 04. Nov 2022 at 12:32:29 +0100, Uwe Fischer via Qgis-user wrote: > On Montag, 24. Oktober 2022 15:32, Reetz, Michael (NLPV) wrote: > > you could try this: > > select * from my_lines l join my_polys p on l.my_line_attribute like '%' + > > p.my_poly_attribute + '%' > sorry for the delay, I

Re: [Qgis-user] query for Virtual Layer in relation to another layer

Eime Tel.: 05182/8325 Mobil: 0172/8876934 Von: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] Im Auftrag von Reetz, Michael (NLPV) via Qgis-user Gesendet: Montag, 24. Oktober 2022 15:32 An: qgis-user@lists.osgeo.org Betreff: Re: [Qgis-user] query for Virtual Layer in relation to another

Re: [Qgis-user] query for Virtual Layer in relation to another layer

: [Qgis-user] query for Virtual Layer in relation to another layer ACHTUNG!! Diese E-Mail erreicht Sie von einem Absender außerhalb der niedersächsischen Landesverwaltungs-Infrastruktur mit TLS-Verschlüsselung. Bitte klicken Sie auf keine Links oder öffnen Sie keine E-Mail-Anhänge, falls Sie den

[Qgis-user] query for Virtual Layer in relation to another layer

Hello, I am looking for a way to create a virtual layer in 3.24 in a 'special' way. I have a line layer with attributes like: _123_x _abc_000_123_0 and a polygon layer with attributes like: abc 123 Now, I would like to use only lines that contain one of the