= FDO RFC 40 - Support for Ordering =

This page contains a request for comments document (RFC) for the FDO Open Source project.  
More FDO RFCs can be found on the [wiki:FDORfcs RFCs] page.

== Status == 
 
||RFC Template Version||(1.0)|| 
||Submission Date||(Date/Time submitted)||
||Last Modified||Zac Spitzer [[Timestamp]]||
||Author||Zac Spitzer||
||RFC Status||(draft)||
||Implementation Status||(pending)||
||Proposed Milestone||(e.g. 3.5)||
||Assigned PSC guide(s)||(when determined)||
 
== Overview ==

FDO currently has no standardised support for result set ordering.

== Motivation ==

Ordering is a very commonly used operation with databases. 

Clients such as MapGuide can support rendering of complex roads networks
if the resultset are ordered, allowing major features to be rendered atop
minor features.

[http://trac.osgeo.org/mapguide/wiki/MapGuideRfc69] would require such support.

== Proposed Solution ==

Add support for ordering to the FDO spec. 

Help Wanted

== Implications ==

TBD

== Test Plan ==

TBD

== Funding/Resources ==

Help Wanted

== Related Trac Tickets ==

[http://trac.osgeo.org/mapguide/wiki/MapGuideRfc69][[BR]]
#618 Theming stylisation order isn't respected in a layer[[BR]]
[http://trac.osgeo.org/fdo/ticket/516  FDO Core enhancment: support standard ORDER BY expressions]

== Discussions ==
[http://n2.nabble.com/RE%3A--fdo-trac---516%3A-FDO-Core-enhancment%3A-support-standard-ORDER-BY-expressions-td2741343.html#a2741343][[BR]]
[http://n2.nabble.com/MapGuide-RFC-69---Rendering-Layer-Styles-using-Style-Order-td3158848.html][[BR]]
[http://n2.nabble.com/RE%3A-MapGuide-RFC-69---Rendering-Layer-Styles-td3159460.html]