Sorting by Columns does not work

[urs.pamp@gmail.com]

Hi there!

We're having problems sorting by columns in list view with all modules.
We did manage to sort the list view of the used modules by default by their names by editing include/ListView/ListViewData.php.
But we are not able to manually sort the list view by other column headers like status, team or start date (see the screenshot below). We're able to click the headers, but the records won't be sorted.

We tried editing custom/modules/<Modulename>/metadata/listviewdefs.php and making the headers sortable by adding "'sortable' => true,". The problem still remains unresolved.

How do you make ALL headers sortable (besides name)?

Thank you!
Screenshot:

[mikesolomon]

Are you getting javascript errors when you try and sort?

[urs.pamp@gmail.com]

Do you mean in Firebug?
I have no errors under console/errors.
The browser itself does not throw any errors.
I'd be happy to give you further information from Firebug.

[urs.pamp@gmail.com]

No one having the same problems?

[davidboris]

Hello,

Which field type are you trying to sort?
If you have done customizations in include/ListView/ListViewData.php, it is first of all unupgrade safe and it affects all module's query.
Echo out the query when you do sorting > Urdhva Tech: Where are the queries? and check if the query is good or not.

[urs.pamp@gmail.com]

I'd like to sort different types: xxx
We did customize include/ListView/ListViewData.php, but just:

if ($GLOBALS['module'] == 'Opportunities')
{
    $orderBy = 'opportunities.name ASC';
}

if ($GLOBALS['module'] == 'Contacts')
{
    $orderBy = 'contacts.last_name ASC';
}

if ($GLOBALS['module'] == 'Accounts')
{
    $orderBy = 'accounts.name ASC';
}

... in order to sort the modules by names by default. Do you know how to do this in an upgrade safe way?

How do i print out the query?

[davidboris]

Hello,

Extend list view query > Urdhva Tech: Extending List View query
Print query > Urdhva Tech: Where are the queries?

[urs.pamp@gmail.com]

Thanks for the links. I'm sorry, but I can't figure out what to do with these links.
I reckon to edit include/ListView/ListViewData.php below the line

$main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from']

Now, what exactly do i write there?

The whole function?

function listViewProcess() {
        global $current_user;
        $this->processSearchForm();
        if(!$current_user->is_admin) // remove this condition if you dont want admin user to view the "Closed Lost" Opportunities.
            $this->params['custom_where'] = ' AND opportunities.sales_stage <> "Closed Lost" ';
       
        if (empty($_REQUEST['search_form_only']) || $_REQUEST['search_form_only'] == false) {
            $this->lv->setup($this->seed, 'include/ListView/ListViewGeneric.tpl', $this->where, $this->params);
            $savedSearchName = empty($_REQUEST['saved_search_select_name']) ? '' : (' - ' . $_REQUEST['saved_search_select_name']);
            echo $this->lv->display();
        }
    }

[davidboris]

Hello,

... in order to sort the modules by names by default. Do you know how to do this in an upgrade safe way?

How do i print out the query?

Those links are the answers to your questions.

To extend the list view query you follow the steps mentioned in Urdhva Tech: Extending List View query

And to display your query on list view, you write print $main_query; right after the line $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from']

[urs.pamp@gmail.com]

Thank you very much, davidboris! I didn't thought I had to really do the exact same thing. Sorry for that!

Now, i got the queries. The query I get when accessing the module Opportunities (which by default is sorted by "name") is identical to the query I get when i click the header "Jira-Link" (a URL-field).
So the query seems to be the problem, because it's the same.

What would you recommend now?