Request Management - service template resource questions

Request Management - service template resource questions

Service templates resource questions. This report helps to find the resource questions and values chosen in the request.

SELECT WO_Resources.WOID "RequestID",
       CatalogResource.TITLE "Resource Question",
       Questions.QUESTION "Question",
       ResourcesQAMapping.ANSWER "Answer" FROM WO_Resources
LEFT JOIN ResourcesQAMapping ON WO_Resources.UID=ResourcesQAMapping.MAPPINGID
LEFT JOIN CatalogResource ON wo_resources.RESOURCEID=CatalogResource.UID
LEFT JOIN Questions ON Questions.QUESTIONID=ResourcesQAMapping.QUESTIONID
LEFT JOIN RequestTemplate_List ON CatalogResource.SERVICEID=RequestTemplate_List.TEMPLATEID
LEFT JOIN Workorder wo ON WO_Resources.WOID=wo.WORKORDERID WHERE wo.CREATEDTIME >= <from_thisweek> and wo.CREATEDTIME <= <to_thisweek>

To make any changes to this query, refer to this post.

Click this link to navigate to the next report.‚Äč

      New to ADSelfService Plus?