aC forum: Sort tickets by due date http://www.activecollab.com/forums/topic/5560/ Recent posts on topic: Sort tickets by due date en-us Thu, 24 May 2012 07:09:50 CDT http://www.activecollab.com/forums/post/24687/#post24687 http://www.activecollab.com/forums/post/24687/#post24687 Post #10 by Nirav M. Nirav Mehta Super! Glad it's working as expected!

]]> Mon, 25 Jan 2010 02:08:05 CST http://www.activecollab.com/forums/post/24680/#post24680 http://www.activecollab.com/forums/post/24680/#post24680 Post #9 by jurgenswaans jurgenswaans Nirav, You certainly know what you are doing. It's working perfectly now!

Thanks!

Jurgen

]]> Sun, 24 Jan 2010 08:22:59 CST http://www.activecollab.com/forums/post/24679/#post24679 http://www.activecollab.com/forums/post/24679/#post24679 Post #8 by Nirav M. Nirav Mehta Hi Jurgen,

Do similar change in the "findOpenByProject" function as well. That should make it work.

:Nirav

]]> Sat, 23 Jan 2010 23:10:59 CST http://www.activecollab.com/forums/post/24670/#post24670 http://www.activecollab.com/forums/post/24670/#post24670 Post #7 by jurgenswaans jurgenswaans 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

]]> Fri, 22 Jan 2010 16:36:16 CST http://www.activecollab.com/forums/post/24669/#post24669 http://www.activecollab.com/forums/post/24669/#post24669 Post #6 by jurgenswaans jurgenswaans thanks very much for your very clear and informative answer Nariv!

]]> Fri, 22 Jan 2010 16:21:57 CST http://www.activecollab.com/forums/post/24658/#post24658 http://www.activecollab.com/forums/post/24658/#post24658 Post #5 by Nirav M. Nirav Mehta 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

]]> Thu, 21 Jan 2010 23:16:46 CST http://www.activecollab.com/forums/post/24646/#post24646 http://www.activecollab.com/forums/post/24646/#post24646 Post #4 by jurgenswaans jurgenswaans Hi Nirav,

Am going to buy your module next week, but would like to sort it in ac itself too or is this feature added outside your module? About your reports module and estimated time. Is the estimated time you enter in planning module assigned to a person and can you that way see in reports if someone is planned for more than eg 40 hours in a week?

I am not a programmer... you know where to add the hack for the time being?

Jurgen

]]> Thu, 21 Jan 2010 14:12:25 CST http://www.activecollab.com/forums/post/24635/#post24635 http://www.activecollab.com/forums/post/24635/#post24635 Post #3 by Nirav M. Nirav Mehta 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.

]]> Wed, 20 Jan 2010 23:39:23 CST http://www.activecollab.com/forums/post/24633/#post24633 http://www.activecollab.com/forums/post/24633/#post24633 Post #2 by Ilija Studen Ilija Studen Hello Jurgen,

Currently it is not possible to sort tickets by due date automatically. You are free to sort them any way you want by simply dragging them to a new position.

]]> Wed, 20 Jan 2010 16:12:14 CST http://www.activecollab.com/forums/post/24631/#post24631 http://www.activecollab.com/forums/post/24631/#post24631 Post #1 by jurgenswaans jurgenswaans Hi Ilija,
One request I have... is it possible to order the tickets on the overview page assorte to due date?
Jurgen

]]> Wed, 20 Jan 2010 15:50:18 CST