Automation of Filter Updates

[Ross Musselman]

Using Jira Cloud, we have created a project that holds our company-wide weekly sprints and adapted the board's filter accordingly. In order to drive accountability and reporting, we have created filters that tell us which tasks each team has assigned to them for the sprint. Each week I therefore need to go through a routine that:

1. Starts the new sprint.

2. Updates all the filters to use the new sprint. 

I'm looking for a way to create a script that would run weekly that would do these tasks. Does anyone have a resource or tutorial for how to accomplish this automation? 

[Bill Sheboy]

Hi @Ross Musselman 

I just saw your posting while searching for something, and I wondered if you solved this one yet.

If not, have you taken a look at automation for Jira rules?  You should be able to do both things with automation rules.

Kind regard,
Bill

[Ross Musselman]

Thanks for the reply, @Bill Sheboy . No one has solved this one as far as I know. 

1. It's not clear how to close a sprint and open the next sprint through automation for Jira rules. 

2. It's also not clear how I could update a filter that specifies the previous sprint id value. 

If you have resources that would point out how to do that, I'm happy to have a look at them. 

Kind regards,

Ross

[Bill Sheboy]

Hi Ross,

Sorry...my mistake: I thought I had used the REST API before to close/create sprints, and it appears to be possible only for server.  Here is the suggestion to add to the methods for Cloud's REST API: https://jira.atlassian.com/browse/JSWCLOUD-18874

If you instead create your new sprint manually and then manually stop the current one, the rule could trigger on Sprint Completed, and then...

The key is how your sprints are identified for a project.  For example to get all the sprints for a project:

/rest/greenhopper/latest/integration/teamcalendars/sprint/list?jql=project=myProject

You could then identify the sprints needed by parsing the results to get their ID values.

Then call the update filter method from the same rule to alter its JQL:

https://docs.atlassian.com/software/jira/docs/api/REST/1000.824.0/#api/2/filter-editFilter

Here is an article with an example of calling the REST API from a webrequest using automation: 

https://community.atlassian.com/t5/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828

Once again, sorry for the bad information.

Kind regards,
Bill