Thanks for pointing that out. In this case a sqlite compatible version (I think something like `lower(NAME) LIKE '%bom%'` should work) is required.
Hope this helps Matthias On Thu, Jul 29, 2021 at 7:56 AM Andrea Giudiceandrea <[email protected]> wrote: > Il 29/07/2021 07:30, Matthias Kuhn ha scritto: > > Can you fill a bug for this? The expression compiler in QGIS should not > > forward it to ogr/gpkg/sqlite in this case. > > > > Matthias > > The Query Builder documentation [1] states that: > > "The filter is made at the data provider (OGR, PostgreSQL, MSSQL…) > level. So the syntax depends on the data provider (DateTime is for > instance not supported for the ESRI Shapefile format)" > > So I think the reported behaviour is expected. > > Regards. > > Andrea > > [1] > > https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/vector_properties.html#query-builder > _______________________________________________ > QGIS-Developer mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
