How to recalculate group of approvers?

Question

I have an attestation case with calculated group of approvers, which might change over time. How can I programmatically recalculate the group?

Barry Jackson · Accepted Answer

Hi, 
 You could create a process that runs on a schedule that has a step in it that runs the following SQL statement: 
 
 I credit one of my US colleagues with providing this information. 
 Thanks, Barry.

Barry Jackson · Answer

Hi Robin, 
 
If I'm not mistaken the sql was: 
 
exec vi_ReCalcPWOHelperPWO '|CP|', '12345' 
 
But this is 'just' for V6. 
 
The equivalent for V7 is QER_PITShopHelperFillAll .... arguments are @DecisionRules, @GenProcID. 
 
I don't have an exact syntax for @DecisionRules. 
 
HTH, Barry.

robin.olivier.contractor · Answer

The correct syntaxt seems to be: exec QER_PITShopHelperFillAll @DecisionRules='####' with the '####' replaced by the UIDs thePWODecisionRules objects that must be recalculated, separated by a '|' (pipe) character.