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

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
  • Hi Serge,

    select UID_Person

    from Person

    where UID_Person in

    (

              select UID_PersonHead

              from Person

              where UID_Person = '@UID_PersonOrdered'

    )

    so replace * with UID_Person

    Regards,

    Geraldine

Reply
  • Hi Serge,

    select UID_Person

    from Person

    where UID_Person in

    (

              select UID_PersonHead

              from Person

              where UID_Person = '@UID_PersonOrdered'

    )

    so replace * with UID_Person

    Regards,

    Geraldine

Children
No Data