How do I bulk change on a set of Epics Workflow Status?

[Ryan Keels]

I have a bunch of Epics that were migrated from one project to another. 

They still retain their previous workflow designation, AKA scoped/backlog/etc. 

For this new project I would like to bulk roll them back to a status of 'New'

When I try to do this the bulk change interface only allows me to push them forward. 

Can anymore help me easily do this bulk change?

[Alexey Matveev · Accepted solution]

Hello,

You can find an answer here:

https://community.atlassian.com/t5/Questions/sql-query-to-get-all-board-id-s-srum-kanban-which-are-associated/qaq-p/226611

Bascally this information is stored in AO_XXXXXX_RAPIDVIEW. The XXXXXX part is different for all Jira instances. You can open your database and find a table with AO and RAPIDVIEW.

[Deleted user]

thanks.

[Deleted user]

so this command should count the number of rows (boards) in the table?

mysql> select count(*) from AO_XXXXXX_RAPIDVIEW

[Alexey Matveev]

Yes, but you should change XXXXXX to the numbers in your Jira instance

[Sean Binny]

A count of the below table should give you the list of Agile boards 

AO_60DB71_RAPIDVIEW 

 Sean Binny

Product Manager

At a Glance Jira Plugin