Can I export a Queue view

[David Stuart]

Wondering if there is a way to export the content (results) of a queue so that I can analyse our open tickets.

Not able to find a tabular report that will accomplish this.

TIA

[Jack Brickey · Accepted solution]

sort of. edit the queue and go to the advanced view of filter. Copy it, paste it into the search for issues screen then export

[David Stuart]

Perfect.  A couple of extra steps but gets me exactly what I need.

Thank you!

[Elizabeth Pavacic]

this is a great workaround!! Thanks so much!

[ktran]

I tried to follow the instruction but got lost. 

I clicked on edit, then click on "Switch to JQL" .  Is this what you mean by advance view of filter?  I don't see any other button to click on.

I copy the string then go to search for issue screen and paste the string.  It came back with can't find error.

Can you clarify the instruction?

[Jack Brickey]

1. click on Queues
2. select the queue you want
3. click on ellipses and select edit queue
4. select the JQL text in the "filter by" field and copy it
5. exit out or simply click on the magnifying glass
6. select advanced search
7. if necessary click on switch to JQL
8. paste in the copied text and hit return

if you are having an issue please post your JQL text string here.

[ktran]

Thanks Jack.  I found another post which provide more insights and was able to figure it out. 

https://community.atlassian.com/t5/Jira-Service-Desk-questions/Exporting-from-JIRA-Help-Service-Desk-to-Excel/qaq-p/972445

While I was typing this, I saw your reply.  Below is how I end up have to do to get some sort of export for Jira Service Desk:

1. click on Queues
2. select the queue you want
3. click on ellipses and select edit queue.  I also click on Switch to JQL and found this:I have to exit out this queue and then go back to the queue to get the below string
4. I copied the string then go to Issue Search to paste the string.

5.  After I hit search, I got the list with what I want at the top of the search results.  I export the table and deleted what I don't need.

[Jim]

This resolution is almost adequate.

Unfortunately our clients require us by contract to know which of their employees that reported the issues and the reporter field is mostly replaced by scrambled "qm:"-codes instead of names or e-mails (that for some reason also appears occasionally).

I suppose this might be an adaptation to GDPR os something.
But what is the "reporter"-field actually reporting? The clients self-submitted name or the scrambled "qm:"-placeholder if the reporter has not registered fully?

For us, the reporters e-mail would be preferable as a column as we can use it to sort issues by their e-mail domains.

Also, when we want to export complete reports over how many cases are submitted by client, the Organisation-field is reported by a numeral ID. Identifying the client organisations manually is not practical.

[Aron Gombas _Midori_ · Accepted solution]

You can get the Excel export directly from a queue using the Better Excel Plugin:

Tutorial: https://www.youtube.com/watch?v=QOAWs2IpnDg

(There are no extra steps involved.)

[David Stuart]

That looks interesting.  I'll give it a try.

Thank you

[Dean Holmes]

What about service desk cloud instance. I want to be able to export the qeuues

[Aron Gombas _Midori_]

Dean, Better Excel Plugin is not available for the cloud yet, unfortunately, but this will change in the future.

Please vote to this feature request and add the details of your use case so that we can include that in our product planning.