subject:"\[Qgis\-user\] Include Comment in source Query"

Re: [Qgis-user] Include Comment in source Query

2022-02-04 Thread 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
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
"" 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)
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

OpenPGP_0xBF7B268A77C202D5.asc
Description: OpenPGP public key

OpenPGP_signature
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Include Comment in source Query

2022-02-03 Thread 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
 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
"" 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)
 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@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.kroe...@wheregroup.com
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@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@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@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Include Comment in source Query

2022-02-03 Thread 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 
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 "" 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.kroe...@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-u...@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.kroe...@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@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-u...@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@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Include Comment in source Query

2022-02-03 Thread 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 "" 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)
 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@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.kroe...@wheregroup.com
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@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@lists.osgeo.org
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Include Comment in source Query

2022-02-03 Thread Hugh Kelley

Very helpful point, it is a shapefile.

so far "#", "--", "//" and "/* */" did not work. I also tried "" 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.kroe...@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-u...@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.kroe...@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@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@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Include Comment in source Query

2022-02-03 Thread WhereGroup


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@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.kroe...@wheregroup.com
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/
-



OpenPGP_0xBF7B268A77C202D5.asc
Description: OpenPGP public key


OpenPGP_signature
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Include Comment in source Query

2022-02-03 Thread 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@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Include Comment in source Query

Re: [Qgis-user] Include Comment in source Query

Re: [Qgis-user] Include Comment in source Query

Re: [Qgis-user] Include Comment in source Query

Re: [Qgis-user] Include Comment in source Query

Re: [Qgis-user] Include Comment in source Query

[Qgis-user] Include Comment in source Query

7 matches

Site Navigation

Mail list logo

Footer information