Given a records set of some JQL query which includes status column, is there a way I can put some of the status values first (or last) in the results?
For example, for the following query:
=JIRA("project = proj AND assignee = 'My name' ", "reporter, status", 0, 20)
I'd like to have the results with, for example, Done, Duplicate and Obsolete statuses at the bottom of the results.
I can't see how order by helps me here...
I don't think you can define the order of individual statuses in JQL - but depending on your use case, you could try ordering by Status Category. E.g. I would assume that Done, Duplicate and Obsolete would all fall under the "Done" status category?
(Just as a side note, you may want to have a look at JXL for Jira. It's a Google-Sheets-like view for your issues - directly within Jira - where you can perform all kinds of sorting and filtering operations directly on the respective fields/columns, without having to alter the JQL statement. Depending on your usecase, this may be helpful. More info @ https://jxl.app. Disclaimer: I work on JXL :))
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events