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

[Lynne Barnard]

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

[Sreenivasaraju P · Accepted solution]

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 

or

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

[Lynne Barnard]

Thank you Sreenivasaraju! 

[Nic Brough _Adaptavist_]

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.

[Lynne Barnard]

Thanks Nic !