The following JQL functions are part of QMetry for Jira. Construct JQL filters using QMetry functions that enhances the search & reporting capabilities. JQL filters using QMetry Functions can be saved, shared, exported or used in a dashboard just like a normal JQL.

getStoriesLinkedWithTestCasesLike("JQL")

Returns a list of stories which has given Test Cases linked.

Syntax	getStoriesLinkedWithTestCasesLike("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Mandatory
Examples	Find all stories linked with test cases which have Fix version V_1 issueKey in getStoriesLinkedWithTestCasesLike("fixVersion= V_1")

getStoriesLinkedWithTestScenariosLike("JQL")

Returns a list of Stories which has given Test Scenarios linked

Syntax	getStoriesLinkedWithTestScenariosLike("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Mandatory
Examples	1. Find stories which have test scenarios of version V_1 associated: issueKey in getStoriesLinkedWithTestScenariosLike("fixVersion= V_1")

getIssuesLinkedWithTestRunsLike("JQL")

List of issues which are linked with given Test Runs

Syntax	getIssuesLinkedWithTestRunsLike("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Mandatory
Examples	1. Find all issues which are linked to test runs of Project REG: issueKey in getIssuesLinkedWithTestRunsLike("Project= REG") 2. Find all issues linked to test runs of fixVersion V_1: issueKey in getIssuesLinkedWithTestRunsLike("fixVersion= V_1)

getTestRunsLinkedWithTestCasesLike("JQL")

Returns a list of Test Runs which are linked with given Test Cases

Syntax	getTestRunsLinkedWithTestCasesLike("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Mandatory
Examples	1. Find Test Runs which have linked Test Cases of Projects REG and IP1: issueKey in getTestRunsLinkedWithTestCasesLike("Project in (REG, IP1)") 2. Find Test Runs which have linked Test Cases of Version V_1: getTestRunsLinkedWithTestCasesLike("fixVersion= V_1")

getTestRunsLinkedWithScenariosLike("JQL")

Returns a list of Test Runs which are linked with given Test Scenarios

Syntax	getTestRunsLinkedWithScenariosLike("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Mandatory
Examples	1. Find Test Runs which have linked Test Scenarios of Projects REG and IP1: issueKey in getTestRunsLinkedWithScenariosLike("Project in (REG, IP1)") 2. Find Test Runs which have linked Test Scenarios of Version V_1 AND Project REG: issueKey in getTestRunsLinkedWithScenariosLike("fixVersion= V_1 AND Project= REG")

getTestRunsLinkedWithStoriesLike("JQL")

Returns a list of Test Runs which are linked with given Stories

Syntax	getTestRunsLinkedWithStoriesLike("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Mandatory
Examples	1. Find Test Runs which have linked Stories having Components as Comp_1: issueKey in getTestRunsLinkedWithStoriesLike("component = Comp_1") 2. Find Test Runs which have linked Stories of Version V_1 AND Project REG: issueKey in getTestRunsLinkedWithStoriesLike("fixVersion= V_1 AND Project= REG")

getTestCasesLinkedWithStoriesLike("JQL")

Returns List of Test Cases which are linked with given stories

Syntax	getTestCasesLinkedWithStoriesLike("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Mandatory
Examples	1. Find Test Cases linked to Stories of version V_1: issue in getTestCasesLinkedWithStoriesLike("fixVersion= V_1")

getTestCasesLinkedWithScenariosLike("JQL")

Returns a list of Test Cases which are linked with given Test Scenarios

Syntax	getTestCasesLinkedWithScenariosLike("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Mandatory
Examples	1. Find all Test Cases linked with Test Scenario of Project "IVS" issue in getTestCasesLinkedWithScenariosLike("Project=IVS") 2. Find all Test Cases linked with Test Scenario with fix version Version 1.0 RTS issuekey in getTestCasesLinkedWithScenariosLike("fixVersion = Version 1.0 RTS")

getTestScenariosLinkedWithStoriesLike("JQL")

Returns a list of Test Scenarios linked with given stories

Syntax	getTestScenariosLinkedWithStoriesLike("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Mandatory
Examples	1. Find all Test Scenario linked with Stories associated to FTS, BVQA projects issue in getTestScenariosLinkedWithStoriesLike("Project=FTS, BVQS")

getTestScenariosLinkedWithTestCasesLike("JQL")

Returns a list of Test Scenarios which has given test cases linked

Syntax	getTestScenariosLinkedWithTestCasesLike("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Mandatory
Examples	1. Find Test Scenario linked with Test Cases having Major Priority issue in getTestScenariosLinkedWithTestCasesLike("priority = Major") 2. Find Test Scenario linked with Test Cases having To Do Status issue in getTestScenariosLinkedWithTestCasesLike("status= To Do")

getTestCasesHavingSteps()

Returns a list of Test Cases which has steps inside it

Syntax	getTestCasesHavingSteps() OR getTestCasesHavingSteps("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	Find All Test Cases having step units issuekey in getTestCasesHavingSteps() 2. Find Test Cases of project IVS which having step units issuekey in getTestCasesHavingSteps("project = IVS")

getStoriesHavingDefects()

Returns a list of stories which has defects inside it

Syntax	getStoriesHavingDefects() OR getStoriesHavingDefects("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all Stories having linked defects with test cases / test steps with label as lbl2 issue in getStoriesHavingDefects("Labels=lbl2") 2.Find all Stories having linked defects with test cases / test steps for Project = RTS issuekey in getStoriesHavingDefects("Project=RTS")

getTestCasesHavingDefects()

Returns a list of Test Cases which has defects inside it

Syntax	getTestCasesHavingDefects() OR getTestCasesHavingDefects("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all Test Cases having linked defects to test case / test steps with fix version as V_1.1 issuekey in getTestCasesHavingDefects("Fix Version = V_1.1") 2. Find all Test Cases having linked defects to test case / test steps with Resolution as Unresolved issuekey in getTestCasesHavingDefects("Resolution=Unresolved")

getTestScenariosHavingDefects()

Returns a list of Test Scenarios which has defects inside it

Syntax	getTestScenariosHavingDefects() OR getTestScenariosHavingDefects("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all Test Scenario having defects linked with test case / test steps with Priority as High issuekey in getTestScenariosHavingDefects("Priority=High") 2. Find all Test Scenario having defects linked with test case / test steps with Sprint as Sprint 1 issue in getTestScenariosHavingDefects("Sprint = Sptint 1")

getTestRunsHavingPlatformsLike()

Returns a list of Test Runs which has given platforms

Syntax	getTestRunsHavingPlatformsLike("comma separated platforms") OR getTestRunsHavingPlatformsLike("comma separated platforms","JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all Test Runs executed on Default Platform issuekey in getTestRunsHavingPlatformsLike("Default Platform") 2. Find all Test Runs executed on Firefox or Google Chrome Platform and having status=To Do. issuekey in getTestRunsHavingPlatformsLike("Firefox,Google Chrome") AND status ="To Do"

getTestCasesHavingExecutionResultLike()

Returns a list of Test Cases which has given execution results

Syntax	getTestCasesHavingExecutionResultLike("comma separated platforms") OR getTestCasesHavingExecutionResultLike(“comma separated result”,”JQL”)
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all Test Cases having execution Result Pass and Fail. issuekey in getTestCasesHavingExecutionResultLike("Pass,Fail") 2.Find all Test Cases of medium priority executed with status=Blocked. issuekey in getTestCasesHavingExecutionResultLike("Blocked") and priority =Medium

getAutomatedTestCases()

Returns a list of Test Cases which are automated

Syntax	getAutomatedTestCases() OR getAutomatedTestCases("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all cases created through Automation. issuekey in getAutomatedTestCases() 2. Find all Test Runs created through Automation and having label=Automated. issuekey in getAutomatedTestCases("labels=Automated")

getAutomatedTestScenarios()

Returns a list of Test Scenarios which are automated

Syntax	getAutomatedTestScenarios() OR getAutomatedTestScenarios("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all Test Scenarios created through Automation. issuekey in getAutomatedTestScenarios() 2. Find all Test Scenarios created through Automation in project=VTM and having resolution=Done issuekey in getAutomatedTestScenarios("project = VTM AND resolution = Done ORDER BY summary ASC" )

getAutomatedTestRuns()

Returns a list of Test Runs which are automated

Syntax	getAutomatedTestRuns() OR getAutomatedTestRuns("JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all Test Runs created through Automation issuekey in getAutomatedTestRuns() 2. Find all Test Runs created through Automation having label=hpuft issuekey in getAutomatedTestRuns("labels = hpuft")

getTestCasesExecutedBy()

Returns a list of Test Cases executed by given users

Syntax	getTestCasesExecutedBy("comma separated users") OR getTestCasesExecutedBy("comma separated users","JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all Test Cases Executed by admin users issuekey in getTestCasesExecutedBy("admin")

getTestCasesByAssignTo()

Returns a list of Test Cases assigned to given users

Syntax	getTestCasesByAssignTo("comma separated assigntousers") OR getTestCasesByAssignTo("comma separated assigntousers","JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all Test Cases assigned to user "Peter" issuekey in getTestCasesByAssignTo("Peter")

getTestRunsUpdatedAfter()

Returns a list of Test Runs executed in given time frame

Syntax	getTestRunsUpdatedAfter() OR getTestRunsUpdatedAfter("date","JQL")
Supported fields	issue, issuekey
Supported operators	IN, NOT IN
JQL Argument	Optional
Examples	1. Find all Test Runs wherein Test Cases are updated after 01 January,2017 till current date. issuekey in getTestRunsUpdatedAfter("2017-01-01") 2. Find all Test Runs of Propject=VTM wherein Test Cases are updated after 01 January,2018 till current date. issuekey in getTestRunsUpdatedAfter("2018-01-01","project = VTM ")

QMetry Test Management for JIRA Server 2.50

JQL Functions