Mochabomb

Today I added a custom column to our vtiger install we use at Direct Finance - a custom data field: Loan Purpose. I added this custom field to Accounts, Leads and Contacts and Potentials - then mapped them to eachother (so data was kept as lead was converted).

Now in looking at leads, accounts, or contacts, I want to sort by that new field - but it’s not sortable by default - neither are the created and modified times - would be useful to sort by date modified or created…

1. Using phpmyadmin ( or something like it ) find the field name in the table of interest - for vtiger_accounts it was a new custom field called cf_461 - make sure to use the database field name, not the field label.

2. Edit Accounts.php, Contacts.php, and Leads.php (note the file name is the module name ending in “s” ) this is the line to modify:
var $sortby_fields = Array('accountname','city','website','phone','smownerid');
to something like:
var $sortby_fields = Array('cf_461','createdtime','accountname','city','website','phone','smownerid');

Now you can sort by your new custom field - or any field in that module when a custom view is created.