HOW TO sort by "number" in listview ?

[dekleinemedia]

Hi,

I've made an custom module called "Acc_Accounts".
I also created the field "number". Now i've created some new data within.
When i go to the listview of my module, i want to let it sort by "number" (ascending) and not by standard "name" (ascending)

See screenshot

Where can i change or modify this?

Do i have to create the file listviewdefs.php and copy this in
custom\modules\Acc_Accounts\metadata ?

What code do i have to add or modify?

Thankssss

[crmbalah]

hi
customize you query like this

select number from (table) order by (number+0);

[dekleinemedia]

thanks, but I would like to change this in my php code..

any ideas?

I very appreciate

[dekleinemedia]

I already find out the answer.

See earlier post;

http://www.sugarcrm.com/forums/showt...change+sort+by

It works great

[crmbalah]

Hi
ok just customize the number field like your mention url this will work. try this.
otherwise customize your list query form include/ listview/ListViewData.php.