Project

General

Profile

Subproject Sort Order Oddness

Added by Chris Platts over 14 years ago

Hi,

We had a problem where subprojects started randomly appearing under different parents -- basically the issue described in #3722

From that ticket, we used Augusto Dias Pereira dos Santos's stored procedure to repair the parent/child relationships. This has worked fine, apart from one thing: the sorting of projects and sub-projects is now completely random. Is it possible to return these to alphabetical order?

Thanks!
Chris


Replies (1)

RE: Subproject Sort Order Oddness - Added by Chris Platts over 14 years ago

We added some ORDER BY clauses to the recalculateNestedSet stored procedure used to fix the initial problem. That seems to have done the trick! - See #3722 for the updated sproc.

    (1-1/1)