I have just tried this whilst working with some Openstreetmap data
downloaded using the OSM Downloader plugin, and loaded into QGIS
(3.16.9) directly from the .osm XML file.
The 'osm lines' layer has a highway attribute with 16 unique values and
NULLs. Using Select by Expression with the follo
Out of curiosity, what happens if you execute the same query via the
Virtual layer dialog or through the DB Manager? This would highlight any
differences between QGIS Expression SQL and a DBMS (the SQLite engine).
On 15/07/2021 08:17, Andrew Hughes wrote:
*CAUTION:* This e-mail originated outs
Hi Andrew,
Try using the NOT outside the IN operator
*NOT "tag_service" IN ('alley', 'drive-through', 'driveway', 'laneway',
'parking_aisle', 'parking')*
Alexandre Neto
User support
www.qcooperative.net
A quinta, 15/07/2021, 08:19, Andrew Hughes escreveu:
> Thanks Marco,
>
> You've answered
Thanks Marco,
You've answered my question, so thank you. For reference, I've never see
this in any sql rmdbs.
Some examples my help the community, hopefully I will be able to contribute
sooner or later.
Thanks again!
Andrew
On Wed, 7 Jul 2021 at 17:43, GMAIL wrote:
> This is how sql works.
>
and carriage returns in your code.
-Thayer
On Wednesday, July 7, 2021, 10:26:50 AM EDT, Basques, Bob (CI-StPaul)
wrote:
Not a Capitalization thing?
Bobb
From: Qgis-user On Behalf Of Thayer Young
Sent: Wednesday, July 7, 2021 9:23 AM
To: qgis-user@lists.osgeo.org
Su
Young
Sent: Wednesday, July 7, 2021 9:23 AM
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] Select by Expression: exclusive (not inclusive)
|
Think Before You Click:This email originated outsideour organization.
|
As Marco has explained, QGIS expressions are based on SQL which
uot;tag_service" NOT IN ('alley', 'drive-through',
'driveway', 'laneway','parking_aisle', 'parking')
-Thayer
From: Andrew Hughes
To: Qgis-user@lists.osgeo.org
Subject: [Qgis-user] Select by Expression: exclusive (not inclusive)
Mess
This is how sql works.
You want to apply a function to one column, and the column you are
comparing must have a value.
Consider this: tag_service != 'xxx' or null != 'xxx'. Null can't be
equal or unequal to any value. Even null = null or null != null returns
false
hth
marco
__
Hi All,
I can't for the life of me figure out why I can't "Select all features that
are *NOT* an alley, drive-through, driveway "
I am trying to use "Select by Expression".
The attribute I am trying to filter with is called "tag_service" and has 77
distinct values, including NULL.
*Q: Why d