ITShop - Approval workflow - Calculated group of approvers

Question

Hi,

I try to use the "CP - Calculated group of approvers" procedure.

First I try to select the manager of the "UID_PersonOrdered" person with the condition below:

select *

from Person

where UID_Person in

(

select UID_PersonHead

from Person

where UID_Person = '@UID_PersonOrdered'

)

But the request was aborted with the following reason: "Approval decided by the system, no approver available."

This is why I suppose my condition is not correct.

Does anyone see the error?

Regards,

Serge

Steffen.Einert · Accepted Answer

Hi Serge, I'm running out of ideas. (nearly) In PersonWantsOrg we have 2 different UID_Person fields: UID_PersonInserted ... the person which CREATES the request UD_PersonOrdered ... the person which is the RECIPIENT of the order. I think the latest condition in the CP step is: select p.UID_PersonHead as UID_Person from Person p join PersonWantsOrg pwo on p.UID_Person = pwo.UID_PersonOrdered where pwo.UID_PersonWantsOrg = 'v_uid_personwantsorg' That means: The decider is the manager (UID_PersonHead) of the recipient. It's a very simple condition and should work. Are you sure that the recipient has a manager assigned? Additionally you can check the config parm "QER\ITShop\Person Ordered NoDecide" (I'm not sure if the creator is the same as the recipient) Regards, Steffen

oliver.paulzen · Answer

Yes, if config parameter QER\ITShop\DecisionOnInsert is enabled. HTH, Oliver

Geraldine Hopf · Answer

Hi Serge, check you config parms in Designer: QER\ITShop\PersonInsertedNoDecide Regards, Geraldine