Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can you set a default sort order on the Jira Issues macro?

ejanis
Contributor
December 21, 2021

Hi,

I am using the Jira Issues macro on a Confluence page to display some custom fields from the my Epics, along with the assigned Due Date.  My challenge is the when the macro table is displayed, it seems the issues are sorted by newest to oldest by default.  I would like to set the sort order to be oldest to newest on the page (by Due Date).

I can't seem to conclusively determine if this capability exists or not with the macro.

Any help or guidance would be greatly appreciated.

4 answers

1 accepted

1 vote
Answer accepted
Fabian Lim
Community Champion
December 21, 2021

Hi @ejanis

Welcome to the community!

Have you tried setting the order from the jql itself.

Regards

ejanis
Contributor
December 22, 2021

Hi Fabian,

The simplest answer was the best. I was looking at it the wrong way - trying to manipulate the macro.  As suggested above, I looked at the JQL angle.

On my first attempts (when I posted) the JQL I was using was not giving me the desired sort.  Long story short, I corrected my JQL and all is good.  The sort order is correct and the macro in Confluence displays the info in the order I need.

Thanks all for supporting the 'noob'!

- Erik

2 votes
Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 21, 2021

Hi @ejanis ,

If it happens so that you use our app that is Table Filter and Charts for Confluence in your company, then you may also use its Table Filter macro for filtering your Jira Issues as well.

Such dynamic macros are fully supported by our app and you'll be able to use date range filters for your case on the fly from the page view mode. It will simplify your result table.

To set a default sorting of the Jira Issues macro is better with the help of the JQL as was suggested in the previous answer.

1 vote
Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 9, 2022

Hi there,

As this thread mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit modes.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

0 votes
Kristin Lyons
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 22, 2021

You should be able to just click on the Due Date column and it will sort it for you, or as @Fabian Lim said you could update the JQL to sort by due date.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events