Back to QMetry All Products Help Page
JQL Functions
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 |
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: |
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:
|
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:
|
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:
|
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:
|
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"
|
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
|
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 |
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
|
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
|
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
|
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
|
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.
|
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.
|
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.
|
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 |
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 ") |
getTestCasesLinkedWithFolder ("Project Key", "Folder Path") (New)
Returns a list of Test Cases which are linked with given folder.
Syntax | getTestCasesLinkedWithFolder ("Project Key",”Folder Path”) |
---|---|
Supported fields | issue, issuekey |
Supported operators | IN, NOT IN |
JQL Argument | Mandatory |
Examples | 1. Find Test Cases of Projects REG and folder “/Regression”: |
getTestRunsHavingDefectsLike ("JQL") (New)
Returns a list of Test Runs which are linked with defects.
Syntax | getTestRunsHavingDefectsLike ("JQL") |
---|---|
Supported fields | issue, issuekey |
Supported operators | IN, NOT IN |
JQL Argument | Mandatory |
Examples | 1. Find List of Test Runs having defects which are in In Progress status: |
getDefectsLinkedWithExecution ("JQL") (New)
Returns a list of Defects which are associated with test run(s).
Syntax | getDefectsLinkedWithExecution ("JQL") |
---|---|
Supported fields | issue, issuekey |
Supported operators | IN, NOT IN |
JQL Argument | Mandatory |
Examples | 1. Find List of Defects which are in In Progress status and associated with any test run(s): |
Back to QMetry All Products Help Page