Hi Calvin,
This definitely sounds like the sort of thing you want to be doing in
the data provider and not in QGIS!
Maybe Fast Text Search would be of use. Problem is that I'm not sure if
it's included in the GeoPackage spec or QGIS' SQLite install, but it's
in the default pre-compiled
Ultimately what I am trying to do is to revamp the Search Layers plugin (
https://plugins.qgis.org/plugins/searchlayers/) to allow searching using
two different strings with NOT, AND, OR operators, case dependent or
independent, with qualifiers where the strings are an exact match, within
the
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…)
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
wrote:
> Il 29/07/2021 07:30, Matthias Kuhn ha scritto:
> > Can you
On Thu, 29 Jul 2021 at 15:31, Matthias Kuhn wrote:
>
> Can you fill a bug for this? The expression compiler in QGIS should not
> forward it to ogr/gpkg/sqlite in this case.
My interpretation is that Calvin is setting a layer filter, so QGIS
expressions aren't involved (i.e. no bug).
Nyall
>
>
Can you fill a bug for this? The expression compiler in QGIS should not
forward it to ogr/gpkg/sqlite in this case.
Matthias
On Wed, Jul 28, 2021 at 10:08 PM C Hamilton wrote:
> Thanks everyone for that explanation. This does complicate the ability to
> set an expression filter in a plugin
Thanks everyone for that explanation. This does complicate the ability to
set an expression filter in a plugin when it depends on the data source
type. I'm not sure what to do about that.
Regards,
Calvin
On Wed, Jul 28, 2021 at 8:00 PM Anita Graser wrote:
> Hi Calvin,
>
> 28 Jul 2021 21:43:40