sort contacts listview by first_name

[tobyrhodes]

Hi all.

I have a new install of Sugar Community Edition v5.5.0 (build 6653).

Does anyone know how to change the contacts listview name sorting (i.e. when you click on the column heading) to be on first_name rather than last_name?

I managed to fix this in an older version of Sugar a few years ago, but can't remember how I did it.

Many thanks in advance
Toby

[davidboris]

Hello,

If you already have listviewdefs.php in custom/modules/Contacts/metadata
Just change

 'orderBy' => 'last_name', 
  

to

 'orderBy' => 'first_name', 
  

for name field and do quick repair and rebuild.

[tobyrhodes]

Many thanks for taking the time to reply.
I tried that, and did a repair & build, but it didn't seem to fix things.
However, I have solved my problem in another way ... I have replaced the "Name" field in the list view with first_name and last_name, then sorted on first_name.

cheers
Toby

[davidboris]

Hello,

You broke the full_name feature of sugar, that is also possible but my suggestion should also work. It worked for me!