[Geoserver-users] Error in ysld and css style(Report bug)

[alich65]

I have a Sql Server Store in Geoserver. This my ysld file:

title: 'YSLD Cook Book: Attribute-based polygon'
feature-styles:
- name: name
  rules:
  - name: empty
    title: empty
    filter: ${Rank = ''}
    symbolizers:
    - polygon:
        fill-color: '#66FF66'
  - name: title2
    title: title2
    filter: Rank LIKE N'خیلی زیاد'
    symbolizers:
    - polygon:
        fill-color: '#33CC33'
  - name: title3
    title: title3
    filter: ${Rank LIKE N'%اد%'}
    symbolizers:
    - polygon:
        fill-color: '#009900'
  - name: title4
    title: title4
    filter: ${Rank = N'متوسط'}
    symbolizers:
    - polygon:
        fill-color: '#009900'

I get this error: "Error parsing filter" because added "N" prefix to filter.
I think that is a bug in Geoserver or Sql Server plugin. Sql Server require
to this prefix for execute query on NVARCHAR columns but Geoserver can not
handle that. Please attention to blow images:

<http://osgeo-org.1560.x6.nabble.com/file/t381194/11.png&gt;

<http://osgeo-org.1560.x6.nabble.com/file/t381194/22.png&gt;

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

[jive]

You removed the ${ } that is used t o mark a CQL filter.

Can I ask if using this works:

filter: ${Rank LIKE ‘خیلی زیاد’}

ECQL should be fine using any Unicode characters, no need to use a N string prefix (this is our own little language and not SQL).

–
Jody Garnett

On Tue, 27 Aug 2019 at 06:40, alich65 <alich5491@anonymised.com.84…> wrote:

I have a Sql Server Store in Geoserver. This my ysld file:

title: ‘YSLD Cook Book: Attribute-based polygon’
feature-styles:

• name: name
  rules:
• name: empty
  title: empty
  filter: ${Rank = ‘’}
  symbolizers:
• polygon:
  fill-color: ‘#66FF66’
• name: title2
  title: title2
  filter: Rank LIKE N’خیلی زیاد’
  symbolizers:
• polygon:
  fill-color: ‘#33CC33’
• name: title3
  title: title3
  filter: ${Rank LIKE N’%اد%'}
  symbolizers:
• polygon:
  fill-color: ‘#009900’
• name: title4
  title: title4
  filter: ${Rank = N’متوسط’}
  symbolizers:
• polygon:
  fill-color: ‘#009900’

I get this error: “Error parsing filter” because added “N” prefix to filter.
I think that is a bug in Geoserver or Sql Server plugin. Sql Server require
to this prefix for execute query on NVARCHAR columns but Geoserver can not
handle that. Please attention to blow images:

<http://osgeo-org.1560.x6.nabble.com/file/t381194/11.png>

<http://osgeo-org.1560.x6.nabble.com/file/t381194/22.png>

–
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

---

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