Automatically Sort ListView by a Hidden field

[chrislynch8]

Hi,

I am trying to automatically sort my list views based a on value that I am not displaying the listview.

Is it possible to do this with a custom view.list.php?

Rgds
Chris

[chrislynch8]

Hi,

Found this thread during a search.

http://www.sugarcrm.com/forums/showthread.php?t=62426&highlight=order+by

Can someone explain how this is working - it seems to be the way to do what I want.

Rgds
Chris

[davidboris]

Hi,

I've override the list view query. And in that example I've added an extra field to get sorted with the field user sorts the list view.

Do let me know if it is clear enough.

[chrislynch8]

Hi,

I can following the order_by part. Its the custom controller for the action_listview I don't fully understand. How do I create the custom controller.

I have created a file in /custom/modules/<Module_Name>/controller.php in there I have added the following

 <?php

require_once('custom/modules/Accounts/accounts_sort.php');
class AccountsController extends SugarController{
                function action_listview(){
                 $this->view_object_map['bean'] = $this->bean;
                 $this->view = 'list';
                 $GLOABLS['view'] = $this->view
                 $this->bean = new AccountsListView();
                 }
}  

Then in a file /custom/modules/Accounts/accounts_sort.php - is teh same as yours I've added in my field I want to sort on.


Rgds
Chris

*******************************************

UPDATE --------------- I have this resolved now. Had a typo in my accounts_sort.php

************************************************** **

[davidboris]

Hi,

I dont understand where are you stuck actually. Are you stuck or want to know the procedure only?

[chrislynch8]

Hi David,

I've got it working. I though I was creating the above custom controller incorrectly, but it turned out t be a Typo in the accounts_sort.php file. Instead of extends Accounts I had extends Accounts.....

Rgds
Chris