Login or Register

RSS IconRecent posts in this topic

avatar Pro
ideamarket on Jul 23. 2008. 4:13 pm
How do I go about ordering project checklists by the due dates? Im sure its as easy as adding "ORDER BY due_on" to the sql command but I don't know what file to edit??

Anyone know how to do this?
avatar Staff
Ilija Studen on Jul 24. 2008. 12:03 am
Checklists do not support due date. Checklist tasks do, but in that case ordering by max due date in a list of tasks is a bit more complicated than changing ORDER BY in a specific query.

To see how checklists are loaded from database check Checklists.class.php located in /activecollab/application/modules/checklists/models.
activeCollab Team Member | Experiment: activeCollab on Twitter
avatar Pro
ideamarket on Jul 24. 2008. 1:32 pm
I am looking at the checklist tasks, sorry for that, I looked at the file you said and your right it would be more complicated than just changing the order by.

The problem we are having is that the task list has over 100 tasks in it, and they show up in no discernable order. is there no way to change this?
avatar Staff
Ilija Studen on Jul 24. 2008. 1:51 pm
If you wish to filter out tasks you should use assignments filters. This way you can filter out just the task you want and order them by due date, creation time and priority.

The way tasks in checklists are order can be changed in Tasks class - check /activecollab/application/modules/resources/models/tasks.
activeCollab Team Member | Experiment: activeCollab on Twitter
avatar
ejmcbride on Jul 24. 2008. 3:01 pm
I'm trying to understand this but I can't make heads or tails of where to find /activecollab/application/modules/checklists/models.

It doesn't appear to be a url. can you help me navigate to this information?
avatar Pro
ideamarket on Jul 24. 2008. 5:00 pm
Thank you that worked great!
avatar Staff
Ilija Studen on Jul 24. 2008. 5:05 pm
ejmcbride:
I'm trying to understand this but I can't make heads or tails of where to find /activecollab/application/modules/checklists/models.

It doesn't appear to be a url. can you help me navigate to this information?


It's a folder. In it you'll find Tasks.class.php which is responsible for querying task information from database.
activeCollab Team Member | Experiment: activeCollab on Twitter

RSS IconRecent posts in this topic