[Qgis-user] ilike-operator

[Alexandre Neto]

You can use the "in" operator [0] , together with the lower() function [1].

lower("Shape") in ('rectangle', 'triangle')

Hope it helps,

Alexandre Neto

[0] -
http://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/expression.html#operators

[1] -
http://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/expression.html#string-functions

A sex, 28/07/2017, 13:05, Walter Nordmann <wnordmann at gmx.de> escreveu:

> please try it. it does work! qgis filter is usually accepting all valid
> sql queries.
> filter: lower("value") similar to '(berlin|london|paris)'
>
> https://wambachers-osm.website/images/osm/snaps_2017/similar.png
>
> ok, havin problems with hstore, but that's is another question.
>
> regards
> walter
>
> Am 28.07.2017 um 13:31 schrieb "Torben Keßler":
>
> Thanks! Just erased the wildchars to shorten the code.
>
> I forgot to mention that I'm trying this as a QGIS (v 2.18.7) filter, not
> in ProstgreSQL. There, I have only "ilike" as suitable string operator, it
> seems.
>
> Best,
> Torben
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Alexandre Neto
---------------------
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170730/4b1abf1d/attachment.html>