ListView sort order

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Hello All,

Been reading about the various hacks to get the list view of the Cases module to sort descending using a specific field. Does anyone have a sec to help me with the proper way to do this? Also seems that these changes are not upgrade safe. Here are a few of the posts I have been reading.

https://community.sugarcrm.com/sugarcrm/topics/how_to_change_default_sort_field_in_list_view
http://urdhva-tech.blogspot.com/2013/02/extending-list-view-query.html

#2

You can do this per-user by using the sort order in the advanced search, but I presume that is not a solution to this change.

#3

When sort is set at the user level, is it persistent for that user?

#4

NO… when they click “clear” then “search” it goes back.

I’ve been fighting this for over a year, and haven’t been able to resolve it.

My most recent attempt is a file is /custom/modules/Project/views called custom.view.list.php and the following code:


<?php
// Attempt at setting the default sort order for Projects - ADS 10/2/15
require_once('modules/Projects/views/view.list.php');
class CustomProjectsViewList extends ProjectsViewList
{
        function CustomProjectsViewList(){
          parent::ProjectsViewList();
        }
       function listViewPrepare() {    
          if(empty($_REQUEST['orderBy'])) { 
 
              $_REQUEST['orderBy'] = strtoupper('aa_file_c');            
              $_REQUEST['sortOrder'] = 'DESC'; 
           } 
           parent::listViewPrepare(); 
       }
}
?>
#5

Hello.

I’m after something similar.

My users want to have a sort in the account view. They always want them to be sorted by the account numbers going down irrespective of what options they have chosen to search by. So I was wondering if I can try this… Can I just change the aa_file_c to the name of the field I want to sort by in accounts and of course change any projects references to Accounts.

#6

Thanks Sieberta that worked a treat for me in accounts.

They now sort by the field I want, and in the correct order.

#7

So FYI, that code is almost correct except for a couple of glitches:

  1. The “Projects” module is “Project” not “Projects” despite every other module name being plural, so that needs corrected. It should also be named view.list.php and put in /custom/modules/project/views.
  2. I don’t know where it is coming from, but my $_REQUEST[‘orderBy’] is never empty, so that code never fires (drives me crazy because I don’t know why it isn’t empty). For me, it is a column that you would NEVER want to sort by (a bool) so I just edited the code to also include that if it is that value, also repalce it with the desired sort field.

Otherwise, this code was pretty close. Took me nearly 2 years to finally get it working, I guess it wasn’t that big of a priority for me.

sieberta

#8

In each module Listview.
Click the column header that you like to be sorted on, once or twice (up/down sort) and then click Search. This makes the current sorting get saved. Just like a normal text search also can be saved with Search until it is Cleared.

#9

If you want to respect user preferences then use the following code to apply default sorting order:

File location: custom/modules/<module_name>/views/view.list.php

public function preDisplay()
{
   $userPreferenceOrder = $GLOBALS['current_user']->getPreference('listviewOrder', 'AOK_KnowledgeBase2_AOK_KNOWLEDGEBASE'); // you can get required category name from "user_preferences" table. 

       if(empty($userPreferenceOrder['orderBy']))
        {
	      $_REQUEST['orderBy'] = 'field_name';
	      $_REQUEST['sortOrder'] = 'DESC';
         }

         parent::preDisplay();
    }