(8.5-en) 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.

ID	Usage	Description
1	issue in testSuite()	Search Issue in any Test Suite
2	issue in testSuite('Test Suite Name')	Search Issue in a root Test Suite
3	issue in testSuite('Test Suite 1/Sub Test Suite')	Search Issue in a specific Test Suite (inside root Test Suite)
4	issue in testSuite('Test Suite 1','Test Suite 2')	Search Issue in more than one specific Test Suite
5	issue not in testSuite()	Search Issue not in any Test Suite

hasRequirements()

Below are some of the sample usages of hasRequirements() JQL function.

ID	Usage	Description
1	issue in hasRequirements()	Search Test Cases those have Requirements associated
2	issue in hasRequirements('Issuekey1','Issuekey2')	Search Test Cases those have specified Requirements associated
3	issue not in hasRequirements() and type = 'Test Case'	Search Test Cases those have no Requirement associated

hasTestCases()

Below are some of the sample usages of hasTestCases() JQL function.

ID	Usage	Description
1	issue in hasTestCases()	Search Requirements those have Test Cases associated.
2	issue in hasTestCases('Issuekey1','Issuekey2')	Search Requirements those have specified Test Cases associated
3	issue not in hasTestCases() and type = 'Requirement'	Search Requirements those have no Test Case associated

bugsInTestPlan()

Below are some of the sample usages of bugsInTestPlan() JQL function.

ID	Usage	Description
1	issue in bugsInTestPlan("Issuekey")	Search 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.

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.

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.

bugsInRequirement()

Below are some of the sample usages of bugsInRequirement() JQL function.

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.

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

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.

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.