Skip to main content

Please add the ability to list specific products in the selection criteria - Feature Request - Deskpro Support

18

Please add the ability to list specific products in the selection criteria Collecting Feedback

I would like to be able to pull a report on specific products by date so I can see if my ticket requests are increasing or declining for a product over time.

Comment (1)

Ben Henley
Although having a dynamic replacement pull-down for products is not supported currently, a workaround to get this information is to make a custom report that filters one particular product e.g.:

DISPLAY TABLE
SELECT tickets.id, tickets.subject, tickets.date_created
FROM tickets
WHERE tickets.product_id = 1 AND tickets.date_created = %1:DATE_GROUP%

And then make a different report for each product you're interested in, with "WHERE tickets.product_id =" 2, 3, 4 etc.

To find out which ID number relates to which product, go to Admin > Tickets > Fields and use the small gear pull-down.

Add a comment

Please log in or register to submit a comment.

Need a password reminder?