Query to list Service Request Approver and Purchase Request Approver

Query to list Service Request Approver and Purchase Request Approver

Postgres & SQL

Select aau.first_name "Name", po.approverstatus "Purchase Request Approver", sr.approverstatus "Service Request Approver", adef.org_name "Account" from aaauser aau
left join POApproverDetails po on po.approver=aau.user_id
left join SRApproverDetails sr on sr.APPROVER=aau.USER_ID
left join sduser su on su.userid=aau.user_id
left join accountdefinition adef on adef.pocid=su.userid where sr.APPROVERSTATUS='True' or po.APPROVERSTATUS='True' Order by 4
          • Related Articles

          • Query to list the pending approvals of a Service Approver

            PGSQL & MSSQL: SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",wo.TITLE "Subject",ti.FIRST_NAME "Technician", longtodate(wo.CREATEDTIME) "Created Time",appsau.first_name "Approver", asd.statusname "Approval Status" FROM ...
          • Query that lists pending approval of a particular service approver:

            PGSQL: SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",wo.TITLE "Subject",ti.FIRST_NAME "Technician", longtodate(wo.CREATEDTIME) "Created Time",appsau.first_name "Approver", asd.statusname "Approval Status" FROM WorkOrder_Threaded wot ...
          • Query to show requesters who are service and PO approvers

            PGSQL & MSSQL: select ad.org_name "Account Name", sdo.name "Site Name", au.first_name "First Name", aci.emailid "Email ID",aci.landline "Telephone", aci.mobile "Mobile",po.approverstatus "Purchase Request Approver", sr.approverstatus "Service Request ...
          • Query to list fields used in each request template.

            Go to Reports-New Query Report and execute this query. POSTGRES select sd.name "Service Catalog Name",rt.templatename "Template name",fc.field_name "Fields" from requesttemplate_list rt left join servicedefinition sd on sd.serviceid = ...
          • Query to show Approved tickets per Approver

            PGSQL & MSSQL: SELECT wo.WORKORDERID "Request ID", wo.TITLE "Subject", std.STATUSNAME "Request Status", ti.FIRST_NAME "Technician", longtodate(wo.CREATEDTIME) "Created Time", ApprovalDetails.EMAIL "Approver Email", asd.stagename "Stage", ...