7.5 Filters: how do I add "is any of" to the options for a field in a filter?

Hi everyone,

The ability to filter on multiple assigned users is being added to 7.7. The assigned to filter will have the "Is any of" and "Is not any of" options instead of the "Is" and "Is not" options. Similar functionality is being added to relate-type fields too. For example, you can search for multiple related accounts on the contacts list view.

Please follow the releases category in the community to be alerted when 7.7 releases.

I hope this helps!
Alex

Hi everyone,

The ability to filter on multiple assigned users is being added to 7.7. The assigned to filter will have the "Is any of" and "Is not any of" options instead of the "Is" and "Is not" options. Similar functionality is being added to relate-type fields too. For example, you can search for multiple related accounts on the contacts list view.

Please follow the releases category in the community to be alerted when 7.7 releases.

I hope this helps!
Alex

Hi Everyone,

I Think , I got the answer for your Questions .

Copy operators.php file (Location::: clients/base/filters/operators/operators.php) and create a custom file  and paste operators.php file  inside (Location :: custom/clients/base/filters/operators/operators.php).

and  add  "require_once('clients/base/filters/operators/operators.php'); " in custom operators.php file and now you can change values based on your requirements

Example:

require_once('clients/base/filters/operators/operators.php');

$viewdefs['base']['filter']['operators'] = array(

    'multienum' => array(

        '$contains' => 'LBL_OPERATOR_CONTAINS',

        '$not_contains' => 'LBL_OPERATOR_NOT_CONTAINS',

         '$in' => 'LBL_OPERATOR_CONTAINS',

        '$not_in' => 'LBL_OPERATOR_NOT_CONTAINS',

    ),

    'enum' => array(

        '$in' => 'LBL_OPERATOR_CONTAINS',

        '$not_in' => 'LBL_OPERATOR_NOT_CONTAINS',

    ),

    'varchar' => array(

        '$equals' => 'LBL_OPERATOR_MATCHES',

        '$starts' => 'LBL_OPERATOR_STARTS_WITH',

        '$in' => 'LBL_OPERATOR_CONTAINS',

        '$not_in' => 'LBL_OPERATOR_NOT_CONTAINS',

        '$contains' => 'LBL_OPERATOR_CONTAINS',

        '$not_contains' => 'LBL_OPERATOR_NOT_CONTAINS',

    ),

    'name' => array(

        '$equals' => 'LBL_OPERATOR_MATCHES',

        '$starts' => 'LBL_OPERATOR_STARTS_WITH',

        '$in' => 'LBL_OPERATOR_CONTAINS',

        '$not_in' => 'LBL_OPERATOR_NOT_CONTAINS',

        '$contains' => 'LBL_OPERATOR_CONTAINS',

        '$not_contains' => 'LBL_OPERATOR_NOT_CONTAINS',

    ),

......

Finally, we can now navigate to Admin > Repair > Quick Repair and Rebuild

now we can search for multiple related accounts on the contacts list view also.

I did for

  'name' => array(

        '$equals' => 'LBL_OPERATOR_MATCHES',

        '$starts' => 'LBL_OPERATOR_STARTS_WITH',

        '$in' => 'LBL_OPERATOR_CONTAINS',

        '$not_in' => 'LBL_OPERATOR_NOT_CONTAINS',

        '$contains' => 'LBL_OPERATOR_CONTAINS',

        '$not_contains' => 'LBL_OPERATOR_NOT_CONTAINS',

    ),

PFA

I hope this helps!

Thanks

SK