• State Not Answered
  • Locked Locked
  • Replies 10 replies
  • Subscribers 94 subscribers
  • Views 6961 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

Multiple approvers in single Step

sloothra
over 8 years ago

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
  • 0 over 8 years ago

    I need to put another check at the start now. This is a CD step. If the requester of the account is the same as the Owner then the request should directly go to the next level.

    I have this condition in the CD step:

    exists(select 1 from attestationcase where ObjectKey1=PropertyInfo1 and uid_attestationcase='v_uid_AttestationCase')

    PropertyInfo1 value is the Requestor value and ObjectKey1 is the owner value. Now this works in SQL developer when I replace the uid_attestationcase with a value but doesn't work with v_uid_attestationcase.

    Any suggestions?

Reply
  • 0 over 8 years ago

    I need to put another check at the start now. This is a CD step. If the requester of the account is the same as the Owner then the request should directly go to the next level.

    I have this condition in the CD step:

    exists(select 1 from attestationcase where ObjectKey1=PropertyInfo1 and uid_attestationcase='v_uid_AttestationCase')

    PropertyInfo1 value is the Requestor value and ObjectKey1 is the owner value. Now this works in SQL developer when I replace the uid_attestationcase with a value but doesn't work with v_uid_attestationcase.

    Any suggestions?

Children
No Data