Approval report
Below is the code from a previous question to this discussion group for an approval report. Works great but I need to know how to limit it by date � this gives everything. Also the approved by column says not assigned for all� how do I get it to pull the name of the approver? Thanks
select wo.WORKORDERID 'Request ID', wo.TITLE 'Title', au.FIRST_NAME 'Requester',dateadd(s,wo.CREATEDTIME/1000,'01-01-1970') 'Request Date', asd.STATUSNAME 'Approval Status', au1.FIRST_NAME 'Approved by' from WorkOrder wo left join WorkOrderStates wos on wo.WORKORDERID=wos.WORKORDERID left join WorkOrder_Threaded wot on wo.WORKORDERID=wot.WORKORDERID left join ApprovalStatusDefinition asd on wos.APPR_STATUSID=asd.STATUSID left join AaaUser au on wo.REQUESTERID=au.USER_ID left join ApprovalStageMapping asm on wo.WORKORDERID=asm.WORKORDERID left join ApprovalDetails ad on asm.APPROVAL_STAGEID=ad.APPROVAL_STAGEID left join SdUser sd on ad.APPROVEDBY=sd.USERID left join AaaUser au1 on sd.USERID=au1.USER_ID where wot.WORKORDERID=wot.THD_WOID and (asd.STATUSNAME='Approved' or asd.STATUSNAME='Denied')
select wo.WORKORDERID 'Request ID', wo.TITLE 'Title', au.FIRST_NAME 'Requester',dateadd(s,wo.CREATEDTIME/1000,'01-01-1970') 'Request Date', asd.STATUSNAME 'Approval Status', au1.FIRST_NAME 'Approved by' from WorkOrder wo left join WorkOrderStates wos on wo.WORKORDERID=wos.WORKORDERID left join WorkOrder_Threaded wot on wo.WORKORDERID=wot.WORKORDERID left join ApprovalStatusDefinition asd on wos.APPR_STATUSID=asd.STATUSID left join AaaUser au on wo.REQUESTERID=au.USER_ID left join ApprovalStageMapping asm on wo.WORKORDERID=asm.WORKORDERID left join ApprovalDetails ad on asm.APPROVAL_STAGEID=ad.APPROVAL_STAGEID left join SdUser sd on ad.APPROVEDBY=sd.USERID left join AaaUser au1 on sd.USERID=au1.USER_ID where wot.WORKORDERID=wot.THD_WOID and (asd.STATUSNAME='Approved' or asd.STATUSNAME='Denied')