Sorting ActiveCollab tasks
Our company has been using ActiveCollab for years. It’s a great project management tool and has improved considerably over the years. We have managed hundreds of projects and more than 12,000 tasks using ActiveCollab. Occasionally we want a little more from the system than it offers out of the box. I’ve built an importer (shameless plug!) to make it simple to add tasks in bulk. I’ve written some automated task creation scripts. I’ve even tried my hand at writing a 3rd party integration module. Sometimes, though, you just need a simple tweak to tailor the system to your needs. That’s what this post is about.
This only affects active tasks within our “Hosted site maintenance” project. We are sorting by title, but you could sort by any field.
I recommend backing up (or duplicating/cloning) the project_objects table before messing with it.
SET @x = 0;
UPDATE 18314_project_objects SET position = (@x:=@x+1)
WHERE project_id = 349 AND state = 3 AND type = "Task"
ORDER BY name;
You may wish to add other conditionals. If, for example, you need to only order the tasks assigned to a specific user, simply add an assignee_id = N condition, where N is the user ID number.