Sort by for listview

[monicaDC]

Happy New Year to all of you!
I am running into a problem with my listview for Tasks. I want to be able to sort by the Related to (i.e. Parent) field. I added 'sortable' =>true to my custom/modules/Tasks/metadata/listviewdefs.php file, but it's not working:
'PARENT_NAME' =>
array (
'width' => '20%',
'label' => 'LBL_LIST_RELATED_TO',
'dynamic_module' => 'PARENT_TYPE',
'id' => 'PARENT_ID',
'link' => true,
'default' => true,
'sortable' => true,
'ACLTag' => 'PARENT',
'related_fields' =>
array (
0 => 'parent_id',
1 => 'parent_type',
),
),
When I click on the sort by arrow, my list goes blank. Any idea on how to fix this? Thanks for the help.

[yannick038]

I have exactly the same question. Spent 3 hours last night to make the related to field sortable.
The problem with the blank output after having clicked is pretty simple to understand.
If you read carrefully the Log file, you will see that the query created to display the list is ordering the results by "parent_name" field which is not present in the table (you should have parent_id but the parent_name is loaded dynamically).

So you will get an error message in the log file like :
MySQL error 1054: Unknown column 'parent_name' in 'order clause'

Now i need me too to find how to change the created query to don't use the parent_name column or at least, add the related table to be able to find the values !

Any help appreciated.


(Sugar 5.2.0 CE)

[andopes]

Hi guys

Take a look at the modules/Contacts/vardefs.php
You need to follow the same fields definied for accounts relationship, including account_name, account_id and accounts (type = link).

Regards