Service request approvers

Service request approvers

 This report helps to find the who all the service request approvers in the application. 

SELECT aaauser.first_name "Approver Name",
       dpt.deptname "Department",
       sdo.name "Site",
       sd.jobtitle "Job Title" FROM srapproverdetails
LEFT JOIN aaauser ON aaauser.user_id = srapproverdetails.approver
LEFT JOIN aaacontactinfo ON aaauser.user_id = aaacontactinfo.contactinfo_id
LEFT JOIN sduser sd ON aaauser.user_id=sd.userid
LEFT JOIN userdepartment ud ON aaauser.user_id=ud.userid
LEFT JOIN DepartmentDefinition dpt ON ud.DEPTID=dpt.DEPTID
LEFT JOIN SDOrganization sdo ON dpt.SITEID=sdo.ORG_ID
WHERE sd.status='Active';







          • Related Articles

          • How to create service requests through email using Business Rule

            This post describes the use of a python script to create a service request through email based on keywords in the subject. When a request is created with specific keywords in the subject of a incoming mail , the Business Rule will be invoked. The ...
          • How to create service requests through email

            This post describes the use of a python script to create a service request through email , based on keywords in the subject.When a request is created with specific keywords in the subject of a incoming mail , the custom trigger will be invoked.The ...
          • Set Backup Approvers using Request

            This is a sample script that triggers BackUp Approver API, using request information.  Use Case:  Different users are provided for each role in many organisations.  ...
          • Automatically close request after successive approval reminders.

            This post describes the use of a python script to close requests after successive approval reminders using Custom Schedules. Use Case: We have an option under the self-service portal in order to send reminders mail for the approvals, what would be ...
          • How to update a request based on certain field values.

            This post describes the use of a python script to update requests based on values in other fields ,in the same request.This action can be performed using  Custom Triggers. UseCase: There are three Levels setup in the application and there are 2 ...