Leads - Sort name column by last name in Listview

[Gorgar]

Hello,

maybe this is trivial and I'm too blind to find the right option. I'd like the name column in the listview of leads to be sorted by last_name instead of first_name. My first guess was to change the locale setting and set l first, but it has no effects.

Also changes in listviewdefs.php turned out unsuccessfull. Maybe someone can give me a hint?

Many thanks in advance...

[DragonflyMaster]

Hello,

maybe this is trivial and I'm too blind to find the right option. I'd like the name column in the listview of leads to be sorted by last_name instead of first_name. My first guess was to change the locale setting and set l first, but it has no effects.

Also changes in listviewdefs.php turned out unsuccessfull. Maybe someone can give me a hint?

Many thanks in advance...

That's because "name" is "first name + last name".
To sort the listview by last name, go in Admin->Studio->Leads->Layouts->Listview
and move "last name" to Default column, then save&deploy.

[Gorgar]

That's because "name" is "first name + last name".
To sort the listview by last name, go in Admin->Studio->Leads->Layouts->Listview
and move "last name" to Default column, then save&deploy.

Indeed, but it also includes "salutation" and this is ignored. it seems only to be an issue of changing the sequence of variables or a small change to a sql query. I'm interested in the former, but if a code change is neccessary I would accept that finally.

I already tried your proposal, added the three types of fields to the listview layout (salutation, first name and last name). But after the removal of Name, no results were shown in the listview. So "Name" is obviously absolute neccessary? And there is no option I can set in the vardefs.php or listviewdefs.php (e.g sort_on or sort_by)?

Thx

[DragonflyMaster]

If you look in your cache folder, you'll find a Leadvardefs.php inside cache/modules/Leads/; in there you'll see this:

   'name' => 
      array (
        'name' => 'name',
        'rname' => 'name',
        'vname' => 'LBL_FULL_NAME',
        'type' => 'name',
        'fields' => 
        array (
          0 => 'first_name',
          1 => 'last_name',
        ),
        'sort_on' => 'last_name',
        'source' => 'non-db',
        'group' => 'last_name',
        'len' => '255',
        'db_concat_fields' => 
        array (
          0 => 'first_name',
        1 => 'last_name',
        ), 
  

Inverting the last two lines makes that field sortable by last name:

 0 => 'last_name',
1 => 'first_name', 
  

CON: this file is inside the cache folder so it is overwritten at any code change.

[Gorgar]

Many thanks, that was the right hint. For the present it does the job pretty well...

[cgray]

If you want to make this upgrade safe, make the change in custom/Extension/modules/Leads/Ext/Vardefs/vardefs.ext.php

<?php
/*****************************************************************************
Modify the sort order of Leads name
currently sorts by first name.
modify so that it sorts by last name, then first name 
See: https://www.sugarcrm.com/forums/showthread.php?t=33427
and: http://a17g.com/?p=20
 ********************************************************************************/
$dictionary["Lead"]["fields"]["name"]["db_concat_fields"] = array (
	0 => 'last_name',
	1 => 'first_name',
      );
?>

Then do a Quick Rebuild and Repair of the Leads module