TestFLO - Test Management for Jira

Last updated Aug 26, 2019

JQL functions

This page provides informations 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