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

Multiple approvers in single Step

Hey Community,

We are creating an approval workflow and areusing the CP step on one level. The requirement is that we have to send this approval request to the people that have been input by the user on the web portal (IT Shop) form. There are three UID_Person fields on the form - Primary, Secondary and Additional Owner. The approval workflow should be sent to all 3 people at the same approval level.

Now the approval workflow has been attached to an approval procedure and all the owner values are put in ObjectKey1, ObjectKey2 and ObjectKey3 in attestation case.

Currently the approval workflow only sends to ObjectKey1 using the query:

select ObjectKey1 as UID_Person from AttestationCase where UID_Attestationcase = 'V_UID_Attestationcase'

To incorporate 3 at the same level, I tried adding a UNION to attach 2 more queries with ObjectKey2 and ObjectKey3 but that doesn't work.

I cannot add another CP step to the same level which I initially planned on doing.

Any help would be greatly appreciated.

Thanks
Sachin

Parents
  • Yes its the UID only. Below is what I have:

    ObjectKey1: $FK(CCC_SA_PrimaryOwner).UID_Person$

    ObjectKey2: $FK(CCC_SA_SecondaryOwner).UID_Person$

    ObjectKey3: $FK(CCC_SA_AdditionalOwner).UID_Person$

    CCC_SA_PrimaryOwner is a UID itself so I am not sure if I even need the FK(CCC_SA_PrimaryOwner).UID_Person$ but this is giving the same value as well anyways.

    The query I posted works perfectly in SQL developer when I replace the V_UID_AttestationCase variable with an actual UID_AttestationCase value and returns the 3 owners that were input during account request.

    I have tried changing the number of approvers value to 3 as well.

    Thanks
    Sachin

Reply
  • Yes its the UID only. Below is what I have:

    ObjectKey1: $FK(CCC_SA_PrimaryOwner).UID_Person$

    ObjectKey2: $FK(CCC_SA_SecondaryOwner).UID_Person$

    ObjectKey3: $FK(CCC_SA_AdditionalOwner).UID_Person$

    CCC_SA_PrimaryOwner is a UID itself so I am not sure if I even need the FK(CCC_SA_PrimaryOwner).UID_Person$ but this is giving the same value as well anyways.

    The query I posted works perfectly in SQL developer when I replace the V_UID_AttestationCase variable with an actual UID_AttestationCase value and returns the 3 owners that were input during account request.

    I have tried changing the number of approvers value to 3 as well.

    Thanks
    Sachin

Children
No Data