We are trying to setup an role management workflow that in case of a change in role owner for a specific role an approval is requested from the role set owner.
For this we try to configure an Decision node in the workflow that detects the change of role owner and reroutes the approval to the role set owner.
We tried different option in e Decision node but none of them seems to be fine grained enough to detect only the role owner change.
The decision node with the option contains role change looks the most promising.
If in one of the operand dropdowns you had the option to select the old value of owner UserID.
is there an out of the box way to have de Decision node detect specific changes to the role metadata (Role Owner)
As far as out of the box checks, unfortunately there aren't any. However you could still write a SELECT statement to detect whether there were any changes to specific attributes of the change roles.
I previously tried this as a PoC but never actually implemented it ... all that's needed is to compare the specific attributes between T_AV_ROLEVERSIONS and T_AV_ROLES for the same role to see if any change was done.
Here are two sample SELECT statements (attached) that should do just that. I've added some inline comments to help explain the logic ... but please do test them thoroughly