[Qgis-user] Include Comment in source Query

[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 listQgis-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.comwww.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 listQgis-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/ece8257f/attachment.html>