A solution to delete inactive workflow from the draft workflow scheme
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
It is only possible to delete workflows that are inactive and don't have any (draft) workflow scheme associated with them, or else, you will see the following message: "To delete a workflow, you must first unassign it from all workflow schemes and draft workflow schemes."
However, it is not always clear which schemes are associated with the workflow you want to delete, especially if it is in the draft state, and you don't know where to look it up (the Assigned Schemes column shows empty).
Solution
Go to Administration > Issues > Workflows
Get the name of the workflow you want to delete.
Run the following query to identify the draft Workflow Scheme ID:
Draft Workflow Scheme ID
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15``` Postgres SELECT wfse.workflow , wfse.issuetype , wfs.id , wfs.workflow_scheme_id , wfs."name" as scheme_name FROM draftworkflowschemeentity wfse left join draftworkflowscheme wfs on wfs.id = wfse.scheme WHERE wfse.workflow = '<workflow name from previous step>' ``` ``` SQL Server SELECT wfse.workflow, wfse.issuetype, wfs.id, wfs.workflow_scheme_id, wfs.[name] AS scheme_name FROM draftworkflowschemeentity AS wfse LEFT JOIN draftworkflowscheme AS wfs ON wfs.id = wfse.scheme WHERE wfse.workflow = '<workflow name from previous step>' ``` ``` MySQL SELECT wfse.workflow, wfse.issuetype, wfs.id, wfs.workflow_scheme_id, wfs.`name` AS scheme_name FROM draftworkflowschemeentity AS wfse LEFT JOIN draftworkflowscheme AS wfs ON wfs.id = wfse.scheme WHERE wfse.workflow = '<workflow name from previous step>' ```Observe the column <wfs.workflow_scheme_id>, copy that value, paste and enter this URL on the browser to access the Draft Workflow Scheme directly: <BASE_URL>secure/admin/EditWorkflowScheme.jspa?schemeId=<wfs.workflow_scheme_id>
After accessing the Draft Page, simply discard it.
Go back to Administration > Issues > Workflows and notice that you are now able to delete the workflow.
Was this helpful?