to meet our change management approval needs, we have added an array to the assignment table that contains a list of approvers for each assignment. each approver operator has the same change profile which puts them all in the same cm3groups record. right now, all approvers are able to approve any change, and i need to add logic to limit approval capabilities based on assignment.
my thought was to create a new variable in login.default that would hold all assignments that an operator is an approver for, then use that variable in my approval conditions. if i make my query approvers=operator(), my variable contains the first assignment the operator is an approver for. if i make my query operator() isin approvers, my variable is null.
i have a partial workaround that involves a query/calculation on the cm3r format control, but this only solves the issue of approval permissions. i'm still left without a way to setup an inbox/view to show operators changes pending their approvals.
is there a different way for me to format my query on login.default or another solution altogether that could capture an operator's approval groups from the array in assignment?