Sorting Discussion Alphabetically

bump

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.