Hello, We have a department that we bill them for the time our service desk spends on their request. I have created a field fro department and even created a queue that shows closed request for that department as well as the time spent per request. How can I export that Data? I'm basically looking to be able to print out the Request number, the subject, the status and the time spent for all request for a department for the previous month.
Use the PDF View Plugin to generate a printable document from the issues in a JIRA Service Desk queue.
You can generate a simple document with those 4 columns you mentioned or create a custom template with branding, charts, etc. for custom requirements (samples).
Tutorial: https://www.youtube.com/watch?v=-wO1FQ1NPbA
Discl: I am developer of this app.
Hello,
You should copy the JQL query used in the queue (go to Edit queue and then choose advanced). Then go to Issue navigator (issues->search) and paste the copied JQL query. If you need to filter queries only for the previous month then you should add to your JQL query the following conditions:
AND created > startOfMonth(-1) and created < endOfMonth(-1)
Add to the issue navigator necessary fields for export (logged work is called timespent). You can read more here how to add fields in the issue navigator:
Then you can export the data returned by JQL query by going to Export. You can read more about exporting in the issue navigator here:
https://confluence.atlassian.com/jiracoreserver073/working-with-search-results-861257284.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.