How to Force an "AND" Operator in MultiSelect Search

💬 General Discussion
1

Hi. I created a MultiSelect containing a list of multiple languages. I need to be able to filter on, for example, where languages_spoken equals english AND chinese, but suitecrm appears to only do OR searches. Are AND searches possible? Thanks.

2

actually there isn’t a fast way to do that. i’ve found this:

You have to modify custom/modules/<module_name>/metadata/searchdefs.php

add below code to your field dropdown from multiselect

'displayParams' => array(     
      'size' => 1, 
),

 
Sample Code:

      'issezcustomer_c' =>       array (
        'type' => 'enum',
        'default' => true,
        'studio' => 'visible',
        'label' => 'LBL_ISSEZCUSTOMER',
        'width' => '10%',
        'name' => 'issezcustomer_c',
        'displayParams' => array( 
               'size' => 1, 
         ),
      ),

     
Perform repair rebuild from admin panel.

Try it and let us know