Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

can someone explain this query: status in (Resolved, Complete, Done, Closed) AND Sprint in (553, 557

I am taking over the reporting for someone who left, the only instructions I received was to use this filter (status in (Resolved, Complete, Done, Closed) AND Sprint in (553, 557, 551, 566) ORDER BY cf[12303] DESC, cf[12304] DESC, cf[10004] DESC, key ASC) and change the Sprint names at the end of the sprint cycle -- however I don't understand the query to 'change the sprint names' there are only numbers, and I don't know where those numbers can be found ex:  ..."Sprint in (553, 557, 551, 556)'...

2 answers

1 accepted

2 votes
Answer accepted

Hi @Lynne Barnard , 

Welcome to the community. 


On the backlog , you can see the 3 dots on the right hand side of the sprint. 

Put cursor on the 3 dots, you can see the URL at bottom of page, with sprint id at the last 


you can right click on 3 dots, and copy the link address. Please paste this link address on notepad, you can see the sprint id at the last.


Ex :<your base url>/rest/greenhopper/1.0/xboard/plan/sprints/actions?sprintId=1

Thank you Sreenivasaraju! 

0 votes

Welcome to the Atlassian Community!

The sprint names are a string, but your people have chosen to use simple numbers for them.  It's a bad practice to rename sprints, they should really be sticking to a single name with some obvious sequence in them.

If you're going to change the sprint names, then there's no "query" for that, you have to manually edit them.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

250 views 1 9
Read article

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