Change approval

Change approval

SELECT chdt.changeid                           AS "Change ID", 
       chdt.title                              AS "Title", 
       orgaaa.first_name                       AS "Change Requester", 
       qd.queuename                            AS "Group", 
       ownaaa.first_name                       AS "Change Owner", 
       catadef.categoryname                    AS "Category", 
       priodef1.priorityname                   AS "Priority", 
       Longtodate(chdt.createdtime)            AS "Created Time", 
       Longtodate(chdt.completedtime)          AS "Completed Time", 
       statusDef.statusdisplayname             "Status", 
       stageDef.displayname                    "Stage", 
       approvaldef.statusname                  "Approval Status", 
       aaa.first_name                          "Change Approved by", 
       Longtodate(approvaldetails.action_date) "Change Approved On",                   "Approver Email", 
       Longtodate(approvalstage.sent_date)     "Approval Sent date", 
       approvaldetails.comments                "Comments" FROM   changedetails chdt 
       LEFT JOIN sduser orgsd 
              ON chdt.initiatorid = orgsd.userid 
       LEFT JOIN aaauser orgaaa 
              ON orgsd.userid = orgaaa.user_id 
       LEFT JOIN sduser ownsd 
              ON chdt.technicianid = ownsd.userid 
       LEFT JOIN aaauser ownaaa 
              ON ownsd.userid = ownaaa.user_id 
       LEFT JOIN prioritydefinition priodef1 
              ON chdt.priorityid = priodef1.priorityid 
       LEFT JOIN categorydefinition catadef 
              ON chdt.categoryid = catadef.categoryid 
       LEFT JOIN queuedefinition qd 
              ON chdt.groupid = qd.queueid 
       LEFT JOIN change_statusdefinition statusDef 
              ON chdt.wfstatusid = statusDef.wfstatusid 
       LEFT JOIN change_stagedefinition stageDef 
              ON chdt.wfstageid = stageDef.wfstageid 
       LEFT JOIN approvalstatusdefinition approvaldef 
              ON chdt.appr_statusid = approvaldef.statusid 
       LEFT JOIN apprstagetochange 
              ON chdt.changeid = apprstagetochange.changeid 
       LEFT JOIN approvaldetails 
              ON apprstagetochange.approval_stageid = 
       LEFT JOIN approvalhistory aph 
              ON approvaldetails.approvalid = aph.approvalid 
       JOIN sduser sd 
         ON approvaldetails.approverid = sd.userid 
       LEFT JOIN aaauser aaa 
              ON sd.userid = aaa.user_id 
       LEFT JOIN approvalstage 
              ON approvaldetails.approval_stageid = 

          • Related Articles

          • Request Approval Details

            This report is used to view the historical details of Approved and Denied approval processes and their individual steps.We can also use this report to display all details for which an approval decision is pending.   To make any changes to a query, ...
          • Change details

            SELECT    chdt.changeid "Change ID",            chdt.title "Title",            Longtodate(chdt.createdtime) "Created Time",            Longtodate(chdt.scheduledstarttime) "Scheduled Start Time",  ...
          • How to assign CAB members to a change request automatically.

            This is a sample script to add CAB Members to a Change Request through Change Custom Triggers.The CAB Members can only be added manually to the Change Request ,under the Approval Tab, after it has been created.By using this script we will be able to ...
          • Report on requests pending approval

            DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",wo.TITLE "Subject",ti.FIRST_NAME "Technician", std.STATUSNAME "Request Status", ...
          • How to implement dynamic request approval through custom triggers with configurable CSV file.

            This is a sample script written in Python to handle Conditional Approvals for Incident \ Service Requests, through Custom Triggers.More information about Conditional Approvals can be  found in the link here One of the advantages of using this script ...