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?