Re: [Geoserver-users] trouble with cql_filter

2024-02-11 Thread wambacher 

peters answer: use /"id" in ('R403139')/is workind fine.

walter

Am 10.02.24 um 20:30 schrieb Jody Garnett:

Huh, I wonder if that is even supported …

The FeatureID check is done different by WFS, and does not always 
integrate well with functions and so on. There is a configuration 
option to both use primary keys to generate FeatureID and also make 
available as an attribute for use with functions.


Are you comfortable trying the same request with an XML query? …to see 
if it is a problem with the data store, or if it is a problem with CQL 
constructing a query …


Reading
https://docs.geoserver.org/main/en/user/filter/ecql_reference.html you 
may wish to try:


in('R403139')

Assuming R403139 is a feature identifier.

--
Jody Garnett


On Sat, Feb 10, 2024 at 6:16 AM  wrote:

Hi,

i'm trying to use a cql_filter on a feature but something is strange.

cql_filter:  "id = 'R403139'" is working fine. i'll get only this
feature.

but   "id in('R403139')" does not give any result (without
error messages).

i need a list, because later on there more features will be
dynanical selected. e.g. "id in('R403139', 'R1719140')"

What am i doing wrong?

btw: i may add geoserver log file if needed.

-- 
My projects:


OSM Boundaries Map (*) - not completed
OSM Software Watchlist

OSM Emergency Map  (*)
OSM Healthcare Map
 (*)
OSM Postcode Map
 (Germany)

*) Europe
___
Geoserver-users mailing list

Please make sure you read the following two resources before
posting to this list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this:

https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


--
My projects:

OSM Software Watchlist 


OSM Emergency Map  (*)
OSM Healthcare Map  (*)
OSM Postcode Map  (Germany)

*) Europe___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] trouble with cql_filter

2024-02-10 Thread Jody Garnett 
Huh, I wonder if that is even supported …

The FeatureID check is done different by WFS, and does not always integrate
well with functions and so on. There is a configuration option to both use
primary keys to generate FeatureID and also make available as an attribute
for use with functions.

Are you comfortable trying the same request with an XML query? …to see if
it is a problem with the data store, or if it is a problem with CQL
constructing a query …

Reading
https://docs.geoserver.org/main/en/user/filter/ecql_reference.html you may
wish to try:

in('R403139')

Assuming R403139 is a feature identifier.

--
Jody Garnett


On Sat, Feb 10, 2024 at 6:16 AM  wrote:

> Hi,
>
> i'm trying to use a cql_filter on a feature but something is strange.
>
> cql_filter:  "id = 'R403139'" is working fine. i'll get only this feature.
>
> but   "id in('R403139')" does not give any result (without error
> messages).
>
> i need a list, because later on there more features will be dynanical
> selected. e.g. "id in('R403139', 'R1719140')"
>
> What am i doing wrong?
>
> btw: i may add geoserver log file if needed.
> --
> My projects:
>
> OSM Boundaries Map (*) - not completed
> OSM Software Watchlist
> 
> OSM Emergency Map  (*)
> OSM Healthcare Map  (*)
> OSM Postcode Map  (Germany)
>
>
> *) Europe
> ___
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] trouble with cql_filter

2024-02-10 Thread wambacher 

Hi Peter,

that works well :)

thanks

walter

Am 10.02.24 um 17:11 schrieb Peter Smythe:

Hi Wambacher

You might be running into this issue: 
https://gis.stackexchange.com/questions/373005/geoserver-wms-cql-filter-id-xxx-works-but-id-in-xxx-does-not 
, 
in which case, change your CQL


from: id in ('R403139')
to: "id" in ('R403139')

Peter


--
My projects:

OSM Software Watchlist 


OSM Emergency Map  (*)
OSM Healthcare Map  (*)
OSM Postcode Map  (Germany)

*) Europe___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] trouble with cql_filter

2024-02-10 Thread Peter Smythe 
Hi Wambacher

You might be running into this issue:
https://gis.stackexchange.com/questions/373005/geoserver-wms-cql-filter-id-xxx-works-but-id-in-xxx-does-not,
in which case, change your CQL

from: id in ('R403139')
to: "id" in ('R403139')

Peter


On Sat, 10 Feb 2024 at 16:19,  wrote:

> Hi,
>
> i'm trying to use a cql_filter on a feature but something is strange.
>
> cql_filter:  "id = 'R403139'" is working fine. i'll get only this feature.
>
> but   "id in('R403139')" does not give any result (without error
> messages).
>
> i need a list, because later on there more features will be dynanical
> selected. e.g. "id in('R403139', 'R1719140')"
>
> What am i doing wrong?
>
> btw: i may add geoserver log file if needed.
> --
> My projects:
>
> OSM Boundaries Map (*) - not completed
> OSM Software Watchlist
> 
> OSM Emergency Map  (*)
> OSM Healthcare Map  (*)
> OSM Postcode Map  (Germany)
>
>
> *) Europe
> ___
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>

___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] trouble with cql_filter

2024-02-10 Thread wambacher 

Hi,

i'm trying to use a cql_filter on a feature but something is strange.

cql_filter:  "id = 'R403139'" is working fine. i'll get only this feature.

but   "id in('R403139')" does not give any result (without error 
messages).


i need a list, because later on there more features will be dynanical 
selected. e.g. "id in('R403139', 'R1719140')"


What am i doing wrong?

btw: i may add geoserver log file if needed.

--
My projects:

OSM Boundaries Map (*) - not completed
OSM Software Watchlist 


OSM Emergency Map  (*)
OSM Healthcare Map  (*)
OSM Postcode Map  (Germany)

*) Europe___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users