How can i print the entries in a list sorted by priority?

[Annika Wäsch]

How can i print the entries in a list sorted by priority - if i print them as a card, they stay in order, but i want to print them in a list.

[Tim Kopperud]

Hi @Annika Wäsch, welcom to Atlassian Community.

You can use JQL in standard search with ORDER BY like this 

project = ITS order by priority

or this, if you want to revers the order

project = ITS order by priority ASC

Then you can click on Export in the upper right corner and select Print list in the dropdown menu. You will get a print ready list like this example:

Press Ctrl-p on you keyboard to print it:

If you want it accessible from you board

1. create a filter for this.
2. on the left menu in your board view select Add shortcut (red circle in the image below)
3. select Shortcut in the appearing dialog.
4. Give the shortcut a name and for the web address use the link to the filter.

You will now have access to the list in the left menu. 

TimK

[Annika Wäsch]

Hallo Tim, danke für die schnelle Hilfe. Ich habe die Verknüpfung bereits hinzugefügt, aber die Reihenfolge stimmt nicht mit der auf dem KanbanBoard überein. Mit der Verknüpfung kann ich nicht sagen, dass die Aufgabe einen Rand nach unten/oben haben soll - das funktioniert nicht (ich kann darauf klicken, aber es passiert nichts)

[Tim Kopperud]

Hi @Annika Wäsch, I had to run your text to a translation (German to English), so I hope it translated correctly 

Hello Tim, thank you for the quick help. I have already added the link, but the order does not match the one on the KanbanBoard. With the link, I cannot say that the task should have a border down/up - that does not work (I can click on it, but nothing happens)

I'm not fully sure what problem occured here. Is it the shortcut you created that doesn't work? 

Let's focus on the order first. The JQL I sent will correctly order by Priority, but your filter linked to your board might not have order by priority included. This can be because you use ORDER BY RANK in the filter which is recommended. If you are able to drag&drop board elements vertically such ranking is activated. If so you can try this instead to include ranking.

project = ITS order by rank, priority

Check your filter connected to your board and use the same ORDER BY in the filter you use for your shortcut, but add ",priority" at the end. 

TimK.

[Annika Wäsch]

Hi Tim, I'll try to say again briefly what the problem is. On the board, I can see the issues, but then when I want to print the list, the order of the tickets is different.
First Picture ist from the Board/ seceond from the print list

At the print list should be at first GHHAUS-842 and then GGHAUS-804 but it isn´t

[Tim Kopperud]

Hi @Annika Wäsch, yes this can occure if the order used in Board Filter differ from the order used for List filter. E.g. Rank is involved. 

Are you able to attach the JQL used for both the Board and the List in a new comment? It will be helfull to investigate why the result differs. 

TimK

[Annika Wäsch]

Hallo @Tim Kopperud, vielleicht kannst du mich anleiten, dann werde ich es sicher finden ;-)

[Tim Kopperud]

Google translate: Maybe you can guide me then I'll find it for sure

Hi @Annika Wäsch, in your board click on the ellipsis menu in the upper right corner and select Configure board

Settings for the board will be displayed: 

Under General (blue circle) you will find that under Ranking (red cicle) a text indicates if the bord uses ranking or not. 

Select Edit filter Query (green circle) and

1. copy the JQL and send it back to me as a comment here.
2. send the JQL for your filter used for print in the same comment. . 

Tips: If the filters (JQL 1 and 2 above) are identical in issues returned you might first try using the board filter as your filter for print. Check if that show correct order.

TimK.

[Annika Wäsch]

Great, i got it. 
Thank you for your help :-)

[Annika Wäsch]

Hello @Tim Kopperud , 
can you tell me if I can also show the column "Comment" in the list view? Unfortunately, I can't find the column with "Comment"

Greetings Annika

[Tim Kopperud]

Hi @Annika Wäsch, columns relates to Jira fields. Comments are not fields though, so I don't think you are able to display those for each record in a list. 

To solve this I think you will need to add a custom field, e.g., named "Last comment", and have a script engine (Power Script or Scriptrunner) to populate that field every time a comment is added on an issue. 

I have done something similar earlier using Power Script for a custom field name "Last commented by" where the script engine updated "Last commented by" for every comment added on an issue. The purpose was to use it on a board card, so we could on the sprint board see who had the last comment, and if another person than the assignee had commented a color was set on the card. 

But this setup needs to be regarded as advanced though.

TimK.