aC forum: Most recent comment first in tickets http://www.activecollab.com/forums/topic/2399/ Recent posts on topic: Most recent comment first in tickets en-us Fri, 05 Sep 2008 13:18:20 UTC http://www.activecollab.com/forums/post/11367/#post11367 http://www.activecollab.com/forums/post/11367/#post11367 Post #7 by jwtdigital jwtdigital No worries... thanks for your help! :)

]]> Thu, 10 Jan 2008 17:40:22 UTC http://www.activecollab.com/forums/post/11366/#post11366 http://www.activecollab.com/forums/post/11366/#post11366 Post #6 by Ilija Studen Ilija Studen Sorry, to fix that would require much more changes.

This hack is nice because it's simple and can't do any damage - it just applies to tickets and that's it. If you go any further you'd need much more tweaking and testing.

]]> Thu, 10 Jan 2008 17:19:55 UTC http://www.activecollab.com/forums/post/11365/#post11365 http://www.activecollab.com/forums/post/11365/#post11365 Post #5 by jwtdigital jwtdigital That works now thanks! Comments are now in reverse order but the actual comment numbers #1, #2, #3 etc has number one at the top, even though it was actually the *last* comment.

Only a minor thing but would be helpful if you could suggest a quick fix.

Many thanks

]]> Thu, 10 Jan 2008 17:15:42 UTC http://www.activecollab.com/forums/post/11364/#post11364 http://www.activecollab.com/forums/post/11364/#post11364 Post #4 by Ilija Studen Ilija Studen Add it inside of the class, not above it. See how functions are defined after series of variables defined with var...

]]> Thu, 10 Jan 2008 17:05:38 UTC http://www.activecollab.com/forums/post/11363/#post11363 http://www.activecollab.com/forums/post/11363/#post11363 Post #3 by jwtdigital jwtdigital Hi Ilija,
I added the code but there was no change?

My file now looks like this....

<?php


/**
 * Return comment submitted for this project object
 *
 * @param integer $min_visiblity
 * @return array
 */
function getComments($min_visiblity = VISIBILITY_NORMAL) {
  return ProjectObjects::find(array(
    'conditions' => array("type = 'Comment' AND parent_id = ? AND state >= ? AND visibility >= ?", $this->getId(), STATE_VISIBLE, $min_visiblity),
     'order' => 'created_on DESC',
  ));
}

  /**
  * Ticket record class
  *
  * @package activeCollab.modules.tickets
  * @subpackage models
  */
  class Ticket extends ProjectObject {
    
    /**
     * Manage permission name
     * 
     * @var string
     */
    var $manage_permission_name = 'tickets_manage';
    
    /**
     * Define fields used by this project object
     *
     * @var array
     */
    var $fields = array

]]> Thu, 10 Jan 2008 16:57:42 UTC http://www.activecollab.com/forums/post/11362/#post11362 http://www.activecollab.com/forums/post/11362/#post11362 Post #2 by Ilija Studen Ilija Studen Put this function in Ticket class (Ticket.class.php in activecollab/application/modules/tickets/models/tickets):

/**
 * Return comment submitted for this project object
 *
 * @param integer $min_visiblity
 * @return array
 */
function getComments($min_visiblity = VISIBILITY_NORMAL) {
  return ProjectObjects::find(array(
    'conditions' => array("type = 'Comment' AND parent_id = ? AND state >= ? AND visibility >= ?", $this->getId(), STATE_VISIBLE, $min_visiblity),
     'order' => 'created_on DESC',
  ));
}

]]> Thu, 10 Jan 2008 16:45:00 UTC http://www.activecollab.com/forums/post/11361/#post11361 http://www.activecollab.com/forums/post/11361/#post11361 Post #1 by jwtdigital jwtdigital Can anyone suggest a way to list comments on tickets starting with the most recent?

Thanks

]]> Thu, 10 Jan 2008 16:17:18 UTC