JQL query to reorder Jira cards in a dynamic table

Hi ​@Simson,

Thank you for posting in the Lucid Community!

The most efficient way to organize your dynamic table by using Jira fields is to Set your rows and columns. (see screenshots below)

Please view this Gif below for a brief tutorial. 

This help center article is very helpful when formatting your Dynamic table. Please let me know if you have any additional questions!

Hey ​@alison cheney,

thanks for your input. This is what I acutally already do. But is there any way to get a specific order of the rows besides using manual drag&drop? In your example I’d like to add “ORDER BY PRIORITY ASC” to my JQL query and want to see the rows in this order - but in fact it does not change anything. And also in the row settings of the dynamic table I can only see an option for filtering but not ordering/sorting.

Or did I miss anything obvious?

Hi ​@Simson,

Thanks for your response! 

I’ve reached out to our internal Jira Cards team to confirm the use of the “ORDER BY” clause in the JQL query to reorder cards in a dynamic table. I will update you in this thread as soon as I hear back from them. 

Thanks in advance for your help and patience!

Hey ​@alison cheney,

thanks for your effort - looking forward to any update 😀

I want to underline the need of this feature. For me, sorting a table by specific attributes like rank or other jira fields is essentiell. 

We use the dynamic table function to organize our backlog meetings. In jira we use the jira fild priority to sort our backlog. Also we use in our discovery process a custome jira field “score” to sort the most important ideas which are coming up. So it would be very helpful to have this feature.