Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forÂ
Search instead forÂ
Did you mean:Â
Announcements
Products
The RSA Products section of RSA Link, where customers and partners can find product documentation, downloads, advisories, forums and other helpful resources.
I have 3 status fields, all using the same values list.
I'm trying to use a calculated field to say if the 3 fields contain either "No Concerns" or "NA", the result would be "No Concerns".
I've tried various syntax of IF(AND(CONTAINS(ANY, and can't seem to get it right.
Does anyone have any advice on how to accomplish this?
Here is what I currently have (bold statement is what isn't working 😞
If ([Submit Status]=VALUEOF([Submit Status],"Record Changed"),VALUEOF([Final Status],"Record Changed - Click Submit for Review when the record is ready for reviewers"),
If (OR([Regulatory Status]=VALUEOF([Regulatory Status],"Awaiting Review"),[Security Status]=VALUEOF([Security Status],"Awaiting Review"),[MTA Status]=VALUEOF([MTA Status],"Awaiting Review")),VALUEOF([Final Status],"Awaiting Review"),
If (OR([Regulatory Status]=VALUEOF([Regulatory Status],"Concerns Noted"),[Security Status]=VALUEOF([Security Status],"Concerns Noted"),[MTA Status]=VALUEOF([MTA Status],"Concerns Noted")),VALUEOF([Final Status],"Concerns Noted"),
If (AND(CONTAINS(ANY,
[Regulatory Status]=VALUEOF([Regulatory Status],"No Concerns","NA"),
[Security Status]=VALUEOF([Security Status],"No Concerns","NA"),
[MTA Status]=VALUEOF([MTA Status],"No Concerns","NA")),
VALUEOF([Final Status],"No Concerns")),
VALUEOF([Final Status],"Draft - Click Submit for Review when the record is ready for review!")))))
... View more
We are using Archer 6.8.03.
In a parent app there is a cross-reference field displaying as a section. We have defined multiple record permission fields in the parent app, such as administrators, coordinators (and some other similar ones), action owners. We created two Apply Conditional Layout Actions:
1. If a logged in user is an administrator or coordinator assigned to the record, display the cross-reference section in edit mode.
2. If a logged in user is an action owner assigned to the record, display the cross-reference section in read only mode.
This works fine until when an coordinator assigned him/herself into both coordinator and action owner groups. When an user is in both coordinator (or administrator) RP field and action owner RP field, then the cross-reference section is NOT displayed at all when the user opens the record again.
According to article Conflict Resolution for Apply Conditional Layout Actions ( https://community.rsa.com/t5/archer-platform-documentation/conflict-resolution-for-apply-conditional-layout-actions/ta-p/561554), this should not happen.
Multiple ACL actions can apply to the same user at the same time. When multiple ACL actions attempt to apply conflicting behaviors, RSA Archer executes the action that is highest in the following order of precedence:
Section-level Read Only
Section-level Display*
Section-level Do Not Display
Section-level Use Default Settings
Field-level Required
Field-level Read Only
Field-level Display
Field-level Do Not Display
Field-level Use Default Settings
Anyone knows how to solve the issue? Thanks.
... View more