Delete a template
This section provides information on how to delete a template.
Templates, as a Jira issues, can be removed from Jira permanently. It is impossible to restore template.
We don’t recommend deleting templates. You can easily disable them in the Availability tab for a later use (read more here). However, deleting template won’t affect on issues created from template.
- Navigate to the particular template issue (in the templates repository TEMP) you would like to delete.
- Click More > Delete.
- Click Delete in pop-up window to confirm.
The template is deleted from Jira instance permanently.
This action also removes template’s data from the following database tables:
You can use selects to check whether the data are removed from database:
select * from “AO_33A75D_IT_CONTEXT” where “TEMPLATE_DETAIL_ID”=52
select * from “AO_33A75D_IT_CREATED” where “TEMPLATE_DETAIL_ID”=52
select * from “AO_33A75D_IT_DEFAULT” where “TEMPLATE_ID”=52
select * from “AO_33A75D_IT_DETAIL” where “ID”=52
You can find Template’s ID in Issue Templates section in the target template. Click here for more information.
select * from “AO_33A75D_IT_SUBTASK” where “SUBTASK” in (12522, 12523)
select * from “AO_33A75D_IT_CREATED” where “SUBTASK_ID” in (select “ID” from “AO_33A75D_IT_SUBTASK” where “SUBTASK” in (12522, 12523))
To find sub-tasks ID, you can hover on the Edit tab in the target sub-task. An ID number is visible in the URL.