synapseRT JQL Reference
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.
Please note that this JQL function MUST be used with 'project = <projectKey>' together.
ID | Usage | Description |
|---|---|---|
| 1 | project = <projectKey> AND issue in testSuite() | Searches Test Cases in any Test Suite from a specified Jira project |
| 2 | project = <projectKey> AND issue in testSuite('Test Suite Name') | Searches Test Cases in a root Test Suite from a specified Jira project |
| 3 | project = <projectKey> AND issue in testSuite('Test Suite 1/Sub Test Suite') | Searches Test Cases in a specific Test Suite (inside root Test Suite) from a specified Jira project |
| 4 | project = <projectKey> AND issue in testSuite('Test Suite 1','Test Suite 2') | Searches Test Cases in more than one specific Test Suite from a specified Jira project |
| 5 | project = <projectKey> AND issue not in testSuite() | Searches Test Cases not in any Test Suite from a specified Jira project |
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 nested 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 nested 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 nested 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 nested 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 nested 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.
Please note that nested functions are supported in this JQL.
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 |
| 3 | issue not in testPlanMembers("issueKey") | Searches the Test Cases those are not present in given Test Plan. |
| 4 | issue in testPlanMembers('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 Test Plans, those Test Plans are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
| 5 | issue in testPlanMembers('project = <projectKey> AND component = "<Component Name">','Result') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches the Test Cases associated with a set Test Plans and with the given execution result, those Test Plans are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
testPlanMembersWithLatestResult()
Below are some of the sample usages of testPlanMembersWithLatestResult() JQL function.
Please note that nested functions are supported in this JQL.
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 |
| 3 | issue in testPlanMembersWithLatestResult('project = <projectKey> AND component = "<Component Name">','Result') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches the Test Cases with the latest test result equal to specified "Result" (e.g. Failed) from a set of Test Plans, those Test Plans are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
| 4 | issue in testPlanMembersWithLatestResult('project = <projectKey> AND component = "<Component Name">','Result1','Result2') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches the Test Cases with the latest test results equal to specified "Result1" or "Result2" (e.g. Failed or Blocked) from a set of Test Plans, those Test Plans are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
testCasesInBug()
Below are some of the sample usages of testCasesInBug() JQL function.
Please note that nested functions are supported in this JQL.
ID | Usage | Description |
|---|---|---|
| 1 | issue in testCasesInBug("bugKey") | Searches the Test Cases associated with the given Bug Key issueKey |
| 2 | issue not in testCasesInBug("") and issuetype = "Test Case" | Searches the Test Cases those are NOT associated with any Bug |
| 3 | issue in testCasesInBug('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 Bugs, those Bugs are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
executePeriod()
Below are some of the sample usages of executePeriod() JQL function.
Please note that the supported date format is: yyyy-MM-dd
ID | Usage | Description |
|---|---|---|
| 1 | issue in executePeriod("startDate","endDate") | Searches the Test Cases those are executed during a given period |
childrenOfParentRequirement()
Below are some of the sample usages of childrenOfParentRequirement() JQL function.
Please note that nested functions are supported in this JQL.
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. |
| 3 | issue in childrenOfParentRequirement('project = <projectKey> AND component = "<Component Name">') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches only the immediate children from a set of Requirements, those Requirements are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
| 4 | issue in childrenOfParentRequirement('project = <projectKey> AND component = "<Component Name">','all') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches immediate and its grand children at all levels from a set of Requirements, those Requirements are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
parentRequirement()
Below are some of the sample usages of childrenOfParentRequirement() JQL function.
Please note that nested functions are supported in this JQL.
ID | Usage | Description |
|---|---|---|
| 1 | issue in parentRequirement() | Searches all Requirements those have child Requirements linked |
| 2 | issue in parentRequirement("Root") | Searches all top level Requirements those have child Requirements linked |
| 3 | issue in parentRequirement("issueKey") | Searches immediate parent Requirement with the given child Requirement Key issueKey |
| 4 | issue in parentRequirement("issueKey1","issueKey2") | Searches immediate parent Requirements with the given child Requirement Keys issueKey1, issueKey2 |
| 5 | issue in parentRequirement('project = <projectKey> AND component = "<Component Name">') Note: The outer quote should be a single quote ' , otherwise it will return syntax error. | Searches immediate parent Requirements from a set of child Requirements, those child Requirements are returned by nested function ('project = <projectKey> AND component = "<Component Name">') |
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 |
runAttributeOfCycle()
Below are some of the sample usages of runAttributeOfCycle() JQL function.
Please note that this JQL is developed to use in Test Cycle page only.
ID | Usage | Description |
|---|---|---|
| 1 | issue in runAttributeOfCycle("runAttributeValue1") | Searches the test executions with given run attribute value |
| 2 | issue in runAttributeOfCycle("runAttributeValue1","runAttributeValue2") | Searches the test executions with given run attribute values |