Apps documentation
TestFLO - Test Management for Jira
TestFLO - Test Management for Jira
8.4.x
8.2.x
8.1.x
8.0.x
FAQ
Release notes
Last updated Sep 15, 2020

JQL functions

This page provides information on how to serach test data with extended JQL functions.

The standard JQL may be insufficient, which is why dedicated JQL functions have been created. You will be able to quickly search and obtain important to analyze test data.

requirementsFromTCInTP()

Returns a list of unique issues set in Requirement field on Test Cases for a given Test Plan(s).

JQL function requirementsFromTCInTP("")
arguments a1= Test Plan Issue Key
a2= Test Plan Issue Key
...
an= Test Plan Issue Key
sample query issuekey in requirementsFromTCInTP("TP-68","TP-89","TP-166")

steps

Returns a list of Test Case Template(s) and Test Case(s), where the Steps custom field contain the given word from the query.

JQL function steps
arguments a1= word to search
sample query steps ~ test

templateInPlan()

Returns a list of Test Plan(s) in which certain Test Case Template(s) were used to create Test Case(s) for this Test Plan.

JQL function templateInPlan("","")
arguments a1= ID of TC Template custom field
b1= Test Case Template Issue Key
b2= Test Case Template Issue Key
...
bn= Test Case Template Issue Key
sample query issuekey in templateInPlan("customfield_10005","TCT-1","TCT-2","TCT-3")

templatesFromPlan()

Returns a list of Test Case Template(s) which were used to create Test Case(s) in a given Test Plan.

JQL function templatesFromPlan("")
arguments a1= Test Plan Issue Key
a2= Test Plan Issue Key
...
an= Test Plan Issue Key
sample query issuekey in templatesFromPlan("TP-1","TP-2","TP-3")

unusedTCT()

Returns a list of Test Case Template(s) which weren’t used in any Test Plan.

JQL function unusedTCT()
sample query issuekey in unusedTCT()

requirementsWithDefects()

Returns a list of Requirements conected with Defects which have specific parameters.

JQL function requirementsWithDefects("","")
arguments a1= Defect Priority
b1= Defect Resolution
sample query key in requirementsWithDefects("","")
returns all requirements with defects with all possible priorities and resolutions

key in requirementsWithDefects("High","Resolved")
returns all requirements with defects which have "High" priority and are resolved

testRepoTreeShallowSearch()

Returns a list of Test Case Templates from the given folder path from Test Repository tree.

Note
  • If you do not provide any project key then the search is performed in all Test Repository trees.
  • If you provide an empty folder path or “/” as the first parameter then the search is performed in the root folder.
JQL function testRepoTreeShallowSearch("","")
arguments a1= Full folder path from the Test Repository (string)
b1= Project Key
b2= Project Key
...
bn= Project Key
sample query key in testRepoTreeShallowSearch("Login")
returns Test Case Templates from the specified folder path from Test Repositories in all projects

key in testRepoTreeShallowSearch("Component/Login","sample")
returns Test Case Templates from the specified folder path from Test Repository in the given project

testRepoTreeDeepSearch()

Returns a list of Test Case Templates from the given folder path and its subfolders from Test Repository tree.

Note
  • If you do not provide any project key then the search is performed in all Test Repository trees.
  • If you provide an empty folder path or “/” as the first parameter then the search is performed in the root folder.
JQL function testRepoTreeDeepSearch("","")
arguments a1= Full folder path from the Test Repository (string)
b1= Project Key
b2= Project Key
...
bn= Project Key
sample query key in testRepoTreeDeepSearch("Login")
returns Test Case Templates from the specified folder path and its subfolders from Test Repositories in all projects

key in testRepoTreeDeepSearch("Component/Login","sample")
returns Test Case Templates from the specified folder path and its subfolders from Test Repository in the given project