Service request approvers
This report helps to find the who all the service request approvers in the application.
SELECT aaauser.first_name "Approver Name",
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
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 ...