Sorting the projects DESC in stead of ASC

Reinder · Post by **Reinder** » 03 May 2005, 07:27

I want to sort the projects DESC because the date is in front of the proejct name (and the latest projects should be on top). Where can I configure this?? Not only in the "shwich" drop down but also in the list when choosing a project to report an issue on....

thraxisp · Post by **thraxisp** » 03 May 2005, 11:38

This is currently not configurable.

You would need to edit a few of the internal routines to change this, probably starting in core/print_api.php (print_project_option_list).

Reinder · Post by **Reinder** » 03 May 2005, 13:15

I thought as much, but the problem is where to change this, I expected something like SELECT * FROM mantis_project_table WHERE etc etc ORDER BY name; So the only thing I had to do was ORDER BY name DESC;

But I cant seem to find this query :(

thraxisp · Post by **thraxisp** » 15 May 2005, 23:34

Unless you are an admin, the project list comes from core/user_api.php -> user_get_accessible_projects().

Reinder · Post by **Reinder** » 19 May 2005, 08:26

A, I found it !!:) it's the ORDER BY p.name DESC in the project_hierarchy_api.php file. Tnx !! :) Now I can order them by date (DESC)