For userattr, msgattr, and mapi commands.
<stringoperator> determines whether the specified text, or search term, must be present or absent.
Important! Search terms are defined by the <text> value. You must enclose the <text> search terms in double quotes. This even applies to single-word search terms.
The following operators are supported:
These operators are interchangeable. They define one or more search terms that must be present exactly as specified (although * wildcards are permitted).
The Data Lookup test returns a True value if CA DataMinder detects any of these terms for an individual sender or recipient. (If it detects none of the search terms, the test returns a False value.)
For example, you can use this to detect e-mails, for example, where a recipient is in the Securities Services team:
WHERE Team IS "Securities Services"
Similarly, you can use this operator to detect emails, for example, where a recipient is in either the London or Paris offices:
WHERE Team IS ANY {"London","Paris"}
This operator defines a search term that must not be present. The Data Lookup test returns a True value if CA DataMinder detects this term for an individual sender or recipient. (If this term is not detected, the test returns a False value.)
For example, you can use this to detect e-mails where, for example, none of the recipients are in the Equity Markets team:
WHERE Team IS NOT "Equity Markets"
This operator defines multiple search terms, none of which must be present. The Data Lookup test returns a True value if CA DataMinder detects none of these terms for an individual sender or recipient. (If any of these terms are detected, the test returns a False value.)
For example, you can use this to detect emails where, for example, none of the recipients are in the Hong Kong, Kuala Lumpur or Tokyo offices:
WHERE Office IS NOT ALL {"Hong Kong","Kuala Lumpur","Tokyo"}
Note: This operator is rarely used in practice.
These operators are interchangeable. They define one or more search terms that must be present. Implicit leading and trailing * wildcards are added to any search terms specified by this operator. The Data Lookup test returns a True value if CA DataMinder detects any of these terms for an individual sender or recipient. (If none of these terms are detected, the test returns a False value.)
For example, you can use the extract below to detect e-mails where a recipient belongs to a team such as ‘Securities Services’ or ‘Global Securities’:
WHERE Team CONTAINS "Securities"
Similarly, you can use these operators to detect e-mails, for example, where a recipient is in either the Equity Markets, Debt Markets or Securities Services teams:
WHERE Team CONTAINS ANY {"Equity","Debt","Securities"}
These operators are interchangeable. They define multiple search terms that must be present. The Data Lookup test returns a True value if CA DataMinder detects all of these terms for an individual sender or recipient. (If it fails to detect any term, the test returns a False value.)
For example, you can use this to block e-mails where a recipient’s team name contains the terms ‘Equity’ and ‘Markets’. The trigger will not activate if the recipient is a member of, for example, the Debt Markets team.
WHERE Team CONTAINS ALL {"Equity","Markets"}
These operators are interchangeable. They define one or more search terms that must not be present. The Data Lookup test returns a True value if CA DataMinder detects none of these terms for an individual sender or recipient. (If any of these terms are detected, the test returns a False value.)
This enables you to exempt e-mails if a term is detected (because the test returns a False value so the control trigger will not activate). For example, you can use this to block an email unless one or more recipients is a Manager.
WHERE Rank EXCLUDES "Manager"
Likewise, you can exempt emails only if a manager or director is included in the recipient list:
WHERE Rank EXCLUDES ALL {"Manager","Director"}
This operator defines multiple search terms that must not be present. The Data Lookup test returns a True value if CA DataMinder fails to detect any of these terms for an individual sender or recipient. (If all of these terms are detected, the test returns a False value.)
This enables you to exempt emails if all of the listed terms are detected (because the test returns a False value so the trigger will not activate). For example, you can use this to block an email unless one or more recipients is a Senior Manager.
WHERE Rank EXCLUDES ANY {"Manager","Senior"}
Note: When using the CONTAINS or EXCLUDES operators, be aware that it is often more efficient to use the IS or IS NOT operators, respectively. The example below uses an exact match:
msgattr WHERE %recipient% IS "Sales
and is therefore more efficient than the following example, which infers a substring match:
msgattr WHERE %recipient% CONTAINS "Sales"
|
Copyright © 2014 CA.
All rights reserved.
|
|