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

Recalculate an AttestationCase and reset it

Hi,

in my attestation I have a custom Approval procedure with a query to determine the approver for a determinate step.

I'd like to recalculate the AttestationHelper step if the result of the query change.

I can trigger a process when the field where the query go to take the approvers and filter the attestationHelper with the old one approver for that step.

So I'll have a group of AttestationCase to recalculate and reset it.

I already saw the other thread about this but it doesn't fit to me. I need to give the sql procedure the attestationHelper UIDS.

Some time ago I did the same for PWOHelperPWO calling the follow sql script:

insert into @DBQueueElements (object, subobject, genprocid) select x.uid, null, @GenProcID from (select h.UID_PersonWantsOrg as uid from ((select * from PWOHelperPWO where uid_PersonHead = @UID_Person)h join (select * from PersonWantsOrg where orderState in (select Orderstate from QER_VPWOOrderState where isOrder = 1)) pwo on h.UID_PersonWantsOrg = pwo.UID_PersonWantsOrg)) as x

exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackPWOHelperPWO', @DBQueueElements, null, 1

where in @DBQueueElements I hade UID of PersonWantsOrgs that involve the old approvers.

There is a similar script like 'QER-K-ShoppingRackPWOHelperPWO' but for Attestation?

I can't find where is defined this 'QER-K-ShoppingRackPWOHelperPWO' in the DB.

Thanks

Mik

I'm on 7.1