[Vtigercrm-developers] Daft Question on Account popup search

[Maggi Conrado Reingenia]

Hi. 

The issue is the query. The address fields are not in the query result. To make this work we have modified the function in listviewutils. I can't remenber exactly what function was. But was there. 

Hope this helps 

Regards 

Conrado

-----Original Message-----
From: "Alan Lord (News)" <alanslists at gmail.com>
Sender: vtigercrm-developers-bounces at lists.vtigercrm.com
Date: Tue, 04 Dec 2012 19:18:52 
To: <vtigercrm-developers at lists.vtigercrm.com>
Reply-To: vtigercrm-developers at lists.vtigercrm.com
Subject: [Vtigercrm-developers] Daft Question on Account popup search

I can't work out why this isn't working...

My customer wants a couple more fields on the Account popup (from a UI 
type 10) so that he can better choose which account to select.

So I modified the Account.php class like this:

var $search_fields = Array(
'Account Name'=>Array('vtiger_account'=>'accountname'),
'Billing Address'=>Array('vtiger_accountbillads'=>'bill_street'),
'Billing Code'=>Array('vtiger_accountbillads'=>'bill_code'),
'Billing City'=>Array('vtiger_accountbillads'=>'bill_city'),
'Phone'=>Array('vtiger_account'=>'phone'),
'Assigned To'=>Array('vtiger_crmentity'=>'smownerid'),
);

var $search_fields_name = Array(
'Account Name'=>'accountname',
'Billing Address'=>'bill_street',
'Billing Code'=>'bill_code',
'Billing City'=>'bill_city',
'Phone'=>'phone',
'Assigned To'=>'assigned_user_id',
);

And although the columns display in the popup and the headings are 
correct (based on the language pack) the only additional column that 
shows any data is the "Phone" column.

Address and Postcode fields always stay blank.

I've also tried using the "vtlib" module style where the Array() 
declaration doesn't use the vtiger_ table prefix nor the => between 
array elements. But this made no difference at all... And there was 
nothing of note in the logs.

Anyone got any ideas?

Cheers

Al


-- 
Libertus Solutions
http://www.libertus.co.uk

_______________________________________________
http://www.vtiger.com/