AnsweredAssumed Answered

Module mySQL query where stored?

Question asked by cfton cfton on Nov 17, 2014
Latest reply on Nov 18, 2014 by cfton cfton
Hi,
There is a module in Sugar 6.5 that have been created before. It has a subpanel in Account module. I do need to add a column into this subpanel. I tried to add this field into :
/custom/modules/module_name/metadata/subpanels/subpanel_name.php
with following code :
  'field_name' =>
  array (
    'type' => 'relate',
    'vname' => 'LBL_NAME',
    'width' => '20%',
    'target_record_key' => 'ac.field_name',
  ),
ac is name of table
After repair and deploy it just show the column and sugarcrm.log respond Error that said it should be defined in vardefs.php
How may I define it in vardefs.php and where is its mySQL query to add those field_name into its select query? I guess it's not defined in its mySQL query.

Please help me, this is more than 3 days than I'm waiting for this issue. helllpppp me

Outcomes