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'. |
Combine AND and ORYou can combine two search filters using logical AND and 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. Rules for AND and OR combinations: |