http://www.activecollab.com/forums/topic/4776/ Recent posts on topic: Sorting Discussion Alphabetically en-us Thu, 24 May 2012 03:45:20 CEST http://www.activecollab.com/forums/post/21818/#post21818 http://www.activecollab.com/forums/post/21818/#post21818 Guy Cortesi Thx Ilija - got it to work! I created an ascending sort for discussions grouped by category, and left the existing date sort for "all discussions". I sorted by "name" (the discussion subject / title).

Edit the file:
activecollab/application/modules/discussions/models/discussions/Discussions.class.php
At the bottom of the file, alter the function paginateByCategory, changing 'order' => 'boolean_field_1, datetime_field_1 DESC', to 'order' => 'name ASC',

The (single line of ) code change is as follows:

Was:

function paginateByCategory($category, $page = 1, $per_page = 30, $min_state = STATE_VISIBLE, $min_visibility = VISIBILITY_NORMAL) {
return ProjectObjects::paginate(array(
'conditions' => array('parent_id = ? AND type = ? AND state >= ? AND visibility >= ?', $category->getId(), 'Discussion', $min_state, $min_v$
'order' => 'boolean_field_1, datetime_field_1 DESC',
), $page, $per_page);
} // paginateByCategory

} // Discussions

Change to:

function paginateByCategory($category, $page = 1, $per_page = 30, $min_state = STATE_VISIBLE, $min_visibility = VISIBILITY_NORMAL) {
return ProjectObjects::paginate(array(
'conditions' => array('parent_id = ? AND type = ? AND state >= ? AND visibility >= ?', $category->getId(), 'Discussion', $min_state, $min_v$
'order' => 'name ASC',
), $page, $per_page);
} // paginateByCategory

} // Discussions

------------------------------------
This allows you to sort only the discussions that have been categorized and quickly find the one your looking for, since categorized discussions are sorted by the name (title) of the discussion.

A nice improvement would be to simply go the the Discussions page in a project, then click on the word "Discussion", and have the Discussion list sort by discussion name, then click on "Last Reply", and have the list re-sort by date. Just a suggestion for a future release.

]]> Thu, 30 Jul 2009 19:57:32 CEST http://www.activecollab.com/forums/post/21779/#post21779 http://www.activecollab.com/forums/post/21779/#post21779 Ilija Studen Hi Guy,

For this to work, you'll need to hack discussions manager class. You can find this class in models folder of discussions module. Please note that changes to this class will affect all projects.

]]> Wed, 29 Jul 2009 14:51:47 CEST http://www.activecollab.com/forums/post/21766/#post21766 http://www.activecollab.com/forums/post/21766/#post21766 Guy Cortesi bump

]]> Tue, 28 Jul 2009 21:24:10 CEST http://www.activecollab.com/forums/post/21430/#post21430 http://www.activecollab.com/forums/post/21430/#post21430 Guy Cortesi Does anyone have a suggestion to add the ability to sort discussions alphabetically (by title of the discussion)? I have a need to have a discussion setup with the title of the discussions as the name of a person. I'd like to be able to sort the list of discussions using the title field. Thanks...

]]> Sun, 12 Jul 2009 14:37:50 CEST