Sort tickets by due date

Hi Ilija,
One request I have... is it possible to order the tickets on the overview page assorte to due date?
Jurgen

Ticket hacks - that are part of Planning module - allow you to sort tickets by due dates.

You would need to buy the Planning module to get them.

If you always wanted them sorted by due date, you can hack the Tickets module (specifically the TicketsModel file) and add an appropriate ORDER BY clause.

Hi Jurgen,

1. Changing the default sort order of tickets requires changing core source code of activeCollab. This is referred to as a "hack" to activeCollab. The hack I mentioned is a part of our Planning module. Planning module also adds support for estimated time and workflow status to tickets.

2. The current linkage between Planning and Reports module is that you can see a graph of estimated time for your project in Reports module and compare it against the actual hours. Reports module does not yet show estimated times / allocations / availability for people. The simple reason for this is that a ticket can be assigned to multiple people, and we have no way to find out who's working how much on the ticket. Frankly, we also wanted to know resource availability / overbookings - but are limited currently. Once we figure out an easy way to assign time on a particular ticket to multiple people, we can accurately track their allocations.

3. As for the specific hack to sort tickets by due date:

- Open the "Tickets.class.php" file inside the models directory, within application/modules/tickets.
- Locate the function "findOpenByCategory"
- Locate the line

 'order' => 'ISNULL(position) ASC, position, priority DESC',

- Change it to

 'order' => 'due_on ASC, ISNULL(position) ASC, position, priority DESC',

- You can change it to "due_on ASC" if you want to sort in ascending order of due dates. Change it to "due_on DESC" if you want it to sort in descending order of due dates.
- Save the file and upload to the server if needed

Please be careful while making this change and take a backup of the file before making any changes.

Hope this helps.

:Nirav

Hi Nariv,

Changed the file, but it doesn't work. It might be because I have used a different hack earlier to get the due dates, etc. shown. See attachment.

Jurgen

Nirav, You certainly know what you are doing. It's working perfectly now!

Thanks!

Jurgen