SQL Query to retrieve all Inactive workflow schemes Inactive workflows

Chander Inguva
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 3, 2016

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

0 votes
Casper Hjorth Christensen February 25, 2020

Hi @Chander Inguva 

Did you ever find an appropriate SQL solution?

0 votes
Bob Swift (personal)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 3, 2016

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