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.

• Previous Entry: Installing vtiger on Dreamhost and Ace-host.net
• Next Entry: Do subnet math in your head