[vTiger 6] Change comments order

If you want see the comments of your modules ordered by creation date, open  "\modules\ModComments" file, search "getAllParentComments($parentId)" function and edit the line

//Condition are directly added as query_generator transforms the
//reference field and searches their entity names
$query = $query ." AND related_to = ? AND parent_comments = '' ORDER BY vtiger_crmentity.createdtime DESC";

Change to:

$query = $query ." AND related_to = ? AND parent_comments = '' ORDER BY vtiger_crmentity.createdtime ASC";