I want to be able to create a query to pull incidents through for where they have been raised against a specific category (which goes down to levels 3 and 4), and on the query results view, also show the category levels (i.e. IT Request - Software - Microsoft Office).
I have set up a query, which is currently based on incident, and on the criteria have set category to 'is equal to' and prompt analyst for value. However, when you run the query and select the category (i.e. IT Request - Software - Microsoft Office) it is ignoring the criteria and pulling through all incidents.
Can anyone give me any recommendations on how I can achieve this???