[Qgis-user] Include Comment in source Query

[Johannes Kröger (WhereGroup)]

Ah, I had tried it in the first line always and had no issues. That 
explains it.

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 ;)


Am 03.02.22 um 19:54 schrieb Bernd Vogelgesang:
>
> mhm, seems to be this open issue maybe
>
> https://github.com/qgis/QGIS/issues/38359
>
>
> Am 03.02.22 um 19:34 schrieb Hugh Kelley:
>> Ah thanks yes agreed on the shp front.
>>
>> I'm not finding success with gpkg using QGIS 3.16.11 either though.
>>
>> On Thu, Feb 3, 2022 at 1:27 PM Bernd Vogelgesang 
>> <bernd.vogelgesang at gmx.de> wrote:
>>
>>     Hi,
>>
>>     here are my findings from 2015:
>>
>>     https://gis.stackexchange.com/questions/107522/is-it-possible-to-use-comments-in-qgis-query-builder-with-esri-shapefiles/149448#149448
>>
>>     In short: comments with shape files did not (do not maybe still )
>>     work
>>
>>     Solution: Just do not use ESRI-Shape files for work ;)
>>
>>     Cheers,
>>
>>     Bernd
>>
>>     Am 03.02.22 um 15:33 schrieb Hugh Kelley:
>>>     Very helpful point, it is a shapefile.
>>>
>>>     so far "#", "--", "//" and "/* */" did not work. I also tried
>>>     "<!-- comment -->" for good measure which didn't work as well.
>>>
>>>     I tried a few of those on a geopackage too  and they errored out
>>>     there as well.
>>>
>>>     I'll try a postgis datas source later today if I remember.
>>>
>>>     On Thu, Feb 3, 2022 at 9:23 AM Johannes Kröger (WhereGroup)
>>>     <johannes.kroeger at wheregroup.com> wrote:
>>>
>>>         Hi Hugh,
>>>
>>>         that depends on the provider in use, a PostGIS provider
>>>         might behave differently from a Shapefile. See if wrapping
>>>         the comment in /* comment */ works.
>>>
>>>         Cheers, Hannes
>>>
>>>         Am 03.02.22 um 15:16 schrieb Hugh Kelley:
>>>>         Hi all,
>>>>
>>>>         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.
>>>>
>>>>         Is there a way to include a comment in the query?
>>>>
>>>>         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:
>>>>
>>>>         -- remove built neighborhood bikeway according to KML file
>>>>         from client, per email 2022-02-03
>>>>         "LOCAL_ID" NOT IN (4030, 3533, 4307, 6015, 5217)
>>>>
>>>>         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.
>>>>
>>>>         thanks
>>>>
>>>>         Hugh
>>>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220204/80940662/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_0xBF7B268A77C202D5.asc
Type: application/pgp-keys
Size: 2476 bytes
Desc: OpenPGP public key
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220204/80940662/attachment-0001.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 665 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220204/80940662/attachment-0001.sig>