You can combine two search filters using logical AND or OR. To combine two search filters, add both of them as filter fields. You can add each data pool field as a filter field as often as you like. OR and AND combinations are only available for text-fields, not for numeric, boolean, date, etc. It is not allowed to use both logical operators "AND, OR" at the same time in the searchValue. Note |
---|
The logical operators makes no sense with some filters. For example: Panel |
---|
SearchField: First name SearchValue: Tom _AND_ Jack Filter: equals |
The result will be an empty list. |
Logical AND- Use "
_AND_ "- Note the blanks at the beginning and end
- AND must be in upper case
Example 1: Panel |
---|
| SearchField: First name SearchValue: Tom _AND_ Jack Filter: unequals. This can be used to find all persons, except those with the first name 'Tom' or 'Jack'. |
Example 2:
Panel |
---|
| SearchField: First name SearchValue: Tom _AND_ Jack _AND_ Julian Filter: unequals. This can be used to find all persons, except those with the first name 'Tom' or 'Jack' or 'Julian'. |
Example 3: When translatable values are used, the non-translated symbolic names have to be used. Panel |
---|
| SearchField: Identity Status SearchValue: CtEmployee _AND_ CtContractor Filter: unequals |
Logical OR- Use "
_OR_ "- Note the blanks at the beginning and end
- OR must be in upper case
Example 1: Panel |
---|
| SearchField: Department SearchValue: Development _OR_ Finance Filter: equals This can be used to find all entries having department 'Development' or 'Finance'. |
Example 2:
Panel |
---|
| SearchField: Department SearchValue: Development _OR_ Finance _OR_ Sales Filter: equals. This can be used to find all entries having department 'Development' or 'Finance' or 'Sales'. |
|