[Geoserver-devel] [jira] (GEOS-5838) WMS feature sorting using Property

GeoServer GeoServer Developer
1

Tobias Warneke created New FeatureGEOS-5838
WMS feature sorting using Property

Issue Type:

New FeatureNew Feature

Assignee:

Andrea Aime

Components:

WMS

Created:

03/Jun/13 11:02 AM

Description:

I need an order by in the sql of my WMS request. I am not able to split my style into different FeatureTypes. My data has some kind of z-ordering.

Using Oracle or PostgreSQL I am able to put an order by statement within my view. SQLServer need an additional top and does not perform very well with this construct. So instead of this way I “injected” an order by into your WMS - module and got much better results with queries like 'select geom from geomtable where … order by sort_col ’ instead of e.g. ‘select geom from (select top 1000 geom from geomtable order by …) …’.

So here are my questions:

  1. Is there already a way to set a sortby for WMS - requests?
  2. Maybe there is a proposal I missed regarding this?
  3. What would be the right way to modify WMS layer configuration to add this kind of feature? Did I miss the developer documentation?

Regards

Tobias

Project:

GeoServer

Priority:

MajorMajor

Reporter:

Tobias Warneke
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: [http://www.atlassian.com/software/jira](http://www.atlassian.com/software/jira)