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

[Uwe Fischer]

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 virtual layers actually use, but I'd try || instead of + 

As in

sqlite> select '%' || 'foo' || '%';
%foo%

instead of

sqlite> select '%' + 'foo' + '%';
0


Jürgen

-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden            https://www.norbit.de
QGIS release manager (PSC)  Germany                 IRC: jef on Libera|OFTC