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.

Please note that this JQL function MUST be used with 'project = <projectKey>' together.

ID	Usage	Description
1	project = <projectKey> issue in hasRequirements()	Searches Test Cases those have Requirements associated
2	project = <projectKey> issue in hasRequirements('issueKey1','issueKey2')	Searches Test Cases those have specified Requirements associated
3	project = <projectKey> issue not in hasRequirements() and type = 'Test Case'	Searches Test Cases those have no Requirement associated
4	project = <projectKey> AND 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.

Please note that this JQL function MUST be used with 'project = <projectKey>' together.

ID	Usage	Description
1	project = <projectKey> issue in hasTestCases()	Searches Requirements those have Test Cases associated
2	project = <projectKey> issue in hasTestCases('issueKey1','issueKey2')	Searches Requirements those have specified Test Cases associated
3	project = <projectKey> issue not in hasTestCases() and type = 'Requirement'	Searches Requirements those have no Test Case associated
4	project = <projectKey> 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:

Project = projectKey
Baseline Group = groupName
Baseline = baselineName

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

TestRay for Jira DC/Server (formerly synapseRT)

synapseRT JQL Reference

testSuite()

stepText()

hasRequirements()

hasTestCases()

requirementSuite()

requirementsFromBaseline()

requirementsInBug()

bugsInTestPlan()

bugsInCycle()

bugsInTestCase()

bugsInRequirement()

bugsInBuild()

bugsInEnvironment()

hasActiveCycle()

hasCycleWithBugs()

testPlansWithoutTestCases()

hasCycleWithUnresolvedBugs()

hasCycleWithFailedTestCases()

hasCycleWithBlockedTestCases()

hasCycleWithUntestedTestCases()

hasCyclesOfDefectCount()

testPlanMembers()

testPlanMembersWithLatestResult()

testCasesInBug()

executePeriod()

childrenOfParentRequirement()

parentRequirement()

testPlansForTester()

testCycleMembers()

testersOfCycle

resultsOfCycle

testersOfCycle()

resultsOfCycle()

runAttributeOfCycle()

Related pages