How can I sort the board with ascending order of resolution datetime?

Ruslan Usachou January 4, 2018

Please, help me with this 

1 answer

1 vote
Warren
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.
January 4, 2018

If I've understood what you want (and I don't think I have, because I see no reason to do this), you need to add the following to your board query

ORDER BY resolutiondate ASC

BUT ... this doesn't account for all the items that haven't yet been resolved. So you may want to add an additional order criterion e.g.

ORDER BY resolutiondate, key ASC

or replace key with any other field that makes sense to you

Ruslan Usachou January 4, 2018

My situation:

Our delivery man receive salary each day depends on how many delieveries he done. 
So, it is not comfortable to go to the end of the list to calculate this....

I am new in Jira, thank you for your answer!

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 4, 2018

I'm not sure I'd do this with a board, seems like overkill.

A simple filter for "resolved > startofday() and resolved < endofday()" shown in a dashboard gadget would list all resolved (delivered) items.

Ruslan Usachou January 4, 2018

Thank you! Its work! better, than i expected

Suggest an answer

Log in or Sign up to answer