Documentation Center

Filter rules

You can make filters as complex as you want by using the AND/OR operators.

Using AND and OR together to combine rules

If there is a combination of ORs and ANDs, there can be problems with the results. For example:

  • Rule-One: Termbase entry field Created on is greater than 1-January-2009.
  • AND
  • Rule-Two: Termbase entry field Created by exactly matches 'John Smith'.
  • OR
  • Rule-Three: Termbase entry field Created by exactly matches 'Mary Brown'.

This could mean:

  • Rule-One AND (Rule-Two OR Rule-Three). An entry must be created after 1-January-2009 and created by either John Smith or by Mary Brown.
  • (Rule-One AND Rule-Two) OR Rule-Three An entry must be created after 1-January-2009 and by John Smith, or it must be created by Mary Brown at any date.

What MultiTerm does it to evaluate all the ANDs before it evaluates the ORs, the example is interpreted as:

  • (Rule-One AND Rule-Two) OR Rule-Three

So an entry must be created after 1-January-2009 and by John Smith, or it must be created by Mary Brown at any date.