[Qgis-user] Include Comment in source Query

[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
>>>
>>>
>>>         _______________________________________________
>>>         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
>>
>>         --
>>         Johannes Kröger / GIS-Entwickler/-Berater
>>         WhereGroup GmbH
>>         Grevenweg 89
>>         20537 Hamburg
>>         Germany
>>
>>         Tel: +49 (0)228 / 90 90 38 - 36
>>         Fax: +49 (0)228 / 90 90 38 - 11
>>
>>         johannes.kroeger at wheregroup.com
>>         www.wheregroup.com  <http://www.wheregroup.com>
>>         Geschäftsführer:
>>         Olaf Knopp, Peter Stamm
>>         Amtsgericht Bonn, HRB 9885
>>         -------------------------------
>>
>>         ---------------------------------------------
>>         Schon gewusst?

>>         In unserem Blog geben wir Tipps & Tricks zu
 Open-Source-GIS-Software
>>         und berichten aus unserem Experten-Alltag:
>>         https://wheregroup.com/blog/
>>         ---------------------------------------------
>>
>>         _______________________________________________
>>         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
>>
>>
>>
>>     --
>>     Hugh Kelley
>>
>>
>>     _______________________________________________
>>     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
>
>
>
> --
> Hugh Kelley
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220203/a195860a/attachment.html>