I am not SQL savvy and need help with a query. I'd like to generate a weekly report categorized and sorted alphabetically by help topic that contains the following:
1. All tickets for the week.
2. Subject.
3. Date ticket was created.
4. Status of ticket (open/closed/overdue).
5. All text input/updates/discussion for the ticket.
I'm trying to get the result to look like this:
Help Topic
SubjectDateStatusComplete text input of the ticket to include inital request and all followup.
Next Subject for the topic...
Help Topic
...
Help Topic
...
Suggestions?
Thanks.
