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
4,364,440
Community Members
 
Community Events
168
Community Groups

SQL Query to retrieve all Inactive workflow schemes Inactive workflows

Hi All,

           As a part of clean up process, I was looking at deleting Inactive workflow Schemes and Inactive Workflows.

I know that we can delete it from UI, but it takes longer time. I wonder which table will have this information.

 

Tried looking into these tables

 

dbo.workflowschementity
dbo.workflowscheme
dbo.nodeasscociation
dbo.jiraworkflows
dbo.jiradraftworkflows
dbo.draftworkflowschementity
dbo.draftwokflowscheme

 

Please help me with SQL Query which saves a lot of time.

 

Thank You

Chander

2 answers

Hi @Chander Inguva 

Did you ever find an appropriate SQL solution?

Consider using deleteWorkflow and deleteWorkflowScheme from JIRA CLI. It would be safer than doing database operations.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events