Using an OR condition in an initial_filter in display_params

SuiteCRM Forum - English Language Developer Collaboration
1

Is there a way to use an OR condition in an initial_filter in display_params?

I have the initial_filter working for my Contacts->Accounts relate field in my editviewdefs.php file with the following code:

1 => 
array (
    'name' => 'contacts_accounts_1_name',
    'label' => 'LBL_CONTACTS_ACCOUNTS_1_FROM_CONTACTS_TITLE',
    'displayParams' => array (
        'initial_filter' => '&funds_rotary_member_c_advanced=memberKCRC',
    ),
),

I have seen posts on how to have mutliple fields included in the initial_filter when the condition is AND

Is it possible to have an OR condition in the initial_filter on the same field?
Something like (this does NOT work)

1 => 
array (
    'name' => 'contacts_accounts_1_name',
    'label' => 'LBL_CONTACTS_ACCOUNTS_1_FROM_CONTACTS_TITLE',
    'displayParams' => array (
        'initial_filter' => '&funds_rotary_member_c_advanced="memberKCRC" OR funds_rotary_member_c_advanced="memberKCRChonourary"',
    ),
),

If so, how?

2

Can you try (edited)

        'initial_filter' => '&funds_rotary_member_c_advanced[]=memberKCRC&funds_rotary_member_c_advanced[]=memberKCRChonourary',
1 Like
3

@blqt

Thank you, that worked!

I was tempted to not even try it since it looked like I was creating an AND condition.

But … make the edit suggested, QR&R, and it worked like a charm.

Appreciate the help and the quick reply.