• State Verified Answer
  • Locked Locked
  • Replies 16 replies
  • Answers 2 answers
  • Subscribers 93 subscribers
  • Views 13344 views
  • Users 0 members are here
Options
Related
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

ITShop - Approval workflow - Calculated group of approvers

Serge Bouchut
over 10 years ago

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

Parents
  • 0 over 10 years ago

    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\PersonOrderedNoDecide"

    (I'm not sure if the creator is the same as the recipient)

    Regards,

    Steffen

Reply
  • 0 over 10 years ago

    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\PersonOrderedNoDecide"

    (I'm not sure if the creator is the same as the recipient)

    Regards,

    Steffen

Children
No Data