• State Verified Answer
  • Locked Locked
  • Replies 16 replies
  • Answers 2 answers
  • Subscribers 93 subscribers
  • Views 13535 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,

    this statement is the best base:

    select p.UID_PersonHead

    from Person p

    join PersonWantsOrg pwo

    on p.UID_Person = pwo.UID_PersonOrdered

    where pwo.UID_PersonWantsOrg = '@UID_PersonWantsOrg'

    ... but you have to add an alias because the statement must return exactly one column with the name UID_Person:

    select p.UID_PersonHead as UID_Person

    from Person p

    join PersonWantsOrg pwo

    on p.UID_Person = pwo.UID_PersonOrdered

    where pwo.UID_PersonWantsOrg = '@UID_PersonWantsOrg'

    I have two ideas to the problem:

    1. The requestor is the same as the decider and your config parm "QER\ITShop\PersonInsertedNoDecide" is active.

    2. You are using an Oracle server for the Q1IM database.

    In this case you have to use "v_uid_personwantsorg" instead of "@UID_PersonWantsOrg".

    Regards,

    Steffen

Reply
  • 0 over 10 years ago

    Hi Serge,

    this statement is the best base:

    select p.UID_PersonHead

    from Person p

    join PersonWantsOrg pwo

    on p.UID_Person = pwo.UID_PersonOrdered

    where pwo.UID_PersonWantsOrg = '@UID_PersonWantsOrg'

    ... but you have to add an alias because the statement must return exactly one column with the name UID_Person:

    select p.UID_PersonHead as UID_Person

    from Person p

    join PersonWantsOrg pwo

    on p.UID_Person = pwo.UID_PersonOrdered

    where pwo.UID_PersonWantsOrg = '@UID_PersonWantsOrg'

    I have two ideas to the problem:

    1. The requestor is the same as the decider and your config parm "QER\ITShop\PersonInsertedNoDecide" is active.

    2. You are using an Oracle server for the Q1IM database.

    In this case you have to use "v_uid_personwantsorg" instead of "@UID_PersonWantsOrg".

    Regards,

    Steffen

Children
No Data