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
1issue in testSuite()Searches Test Cases in any Test Suite
2issue in testSuite('Test Suite Name')Searches Test Cases in a root Test Suite
3issue in testSuite('Test Suite 1/Sub Test Suite')Searches Test Cases in a specific Test Suite (inside root Test Suite)
4issue in testSuite('Test Suite 1','Test Suite 2')Searches Test Cases in more than one specific Test Suite
5issue 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

1issue in stepText("")Searches Test Cases those don't contain any test step
2issue 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
1issue in hasRequirements()

Searches Test Cases those have Requirements associated

2issue in hasRequirements('issueKey1','issueKey2')Searches Test Cases those have specified Requirements associated
3issue 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
1issue in hasTestCases()Searches Requirements those have Test Cases associated
2issue in hasTestCases('issueKey1','issueKey2')Searches Requirements those have specified Test Cases associated
3issue 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

1issue in requirementSuite()Searches Requirements in any Requirement Suite
2issue in requirementSuite('Requirement Suite Name')Searches Requirements in a root Requirement Suite
3issue in requirementSuite('Requirement Suite 1/Sub Requirement Suite')Searches Requirements in a specific Requirement Suite (inside root Requirement Suite)
4issue in requirementSuite('Requirement Suite 1','Requirement Suite 1')Searches Requirements in more than one specific Requirement Suite
5issue 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

1issue 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
2issue in requirementsInBug('issueKey','True')Searches aggregated Requirements from which the given Defect issueKey is reported
3issue 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
1issue in bugsInTestPlan('issueKey')Searches Bugs those are created from a Test Plan
2issue 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
1issue 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
1issue in bugsInTestCase('issueKey')Searches the Bugs associated with the given Test Case Key issueKey
2issue in bugsInTestCase('issueKey1','issueKey2')Searches the Bugs associated with the given Test Case Keys issueKey1 and issueKey2.
3issue not in bugsInTestCase("") and issuetype = BugSearches 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
1issue in bugsInRequirement('issueKey')Searches the Bugs associated with the given Requirement Key issueKey
2issue 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
1issue in bugsInBuild('BuildName')Searches the Bugs associated with the given Build Name
2issue 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
1issue in bugsInEnvironment('EnvName')Searches the Bugs associated with the given Environment Name.
2issue 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
1issue 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
1issue 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

1issue 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
1issue 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
1issue 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
1issue 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
1issue 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
1issue  in hasCyclesOfDefectCount("10")Searches all the Test Plans which has Test Cycle with defects count equal to 10
2issue in hasCyclesOfDefectCount("<=","10")Searches all the Test Plans which has Test Cycle with defects count less than or equal to 10
3issue 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
1issue in testPlanMembers("issueKey")Searches the Test Cases associated with the given Test Plan Key issueKey
2issue in testPlanMembers("issueKey","Result")Searches the Test Cases associated with the given Test Plan and with the given execution result
3issue 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

1issue 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
2issue 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

1issue in testCasesInBug("bugKey")Searches the Test Cases associated with the given Bug Key issueKey
2issue 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

1issue 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
1issue  in childrenOfParentRequirement("issueKey")Searches only the immediate children with the given Requirement Key issueKey.
2issue  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

1issue  in parentRequirement()Searches all Requirements those have child Requirements linked
2issue  in parentRequirement("Root")Searches all top level Requirements those have child Requirements linked
3issue  in parentRequirement("issueKey")Searches immediate parent Requirement with the given child Requirement Key issueKey
4issue  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
1issue 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

1issue in testCycleMembers('TestPlanissueKey','TestCycleName')Searches all Test Case members from specified Test Cycle
2issue in testCycleMembers('TestPlanissueKey','TestCycleName','Not Tested')Searches all 'Not Tested' Test Case members from specified Test Cycle
3issue in testCycleMembers('TestPlanissueKey','TestCycleName','NA')Searches all 'NA' Test Case members from specified Test Cycle
4issue in testCycleMembers('TestPlanissueKey','TestCycleName','Passed')Searches all 'Passed' Test Case members from specified Test Cycle
5issue in testCycleMembers('TestPlanissueKey','TestCycleName','Failed')Searches all 'Failed' Test Case members from specified Test Cycle
6issue 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

1testerOfCycle = <username>Searches the test executions assigned to the given Jira user
2testersOfCycle = 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

1resultsOfCycle = <result>Searches the test executions with given test result
2resultsOfCycle 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

1issue in testersOfCycle("username")Searches the test executions assigned to the given Jira user
2issue 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

1issue in resultsOfCycle("Result")Searches the test executions with given test result
2issue 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

1issue in runAttributeOfCycle("runAttributeValue1")Searches the test executions with given run attribute value
2issue in runAttributeOfCycle("runAttributeValue1","runAttributeValue2")Searches the test executions with given run attribute values