SQL Query to retrieve all Inactive workflow schemes Inactive workflows

Question

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

Casper Hjorth Christensen · Answer

Hi @Chander Inguva

Did you ever find an appropriate SQL solution?

Bob Swift · Answer

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