This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to recalculate group of approvers?

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

0 Barry Jackson over 9 years ago

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.
Cancel
Up 0 Down

Cancel
0 Sergey over 9 years ago

Works like a charm, thank you!

I wonder what is your base object or conditions for this process so it would start only once and not as many times as the rows in base object table?
Cancel
Up 0 Down

Cancel
0 Sergey over 9 years ago

OK, found in default process plans condition like this one:

<PK> in (select top 1 <PK> from <BaseObject>)
Cancel
Up 0 Down

Cancel
0 robin.olivier.contractor over 8 years ago

Hello Barry,

I'm sorry to dig up this issue a year and a half later, but I stumbling upon the exact same problem in v7.1.1 when I'm trying to use a custom approval procedure I created.

Unfortunately, the picture you linked is not visible. I'm trying to follow the linked but I can an "Access denied" error even though I'm logged in using my Dell account.
Would you be able to post the picture again but in a way that would be visible ?

Thanks a lot in advance !!
Cancel
Up 0 Down

Cancel
+1 Barry Jackson over 8 years ago

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.
Cancel
Up 0 Down

Cancel
0 robin.olivier.contractor over 8 years ago

Thanks Barry !

I'll try to make this work! Thanks again.
Cancel
Up 0 Down

Cancel
0 robin.olivier.contractor over 8 years ago

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.
Cancel
Up 0 Down

Cancel