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
  • I think I see the issue. 

    In the query you posted you have:   'V_UID_Attestationcase'  

    By putting that in single quote you are turning it into a literal string. You should be referencing the variable instead. That variable is probably already exposed to you. 

    Going from an example of something we currently have in production use:  

    where UID_AttestationCase = '@UID_AttestationCase' 

    Quick note:  Setting the number of approvers to 3 means that 3 people would need to approve it to pass this step.

    Here is the similar personwantsorg CP rule. The function is different but the important part is how we are referencing the PWO that we are working with, You should be able to use a similar method to reference the AttestationCase you are workign with

Reply
  • I think I see the issue. 

    In the query you posted you have:   'V_UID_Attestationcase'  

    By putting that in single quote you are turning it into a literal string. You should be referencing the variable instead. That variable is probably already exposed to you. 

    Going from an example of something we currently have in production use:  

    where UID_AttestationCase = '@UID_AttestationCase' 

    Quick note:  Setting the number of approvers to 3 means that 3 people would need to approve it to pass this step.

    Here is the similar personwantsorg CP rule. The function is different but the important part is how we are referencing the PWO that we are working with, You should be able to use a similar method to reference the AttestationCase you are workign with

Children
No Data