<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Ah, I had tried it in the first line always and had no issues.
That explains it.<br>
</p>
<p>As an ugly workaround I guess you could use a "AND NOT 'this is a
comment'" (or without the NOT depending how you use it). Don't
blame me if this ends up causing issues in 2 years or something ;)<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 03.02.22 um 19:54 schrieb Bernd
Vogelgesang:<br>
</div>
<blockquote type="cite"
cite="mid:b1bff644-58c7-df01-b748-8e1bb5658a06@gmx.de">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p>mhm, seems to be this open issue maybe</p>
<p><a class="moz-txt-link-freetext"
href="https://github.com/qgis/QGIS/issues/38359"
moz-do-not-send="true">https://github.com/qgis/QGIS/issues/38359</a></p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 03.02.22 um 19:34 schrieb Hugh
Kelley:<br>
</div>
<blockquote type="cite"
cite="mid:CAOrcXHHi0ot36BSJSFPVqPEew2X+_tEFzU2f8M+cNLaRBVA=Hg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<div dir="ltr">
<div>Ah thanks yes agreed on the shp front. <br>
</div>
<div><br>
</div>
<div>I'm not finding success with gpkg using QGIS 3.16.11
either though. <br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Feb 3, 2022 at 1:27
PM Bernd Vogelgesang <<a
href="mailto:bernd.vogelgesang@gmx.de"
moz-do-not-send="true" class="moz-txt-link-freetext">bernd.vogelgesang@gmx.de</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div>
<p>Hi,</p>
<p>here are my findings from 2015:</p>
<p><a
href="https://gis.stackexchange.com/questions/107522/is-it-possible-to-use-comments-in-qgis-query-builder-with-esri-shapefiles/149448#149448"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://gis.stackexchange.com/questions/107522/is-it-possible-to-use-comments-in-qgis-query-builder-with-esri-shapefiles/149448#149448</a></p>
<p>In short: comments with shape files did not (do not
maybe still ) work</p>
<p>Solution: Just do not use ESRI-Shape files for work ;)</p>
<p>Cheers,</p>
<p>Bernd<br>
</p>
<div>Am 03.02.22 um 15:33 schrieb Hugh Kelley:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>Very helpful point, it is a shapefile. <br>
</div>
<div><br>
</div>
<div>so far "#", "--", "//" and "/* */" did not work.
I also tried "<!-- comment -->" for good
measure which didn't work as well. <br>
</div>
<div><br>
</div>
<div>I tried a few of those on a geopackage too and
they errored out there as well. <br>
</div>
<div><br>
</div>
<div>I'll try a postgis datas source later today if I
remember. <br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Feb 3, 2022
at 9:23 AM Johannes Kröger (WhereGroup) <<a
href="mailto:johannes.kroeger@wheregroup.com"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">johannes.kroeger@wheregroup.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div>
<p>Hi Hugh,</p>
<p>that depends on the provider in use, a PostGIS
provider might behave differently from a
Shapefile. See if wrapping the comment in /*
comment */ works.</p>
<p>Cheers, Hannes<br>
</p>
<div>Am 03.02.22 um 15:16 schrieb Hugh Kelley:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>Hi all, <br>
</div>
<div><br>
</div>
<div>in the Layer Properties >> source
>> Query Builder dialogue, if I use
"--" it shows that I've commented out that
line. when I test the query though, it
throws an error complaining about the
comment I included. <br>
</div>
<div><br>
</div>
<div>Is there a way to include a comment in
the query? <br>
</div>
<div><br>
</div>
<div>i've like to include a note to myself
when I filter things sometimes as it can be
hard months or years later to figure out the
motivation. for example: <br>
</div>
<div><br>
</div>
<div>-- remove built neighborhood bikeway
according to KML file from client, per email
2022-02-03<br>
"LOCAL_ID" NOT IN (4030, 3533, 4307, 6015,
5217)</div>
<div><br>
</div>
<div>Maybe there's a better way to include
this note, but it seems that the closer the
note is to the filter query definition the
more likely I am to see it. <br>
</div>
<div><br>
</div>
<div>thanks<br>
</div>
<br>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">Hugh <br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</blockquote>
<br>
</body>
</html>