Opened 10 years ago

Last modified 9 years ago

#516 new enhancement

FDO Core enhancment: support standard ORDER BY expressions

Reported by: Mike Toews Owned by: gregboone
Priority: minor Milestone: 3.6.0
Component: FDO API Version: 3.4.0
Severity: 5 (Wish List) Keywords:
Cc: External ID:

Description

Searching through the fdo-user's list, I found some discussion and ticket-worthy material on the topic of ordering data from the core API: http://lists.osgeo.org/pipermail/fdo-users/2008-May/000943.html

The primary importance for me is the drawing order of stacked features. At present, in AutoCAD Map3D we have no control how overlapping polygons are drawn. One workaround is to create a database view on the server-side that is linked to FDO/CAD, and the other is to break a single feature layer into several layers to get the stacking correct. The preferred method would be to use a single ordered feature class that is sored by (e.g.) date, status, area, or some other feature attribute.

From a low-level perspective, it appears this is supported by some providers using customized commands. This enhancement is aimed to bring soring of data on 1 or more attribute columns to FDO Core, so it can be supported by data providers.

See also, a similar "ORDER BY" enhancement request for QGIS: https://trac.osgeo.org/qgis/ticket/1597

Change History (2)

comment:1 Changed 10 years ago by zspitzer

relates to http://trac.osgeo.org/mapguide/ticket/618

it has been suggested to write an RFC for this feature

comment:2 Changed 9 years ago by gregboone

Milestone: 3.5.03.6.0
Severity: 35 (Wish List)

Enhancement Request

Note: See TracTickets for help on using tickets.