(9.7-en) synapseRT JQL Reference
- Cheney Ma
- Yuri Matsumoto
The following JQL functions are offered for synapseRT related searches in your JQL query.
testSuite()
Below are some of the sample usages of testSuite() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in testSuite() | Searches Test Cases in any Test Suite |
| 2 | issue in testSuite('Test Suite Name') | Searches Test Cases in a root Test Suite |
| 3 | issue in testSuite('Test Suite 1/Sub Test Suite') | Searches Test Cases in a specific Test Suite (inside root Test Suite) |
| 4 | issue in testSuite('Test Suite 1','Test Suite 2') | Searches Test Cases in more than one specific Test Suite |
| 5 | issue not in testSuite() | Searches Test Cases not in any Test Suite |
stepText()
Below are some of the sample usages of stepText() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in stepText("") | Searches Test Cases those don't contain any test step |
| 2 | issue in stepText("Texts") | Searches Test Cases which contains text as Texts in their test steps |
hasRequirements()
Below are some of the sample usages of hasRequirements() JQL function.
Please note that nest functions are supported in this JQL.
ID | Usage | Description |
|---|---|---|
| 1 | issue in hasRequirements() | Searches Test Cases those have Requirements associated |
| 2 | issue in hasRequirements('issueKey1','issueKey2') | Searches Test Cases those have specified Requirements associated |
| 3 | issue not in hasRequirements() and type = 'Test Case' | Searches Test Cases those have no Requirement associated |
| 4 | issue in hasRequirements('project = <projectKey> AND component = "<Component Name>"') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches Test Cases those are associated to a set of Requirements, those Requirements are returned by nested function (project = projectName AND component = "Component Name") |
hasTestCases()
Below are some of the sample usages of hasTestCases() JQL function.
Please note that nest functions are supported in this JQL.
ID | Usage | Description |
|---|---|---|
| 1 | issue in hasTestCases() | Searches Requirements those have Test Cases associated. |
| 2 | issue in hasTestCases('issueKey1','issueKey2') | Searches Requirements those have specified Test Cases associated |
| 3 | issue not in hasTestCases() and type = 'Requirement' | Searches Requirements those have no Test Case associated |
| 4 | issue in hasTestCases('project = <projectKey> AND component = "<Component Name">') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches Requirements those have a set of Test Cases associated, those Test Cases are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
requirementSuite()
Below are some of the sample usages of requirementSuite() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in requirementSuite() | Searches Requirements in any Requirement Suite |
| 2 | issue in requirementSuite('Requirement Suite Name') | Searches Requirements in a root Requirement Suite |
| 3 | issue in requirementSuite('Requirement Suite 1/Sub Requirement Suite') | Searches Requirements in a specific Requirement Suite (inside root Requirement Suite) |
| 4 | issue in requirementSuite('Requirement Suite 1','Requirement Suite 1') | Searches Requirements in more than one specific Requirement Suite |
| 5 | issue not in requirementSuite() | Searches Requirements not in any Requirement Suite |
requirementsFromBaseline()
Below are some of the sample usages of requirementsFromBaseline() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in requirementsFromBaseline("projectKey", "groupName", "baselineName") | Searches Requirements from below:
|
requirementsInBug()
Below are some of the sample usages of requirementsInBug() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in requirementsInBug('issueKey') | Searches aggregated Requirements from which the given Defect issueKey is reported |
| 2 | issue in requirementsInBug('issueKey','True') | Searches aggregated Requirements from which the given Defect issueKey is reported |
| 3 | issue in requirementsInBug('issueKey','False') | Searches direct Requirements from which the given Defect issueKey is reported |
bugsInTestPlan()
Below are some of the sample usages of bugsInTestPlan() JQL function.
Please note that nest functions are supported in this JQL.
ID | Usage | Description |
|---|---|---|
| 1 | issue in bugsInTestPlan('issueKey') | Searches Bugs those are created from a Test Plan |
| 2 | issue in bugsInTestPlan('issueKey1','issueKey2') | Searches the Bugs associated with the given Test Plan Keys issueKey1 and issueKey2. |
| 3 | issue in bugsInTestPlan('project = <projectKey> AND component = "<Component Name">') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches Bugs those are associated to a set of Test Plans, those Test Plans are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
bugsInCycle()
Below are some of the sample usages of bugsInCycle() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in bugsInCycle('TestCycleName') | Searches the Bugs associated with the given Test Cycle Name. Wild card search allowed. |
bugsInTestCase()
Below are some of the sample usages of bugsInTestCase() JQL function.
Please note that nest functions are supported in this JQL.
ID | Usage | Description |
|---|---|---|
| 1 | issue in bugsInTestCase('issueKey') | Searches the Bugs associated with the given Test Case Key issueKey. |
| 2 | issue in bugsInTestCase('issueKey1','issueKey2') | Searches the Bugs associated with the given Test Case Keys issueKey1 and issueKey2. |
| 3 | issue not in bugsInTestCase("") and issuetype = Bug | Searches the Bugs those are NOT associated with any Test Case. |
| 4 | issue in bugsInTestCase('project = <projectKey> AND component = "<Component Name">') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches Bugs those are associated to a set of Test Cases, those Test Cases are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
bugsInRequirement()
Below are some of the sample usages of bugsInRequirement() JQL function.
Please note that nest functions are supported in this JQL.
ID | Usage | Description |
|---|---|---|
| 1 | issue in bugsInRequirement('issueKey') | Searches the Bugs associated with the given Requirement Key issueKey. |
| 2 | issue in bugsInRequirement('issueKey1','issueKey2') | Searches the Bugs associated with the given Requirement Keys issueKey1 and issueKey2. |
| 3 | issue in bugsInRequirement('project = <projectKey> AND component = "<Component Name">') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches Bugs those are associated to a set of Requirements, those Requirements are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
bugsInBuild()
Below are some of the sample usages of bugsInBuild() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in bugsInBuild('BuildName') | Searches the Bugs associated with the given Build Name. |
| 2 | issue in bugsInBuild('BuildName1','BuildName2') | Searches the Bugs associated with the given Build Names. |
bugsInEnvironment()
Below are some of the sample usages of bugsInEnvironment() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in bugsInEnvironment('EnvName') | Searches the Bugs associated with the given Environment Name. |
| 2 | issue in bugsInEnvironment('EnvName1','EnvName2') | Searches the Bugs associated with the given Environment Names |
hasActiveCycle()
Below are some of the sample usages of hasActiveCycle() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in hasActiveCycle() | Searches all the Test plans which has Active Test Cycle |
hasCycleWithBugs()
Below are some of the sample usages of hasCycleWithBugs() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in hasCycleWithBugs() | Searches all the Test Plans which has Test Cycle with Bugs |
testPlansWithoutTestCases()
Below are some of the sample usages of testPlansWithoutTestCases() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in testPlansWithoutTestCases() | Searches all the Test Plans without any Test Cases associated. |
hasCycleWithUnresolvedBugs()
Below are some of the sample usages of hasCycleWithUnresolvedBugs() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in hasCycleWithUnresolvedBugs() | Searches all the Test Plans which has Test Cycle with Unresolved Bugs |
hasCycleWithFailedTestCases()
Below are some of the sample usages of hasCycleWithFailedTestCases() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in hasCycleWithFailedTestCases() | Searches all the Test Plans which has Test Cycle with Failed Test cases |
hasCycleWithBlockedTestCases()
Below are some of the sample usages of hasCycleWithBlockedTestCases() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in hasCycleWithBlockedTestCases() | Searches all the Test Plans which has Test Cycle with Blocked Test cases |
hasCycleWithUntestedTestCases()
Below are some of the sample usages of hasCycleWithUntestedTestCases() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in hasCycleWithUntestedTestCases() | Searches all the Test Plans which has Test Cycle with Untested Test cases |
hasCyclesOfDefectCount()
Below are some of the sample usages of hasCyclesOfDefectCount() JQL function. Supported operators "==", ">=" and "<=".
ID | Usage | Description |
|---|---|---|
| 1 | issue in hasCyclesOfDefectCount("10") | Searches all the Test Plans which has Test Cycle with defects count equal to 10. |
| 2 | issue in hasCyclesOfDefectCount("<=","10") | Searches all the Test Plans which has Test Cycle with defects count less than or equal to 10 |
| 3 | issue in hasCyclesOfDefectCount(">=","10") | Searches all the Test Plans which has Test Cycle with defects count greater than or equal to 10. |
testPlanMembers()
Below are some of the sample usages of testPlanMembers() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in testPlanMembers("issueKey") | Searches the Test Cases associated with the given Test Plan Key issueKey. |
| 2 | issue in testPlanMembers("issueKey","Result") | Searches the Test Cases associated with the given Test Plan and with the given execution result. |
testPlanMembersWithLatestResult()
Below are some of the sample usages of testPlanMembersWithLatestResult() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in testPlanMembersWithLatestResult("testPlanKey","Result") | Searches the Test Cases with the latest test result equal to specified "Result" (e.g. Failed) from a given Test Plan. |
| 2 | issue in testPlanMembersWithLatestResult("testPlanKey","Result1","Result2") | Searches the Test Cases with the latest test results equal to specified "Result1" or "Result2" (e.g. Failed or Blocked) from a given Test Plan. |
childrenOfParentRequirement()
Below are some of the sample usages of childrenOfParentRequirement() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in childrenOfParentRequirement("issueKey") | Searches only the immediate children with the given Requirement Key issueKey. |
| 2 | issue in childrenOfParentRequirement("issueKey","all") | Searches immediate and its grand children at all levels with the given Requirement Key issueKey. |
testPlansForTester()
Below are some of the sample usages of testPlansForTester() JQL function.
ID | Usage | Description |
|---|---|---|
| 1 | issue in testPlansForTester("username") | Searches the Test Plans in which a Tester (= username) is assigned. |
testCycleMembers()
Below are some of the sample usages of testCycleMembers() JQL function. Supported operators "==", ">=" and "<=".
ID | Usage | Description |
|---|---|---|
| 1 | issue in testCycleMembers('TestPlanissueKey','TestCycleName') | Searches all Test Case members from specified Test Cycle. |
| 2 | issue in testCycleMembers('TestPlanissueKey','TestCycleName','Not Tested') | Searches all 'Not Tested' Test Case members from specified Test Cycle. |
| 3 | issue in testCycleMembers('TestPlanissueKey','TestCycleName','NA') | Searches all 'NA' Test Case members from specified Test Cycle. |
| 4 | issue in testCycleMembers('TestPlanissueKey','TestCycleName','Passed') | Searches all 'Passed' Test Case members from specified Test Cycle. |
| 5 | issue in testCycleMembers('TestPlanissueKey','TestCycleName','Failed') | Searches all 'Failed' Test Case members from specified Test Cycle. |
| 6 | issue in testCycleMembers('TestPlanissueKey','TestCycleName','Blocked') | Searches all 'Blocked' Test Case members from specified Test Cycle. |
testersOfCycle
Below are some of the sample usages of testersOfCycle JQL function.
The following operators are available for testersOfCycle JQL function: =; !=; is not; is; not in; in
Please note that this JQL is developed to use in Test Cycle page only.
ID | Usage | Description |
|---|---|---|
| 1 | testerOfCycle = <username> | Searches the test executions assigned to the given Jira user. |
| 2 | testersOfCycle = currentUser() | Searches the test executions assigned to the current Jira user. |
resultsOfCycle
Below are some of the sample usages of resultsOfCycle() JQL function.
The following operators are available for resultsOfCycle() JQL function: =; !=; is not; is; not in; in
Please note that this JQL is developed to use in Test Cycle page only.
ID | Usage | Description |
|---|---|---|
| 1 | resultsOfCycle = <result> | Searches the test executions with given test result. |
| 2 | resultsOfCycle in ("Result1","Result2") | Searches the test executions with given test results. |
testersOfCycle()
Below are some of the sample usages of testersOfCycle() JQL function.
Please note that this JQL is developed to use in Test Cycle page only.
ID | Usage | Description |
|---|---|---|
| 1 | issue in testersOfCycle("username") | Searches the test executions assigned to the given Jira user. |
| 2 | issue in testersOfCycle("username1","username2") | Searches the test executions assigned to the given Jira users. |
resultsOfCycle()
Below are some of the sample usages of resultsOfCycle() JQL function.
Please note that this JQL is developed to use in Test Cycle page only.
ID | Usage | Description |
|---|---|---|
| 1 | issue in resultsOfCycle("Result") | Searches the test executions with given test result. |
| 2 | issue in resultsOfCycle("Result1","Result2") | Searches the test executions with given test results. |