How to create a non-db field linked to a custom field in a related module?

Question

I have two custom fields ( field_one_c, field_two_c ) in Account module. I want to display the field_one and field_two values in the cases modules details view . In the cases module, we have to display these fields value of the particular account which is linked to that case.
These value should not be stored in the cases table. We just have to display the values in the cases Detail view.
I have followed this two ways but it is not meeting the requirements.

I tried calculated fields but its storing the value in the database.
I have tried the non db field but it is not display the value ( because As per sugarcrm, custom fields from related modules will not be display ( available) . Check this url : http://developer.sugarcrm.com/2012/03/13/howto-grab-fields-from-a-related-record-without-sugar-logic... )

Any help would be greatly appreciated.

Thanks

Ananth. K

Community Alumni User · Answer

I cant get that developer link to work here but that would be how I would do it. A non-db field that is filled in from a after_retrieve logic hook.

So I would add a non-db field like

<?php
$dictionary['Task']['fields']['customerName'] = array(
	'name' => 'customerName',
	'type' => 'varchar',
	'source' => 'non-db',
	'len' => '255',
	'vname' => 'LBL_CUSTOMERNAME',
);

and then fill it from an after_retrieve logic hook like this

<?php
public function afterRetrieveLogic(SugarBean $bean, $event, $arguments)
	{
		$parent_id = $bean->parent_id;
		$parent_type = $bean->parent_type;
		if ($parent_type == 'Accounts') {
			$locationBean = BeanFactory::getBean('Accounts', $parent_id);
			if (!empty($locationBean->name)) {
				$bean->locationName = $locationBean->name;
				$customerName = $locationBean->accounts_accounts_3_name;
				if (!empty($customerName)) {
					$bean->customerName = $customerName;
				}
			}
		}
	}