Ability to view each ticket that used a particular snippet in "snippet reporting" - Community / Feature Request - Deskpro Support

New Feature Request

19

Ability to view each ticket that used a particular snippet in "snippet reporting" Finished

Jason

Would it be possible to add links to the snippet reporting feature so we can easily see the tickets where the snippets were used?

Comment (1)

Lauren Cumming

8 ár síðan

The following report should allow you to do this :) DISPLAY TABLE SELECT OBJ_LANG(ticket_object_use_logs.snippet.category.id, 'text_snippet_categories') AS 'Snippet Category', OBJ_LANG(ticket_object_use_logs.snippet.id, 'text_snippets') AS 'Snippet', COUNT() AS 'Uses' FROM ticket_object_use_logs WHERE ticket_object_use_logs.snippet.id <> NULL AND ticket_object_use_logs.date_created = %1:DATE_GROUP% SPLIT BY ticket_object_use_logs.snippet.id GROUP BY ticket_object_use_logs.ticket.id ORDER BY COUNT() DESC

New Feature Request

Author: Jason
Last update: 29. nóv. 2018

Ability to view each ticket that used a particular snippet in "snippet reporting" - Community / Feature Request - Deskpro Support

Ability to view each ticket that used a particular snippet in "snippet reporting" Finished

Comment (1)

Labels