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

JQL searchers

This section provides information on using JQL searchers provided by Issue Templates for Jira app.

Issue Templates for Jira app adds three JQL functions described below. There can be used in any place in Jira where using JQL is available: in the Issue Navigator, in a Saved Filter, as an Agile Board query, etc.

createdFromTemplate

createdFromTemplate JQL function lets you search issues created from the particular template.

To specify a searching condition in JQL, use the following format:

issue in createdFromTemplate("template_issueKey")

Function argument Description
template_issueKey The issue key of template.

Example:

To find issues created from template TEMP-15: createdFromTemplate("TEMP-15")

Note

You can also check which issues are created from template by clicking on the number next to Used in in Issue Templates section in concrete template. Page with JQL search opens.

searchTemplates

searchTemplates JQL function lets you search templates follow defined conditions.

To specify a searching condition in JQL, use the following format:

issue in searchTemplates("argument", "value")

Function argument Value Description
category
templateName
Values specified for the argument. The configuration defined in the General tab.
autocompleteScopeName
autocompleteScopeField
autocompleteScopeId
copyScopeName
copyScopeField
copyScopeId
Values specified for the argument. The configuration defined in the Set of fields tab.
enabled
disabled
True / Yes /1 or False / No / 0. The configuration defined in the Availability tab.
projectAvailability
projectCategoryAvailability
issueTypeAvailability
screenAvailability
groupAvailability
userAvailability
languageAvailability
Values specified for the argument. The configuration defined in the Availability tab.

Examples:

  • To find templates which are from category named Human Resources:
    searchTemplates("category","Human Resources")
  • To find templates which use a scope named Onboarding for autocomplete:
    searchTemplates("autocompleteScopeName","Onboarding")
  • To find templates which use a scope which contains Priority field for copy:
    searchTemplates("copyScopeField","priority")
  • To find templates which are enabled:
    searchTemplates("enabled","true") or searchTemplates("enabled","yes") or searchTemplates("enabled","1") or searchTemplates("disabled","false") or searchTemplates("disabled","no") or searchTemplates("disabled","0")
  • To find templates available for project Developers (DEV):
    searchTemplates("projectAvailability","DEV")
    Warning

    To use searchTemplates for projectAvailability, the value must be equal to the project key. This JQL doesn’t support a project name.

  • To find templates available for Bug issue type:
    searchTemplates("issueTypeAvailability","Bug")
  • To find templates available for users who use Spanish language:
    searchTemplates("languageAvailability","Spanish") or searchTemplates("languageAvailability","ES")
Note

To use autocompleteScopeId and copyScopeId, you have to provide a scope ID. You can find it in the ID column in the database table: AO_33A75D_IT_PROFILE.

templateForIssue

templateForIssue JQL function lets you search template which has been used to create issue.

To specify a searching condition in JQL, use the following format:

issue in templateForIssue("issueKey")

Function argument Description
issueKey The issue key of issue created from template.

Example:

To find template used to create issue DEV-372: templateForIssue("DEV-372")

Warning

This JQL function doesn’t support sub-tasks created from template using Issue Templates older than version 7.4.0, because we didn’t collect specified data. Search results can be empty.

Info

For more information about JQL searching, see official Atlassian documentation on Advanced Searching and Advanced Searching Functions.

Need help?

If you can’t find the answer you need in our documentation, raise a support request*.

*Include as much information as possible to help our support team resolve your issue faster.