vtiger

[sharok]

Hi All,

can any one help me please about how to have "sort order" capability for a newly added column? at the moment this feature is available just for some of the columns.

many thanks,

Sharok

[joebordes]

http://wiki.vtiger.com/index.php/Developers_How_To%27s#How_do_you_create_another_sort_column_in_the_Contact_Tab.3F

[sharok]

Hi there,
thanks for the reply. my added column is in Sales Order under Sales menu. we don't have the same situation as contacts for the sales order. any ideas please?

[joebordes]

Hi,

It is exactly the same, you have to modify the same array $sortby_fields but in another module

Joe
TSolucio

[sharok]

Hi Joe & thanks again,
I've gone to SalesOrder.php and edited the following line:
var $sortby_fields = Array('subject','crmid','smownerid','accountname','lastname','Test');
Test is my new column, but to no avail! do I need anything else to do?
thanks,
Sharok

[joebordes]

Hi,

The array has a list of table column names, NOT column labels.
So your filed is NOT named Test. You will have to look for the name vtigerCRM has assigned to your custom field column and put that name there. It will be in the table vtiger_salesordercf with a name of the type cf_###, for example cf_456

Joe
TSolucio

[sharok]

Thank you very much indeed, Joe
I put cf_547 and it worked perfectly. May I ask how can I do this for existing columns like 'Due Date' in 'Sales Orders'? Would I be able to get it to have sort order feature on it?

thank you very much again,

Sharok

[sharok]

Sorry I bothered you again Joe,

I think I found it. I need to look at vtiger_salesorder table.

many thanks for your all kindly help.

Cheers!

Sharok