Ability to view each ticket that used a particular snippet in "snippet reporting" - Spätná väzba / Feature Request - Deskpro Support
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
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