How to sort prospects by last name not first

[tpszeman]

Hi,

In default my SugarCRM 4.5.0h lead list sorts by first name-last name not last name-first name and I can't seem to change it only with complicated workarounds.
Anybody can help why it's like that, and how it can be solved? It would be of great help.

[kbrill]

Hi,

In default my SugarCRM 4.5.0h lead list sorts by first name-last name not last name-first name and I can't seem to change it only with complicated workarounds.
Anybody can help why it's like that, and how it can be solved? It would be of great help.

I can't recreate that here, mine sorts by last_name. If you edit your Leads/vardefs.php file you will see:

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

and this is what controls the sort order

[tpszeman]

Thanks a lot. I was searching around on this line as it seemed to be correct and I found this:
It seems to be a bug in studio. I customized my listview and the file it creates with the customized defs goes to
\custom\modules\leads\'metadata\listviewdefs.php

In Leads a line was missing from the beginning of the file (at the definition of name) "orderby => 'last_name'". When I saved in contacts this line is there. All-in-all putting in this line solved the problem right away.

I reported it as a bug.

Much love, Peter