Customize query in popup view

SugarCRM, SuiteCRM Navin Rakhonde
This is a way to customize the SQL queries inside the popup( view.popup.php ) in SugarCRM / SuiteCRM. Create a file called view.popup.php in \custom\modules\< module >\views with this: if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); class <module>ViewPopup extends ViewPopup{ public function listViewProcess(){ parent::listViewProcess(); $this->params['custom_select'] = " CUSTOM SELECT";…
Read More

SugarCRM: Populating fields using a Relate field

SugarCRM, SuiteCRM Navin Rakhonde
This will enable you to populate a field/fields when a value is selected in a relate field. Steps are as below, Step 1:  Go to <sugar>/custom/Extension/modules/<MODULE_NAME>/Ext/Vardefs/ and create a new file (ex. vardef.ext.php) Step 2:  Add the following codes to the file: (This is for the quicksearch) $dictionary['<MODULE_NAME>']['fields']['<RELATE_FIELD>']['populate_list'] = array('name', 'id',…
Read More