How to save and track time in Jira Software? Watch our joint webinar with Tempo!

Issue Templates for Jira

Jira Server
HOSTING
Last updated Oct 26, 2018

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.

Note

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.

Steps

  1. Navigate to the particular template issue (in the templates repository TEMP) you would like to delete.
  2. Click More > Delete.
  3. Click Delete in pop-up window to confirm.

Result
The template is deleted from Jira instance permanently.

Info

This action also removes template’s data from the following database tables:

For template
AO_33A75D_IT_CONTEXT
AO_33A75D_IT_CREATED
AO_33A75D_IT_DEFAULT
AO_33A75D_IT_DETAIL
For sub-tasks
AO_33A75D_IT_SUBTASK
AO_33A75D_IT_CREATED

You can use selects to check whether the data are removed from database:

FOR TEMPALTE

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.

FOR SUBTASK

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.