The Record Filters design board includes a column for you to add a logical NOT operator to an expression. A logical NOT works in conjunction with an expression's Operator by negating or reversing the meaning of the operator. Although you can use the NOT operator with almost any other operator, because each comparison operator has a natural opposite counterpart, you will usually only use the NOT operator to negate advanced operators.
Note: The only operator you cannot negate is the Is Null advanced operator.
The most common use of the NOT operator is to specify values that fall outside of a set of possible values specified by the Operator and the Value. Consider the following example:
| Operator | Sample Record Filter |
|---|---|
|
NOT |
NOT Request for Information.AuthorCompanyID IN (A, S, M) |
This record filter returns all RFI records that are not related to the Architectural (A), Structural (S) or Mechanical (M) disciplines.