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.