on Apr 30, 2019Article Content
| Article Number | 000037275 |
| Applies To | RSA Product Set: Archer RSA Version/Condition: All |
| Issue | When performing an advanced search, you add filters for fields in a related application or in a leveled application. In the Advanced Operator Logic box, you use the OR operator to evaluate the filters. You click Search and a popup message is displayed with the message: The advanced operator logic is not valid. Please review your logic and update.  |
| Cause | As stated in the Archer Help article Advanced Operator Logic, "The OR operator is supported only when you are filtering fields within a single level of a leveled application or in a flat application."
|
| Resolution | If you are filtering fields across different levels and applications, you must use only the AND operator. Vote to add new functionality There is currently an Idea on RSA Link requesting support for use of the OR operator for filters on related or leveled applications. If you would like to see this functionality added, please vote for this idea: https://community.rsa.com/ideas/1662 |
| Workaround | One workaround is to build one or more "helper calculations" to handle the OR logic. Then use these helper fields in the Advanced Operator Logic (AOL) with the AND operator. |