Hi All,
I am receiving the following error when requesting an Item Through IT Shop 'Automatic System approval: No approver available (in this shop).
Context below.
Custom Table
I have created a custom table which will populate with First and Second Level approvers (UID_Person) using a script I also created.
Approval Procedures
I have created 3 Custom Approval Procedures
RT - Checks the request type - determined by the Requesters (UID_PersonInserted) 's Department Shortname. Query Below
Select UID_Person from Person where UID_Person = '@UID_PersonInserted' and uid_department in (select uid_department from department where Shortname like N'2%')
1s - Finds the 1st Level Approver for the Requester from the custom table
select CCC_First_Level_Approver from CCC_Department_Mappying where CCC_UID_SAP_Department in (Select UID_Department from Department where UID_PersonHead in (Select UID_Person from Person wher UID_Person = '@UID_PersonInserted'))
2s - Finds the 2nd Level Approver for the Requester from the custom table
select CCC_Second_Level_Approver from CCC_Department_Mappying where CCC_UID_SAP_Department in (Select UID_Department from Department where UID_PersonHead in (Select UID_Person from Person wher UID_Person = '@UID_PersonInserted'))
Approval Workflow
Will follow this logic
Step 1 - Approval Procedure RT - ( Check Request Type )
Step 2 - Approval Procedure 1s - Retrieve First Level Approver from Custom Table
Step 3 - Approval Procedure 2n - Retrieve Second Level Approver from Custom Table
