Can we have multiple ORDER BY in the same jql? Can we apply multiple ORDERING in the same jql?

Question

Can i write a jql as following : assignee = currentUser() ORDER BY createdDate , / AND ORDER BY "Time to resolution"?

Ste Wright · Answer

Hi @Hussein Dbouk

Sure, this is possible.

Just remember though that with created date, it orders by both date AND time - because that is its field type.

If you want to order by only date, then you'd need to...

* Create a Date Picker custom field - eg. Created - Date Only
* Automate the population of this field at creation

...then use this in JQL instead.

Ste

Matt Doar_tzgiej · Answer

Run an advanced search and click on a few columns at the top. The JQL will show how to do this