Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

1 answer

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

Thank you Hannes!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Community Events

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

Events near you