How to display specific account entries in a popup window

Question

I created one field 'account_category'in account module. It has a drop-down list and has the following options:

• principle
• customer
• the supplier
• manufacturer

I created an account with the Opportunity module.

In the "Account" pop-up window, I want to display only those accounts that have account_category as a principle.

My file path: user / modules / feature / metadata / editviewdef.php

1 => 
          array (
            'name' => 'opportunities_accounts_1_name',
           'displayParams' => 
            array (
              'initial_filter' => '&account_category_c="Principle"',
            ),
          ),

But it does not work.

Please help filter accounts based on account_category_c as a principle

Answer 1

Add the word _advanced as follows:

'initial_filter' => '&account_category_c_advanced="Principle"',

see:

http://academe.co.uk/2013/03/sugarcrm-relate-field-passing-default-values-to-pop-up-select-form/

http://developer.sugarcrm.com/2011/08/31/howto-using-a-relate-field-to-populate-a-custom-field/