[Qgis-user] Include Comment in source Query

[Bernd Vogelgesang]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220203/f6d074fe/attachment-0001.html>