Hi guys,
I am creating a Saved Search on a transaction, with the following requirements:
The record should only appear if the role currently used by the user (current role) is the same as the value in the custom field custbody_next_approver_role.
I have tried using the following formula:
CASE WHEN {user.role} = {custbody_next_approver_role} THEN 1 ELSE 0 END
However, I noticed that the record still appears even though I log in with a different role. It is as if {user.role} reads all roles owned by the user, not the role currently used in the current session.
The question is:
Does {user.role} really read all roles?
How do I compare the current active role with the custom field in the transaction?
Is there another way (for example via script or custom field) to capture the active role and use it in Saved Search?
Thanks in advance for your help 🙏