custom approval workflow with 2 level of approvals.

Question

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.

lerodriguezdiez · Answer

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 )

Endpoint Privilege Management

custom approval workflow with 2 level of approvals.