Skip to main content

Number of times 'Downloads' have been downloaded in the user portal - Developer & Reporting / DPQL Examples - Deskpro Support

Number of times 'Downloads' have been downloaded in the user portal

Authors list

Question

 

I would like to know if there is a way to track how many times files are downloaded from our support portal?

 

Answer

 

You can build a custom report to get this information: Reports > Stat Builder > Add. Enter a title and description for your report and the following query:


SELECT downloads.id, downloads.date_created, downloads.title, downloads.num_downloads

FROM downloads

ORDER BY downloads.num_downloads

 

 

You can also add downloads.num_ratings to the SELECT line if you want to see number of ratings per download too.

 

There is a full list of download schema here.

Βοηθητικό Δεν βοηθάει

9 από 16 χρήστες πιστεύουν ότι αυτή η σελίδα βοηθάει

Προσθήκη σχολίου

Please log in or register to submit a comment.

Ξεχάσατε τον κωδικό πρόσβασης;