Customers
User information
 Loading ...
Show article in Knowledge Base

 Searching multiselect fields Export knowledge base Export     SubscribeSubscribe      Show article info

Multiselect fields can be matched in several different ways

 

You cannot match using just "Equal" or "Not equal" when the field has multiple options, when the field can contain one or more values.

 

Multiselect list fields instead have these options: 

  • Exactly equal  
  • Not exactly equal 
  • Contains all of 
  • Contains not all of
  • Contains any of 
  • Contains none of 

 

 

It is easier using an example:

Let us say that we have a multi-select custom field called "MS",  with multiple possible values: A,B,C,D and E.

 

Exactly equal:

This needs to be an exact match, to the number of values.

"MS Exactly equal (A,B,C)" only matches (A,B,C), but not (A,B,C,D), for example.

 

 
Not exactly equal: 

This is the inverse of the above - it will match anything except the exact match. 

"MS Not exactly equal (A,B,C)"  matches  (A), (A,B), (A,B,C,D), (D), (empty), but not  (A,B,C), for example.

 

 

Contains all of: 

This will match issues having all of the values. The difference with exact match is that this will also match if there are more values beyond the criteria.

"MS Contains all of (A,B,C)" will match (A,B,C), (A,B,C,D) and (A,B,C,D,E) for example.

 

 

Contains not all of:

This is the inverse of the above - it will match anything not having all the values. 

"MS Contains not all of (A,B,C)"  matches  (A), (A,B), (B,C), (D), (empty), but not  (A,B,C), (A,B,C,D) or (A,B,C,D,E) for example.

 

 

Contains any of:

This will match issues having any of the values.

"MS Contains all of (A,B,C)" will match (A), (B), (C), (A,B) ,(A,B,C), (A,B,C,D), (C,D,E), but not (D) or (empty) for example.

 

 

Contains none of: 

This will match issues having none of the values.

"MS Contains none of (A,B,C)" will match (D), (E), (D,E) or (empty), but not (A), (B), (A,B) ,(A,B,C), (A,B,C,D), (C,D,E), for example.


User comments
 Loading ...