• State Suggested Answer
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 99 subscribers
  • Views 7561 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

custom approval workflow with 2 level of approvals.

richa

I want to create a custom approval workflow with 2 levels of approvals. In first level approval i am using recepient's manager. in second level approval i want to assign the approval process to some ad group which contains recepient's manager also but he should not approve it.

Parents
  • +1
    I would maybe do the following
    - 1: Create a business role and a dynamc group where you could see all employees that are members of that group.
    -2: Then, use de OR approval proccedure and select option "no automatic approval"

    For the dynamic role I would use SQL clause and should be something like this:

    EXISTS ( SELECT 1 FROM (SELECT UID_Person FROM ADSAccount WHERE (XMarkedForDeletion = 0) AND ( EXISTS ( SELECT 1 FROM (SELECT UID_ADSAccount FROM ADSAccountInADSGroup WHERE EXISTS ( SELECT 1 FROM (SELECT UID_ADSGroup FROM ADSGroup WHERE cn = N'XXXXX') as X WHERE X.UID_ADSGroup = ADSAccountInADSGroup.UID_ADSGroup ) ) as X WHERE X.UID_ADSAccount = ADSAccount.UID_ADSAccount ) )) as X WHERE X.UID_Person = Person.UID_Person )
Reply
  • +1
    I would maybe do the following
    - 1: Create a business role and a dynamc group where you could see all employees that are members of that group.
    -2: Then, use de OR approval proccedure and select option "no automatic approval"

    For the dynamic role I would use SQL clause and should be something like this:

    EXISTS ( SELECT 1 FROM (SELECT UID_Person FROM ADSAccount WHERE (XMarkedForDeletion = 0) AND ( EXISTS ( SELECT 1 FROM (SELECT UID_ADSAccount FROM ADSAccountInADSGroup WHERE EXISTS ( SELECT 1 FROM (SELECT UID_ADSGroup FROM ADSGroup WHERE cn = N'XXXXX') as X WHERE X.UID_ADSGroup = ADSAccountInADSGroup.UID_ADSGroup ) ) as X WHERE X.UID_ADSAccount = ADSAccount.UID_ADSAccount ) )) as X WHERE X.UID_Person = Person.UID_Person )
Children
No Data