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 <wnordm...@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@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
_______________________________________________ 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