= FDO RFC 40 - Add standardized ordering support = 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 standardized 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/fdo/wiki/FDORfc26 New ExtendedSelect command and Scrollable Reader][[BR]] [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]