Hi Tobias, On Tue, 26. Feb 2019 at 13:09:22 +0100, Tobias Wendorff wrote: > on QGIS 3.4, 3.6 and master, the good old provider filtering on > shapefiles (DBF) doesn't seem to work: LEFT("RS", 5) = '05'
Doesn't work in ogrinfo for me either. "left" doesn't look like ogrsql or sqlite dialect to me. Neither works in 2.18 either for me - neither w/ or w/o "Execute expression on server-side, if possible" checked. It works as QGIS expression however. Where did it work as filter for you? 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 FreeNode
signature.asc
Description: PGP signature
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Juergen Fischer, Nils Kutscher HR: Amtsgericht Aurich HRB 100827 Datenschutzerklaerung: https://www.norbit.de/83/
_______________________________________________ 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