JIRA on Google spreadsheet: How to put certain statuses on top (or bottom) of the results table?

[tal-yechye]

Hello guys,

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...

Thanks

[Hannes Obweger - JXL for Jira]

Hi @tal-yechye

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 :))

Best,

Hannes

[tal-yechye]

Thank you Hannes!