Enhanced querying with JQL

issuetype = 'Test Set' 

   and key in testTestSet('DEMO-1')

(1) 

issuetype = 'Test'  and key in testSetTests('DEMO-5')

(2) 

issuetype = 'Test' 

   and key in testSetTests('Test sets saved filter')

(1) 

issue in testsWithNoTestSet()

(2) 

issue in testsWithNoTestSet("saved_filter")

issuetype = 'Pre-Condition' 

   and key in testPreConditions('DEMO-1')

issuetype = 'Test' 

   and key in preConditionTests('DEMO-1')

(1)
issuetype = 'Feature' 

   and key in testRequirements('DEMO-1')

(2)

issuetype = 'Feature'

   and key in testRequirements('Tests saved filter')

(1)

issuetype = 'Test' 

   and key in requirementTests('DEMO-10')

(2)

issuetype = 'Test' 

   and key in requirementTests('Requirements saved filter')

P1 - Project Name/Key/Id

P2 - Fix Version 

P3 - Fix Version (Optional)

...

Pn - Fix Version (Optional)

issuetype = 'Test' 

   and issue in 

   testsWithReqVersion('DEMO', 

                       'v1.0', 'v1.1')

P1 - Project Name/Key/Id

P2 - Fix Version 

P3 - Fix Version (Optional)

...

Pn - Fix Version (Optional)

issuetype = 'Test' 

   and issue in 

   testsWithTestSetVersion( 'DEMO', 

                           'v1.0', 'v1.1')

P1 - Test Execution Issue Key/Id or Filter ID

P2 - Test Run Status list separated by "|"(pipe) (Optional)

P3 - User assigned to execute Test Run (Optional).

P4 - Defects Flag with value in true or false (optional).

P5 - User who executed the Test Run (optional).

Returns a List of Test issues associated with the input Test Execution issues from P1 optionally filtered by the current test run status for each Test issue.

Parameter P1 can either be a single Test Execution issue key, an ID or a saved filter containing multiple Test Execution issues.

Possible Test Run Status values are: PASS, FAIL, EXECUTING, ABORTED, TODO and all custom statuses.

P3 corresponds to the user assigned to execute the Test Run, while P5 corresponds to the one who actually executed it. For analyzing the joint values of all Test Run Assignees, "" should be used. For taking into account the Test Runs without any Assignee, then "__NULL__" should be used.

If you pass true as the value for P4, the query returns all Tests from a particular set of Test Executions where no Defects were created.

(1)

issuetype = 'Test' 

   and issue in testExecutionTests('DEMO-9')

(2)

issuetype = 'Test' 

   and issue in testExecutionTests('DEMO-9', 

                                   'PASS')

(3)

issuetype = 'Test' 

   and issue in testExecutionTests('DEMO-9', 

                                   'PASS', 

                                    'user A')

(4)

issuetype = 'Test' 

   and issue in testExecutionTests(

                      'Saved Test Execution Filter', 

                      'PASS')

(5)

issuetype = 'Test' 

   and issue in testExecutionTests(

                      'Saved Test Execution Filter', 

                      '',

                      'user A')

(6)

issue in testExecutionTests(

                      'Saved Test Execution Filter', 

                      '',

                      'user A', 'true')

(7)

issue in testExecutionTests(

                      'Saved Test Execution Filter', 

                      '','', 'false', 'admin')

(1)

issuetype = Test and issue in testsWithoutTestExecution()

(2)

issuetype = Test and issue in testsWithoutTestExecution("saved_filter")

P1 - Status list separated by "|"(pipe)

P2 - Project (Optional)

P3 - Version to calculate requirement status (Optional)

P4 - Test Environment (Optional)

P5 - Flat (Optional)

P6 - ToDate (Optional)

P7 - Saved Filter (Optional)

Returns a list of Requirement Issues with the provided coverage status.

Please provide Project parameter (P2) to restrict the requirements to the specified project.

If analyzing on a specific version, then the Project and Version parameters must be filled.

Optional filters include:

Test Environment, for taking into account the Test Executions made for that environment. For analyzing the joint values of all environments, "" should be used. For taking into account the Test Executions without any Test Environment assigned, then "__NULL__" should be used.

Flat that indicates whether all Requirements (not only parents) should be searched. If "Flat" is not provided, the default value is 'false'.

ToDate considers only those requirements executions before a specific date/time (the date literal must follow the ISO8601 format).

Saved Filters considers only requirements from that specific filter.

P1 - Status list separated by "|"(pipe)

P2 - Test Plan Issue Key

P3 - Test Environment (Optional)

P4 - Flat (Optional)

P5 - ToDate (Optional)

P6 - Project (Optional)

P7 - Saved Filter (Optional)

Returns a list of Requirement Issues with the coverage status calculated for the given Test Plan issue.

Optional filters include:

Test Environment, for taking into account the Test Executions made for that environment. For analyzing the joint values of all environments, "" should be used. For taking into account the Test Executions without any Test Environment assigned, then "__NULL__" should be used.

Flat that indicates whether all Requirements (not only parents) should be searched. If "Flat" is not provided, the default value is 'false'.

ToDate considers only those requirements executions before a specific date/time (the date literal must follow the ISO8601 format).

Project and Saved Filters considers only requirements from that specific project or filter.

(1)

issue in 

    requirementsWithStatusByTestPlan('OK', 'TP-123')

(2)

issue in 

    requirementsWithStatusByTestPlan('NOK', 

                                    'TP-123',

                                    '',

                                    'true')

(3)

issue in 

    requirementsWithStatusByTestPlan('NOK', 

                                    'TP-123', 

                                    'Android',

                                    'false',

                                    '2014-01-01')

(4)
issue in
    requirementsWithStatusByTestPlan('NOK',
                                     'TP-123',
                                     'Android',
                                     'false',
                                     ' ',
                                     'Calculator',
                                     'Requirements saved filter')

defectsCreatedDuringTesting

(1)

issue in defectsCreatedDuringTesting()

(2) 

issue in defectsCreatedDuringTesting("TEST-123") 

(3) 

issue in defectsCreatedDuringTesting("saved_filter")

P1 - Test Execution issue Key or Test Execution based Filter

P2 - List of users separated by "|" (pipe). (Optional)

Returns a list of Defects created during the execution of the specified Test Executions; can optionally be filtered by the Defect Issue Assignee username.

(1) issue in 

   defectsCreatedDuringTestExecution(TEST-123)

(2) issue in 

   defectsCreatedDuringTestExecution(saved_filter)

(3) issue in 

   defectsCreatedDuringTestExecution(saved_filter, 'user1|user2')

(4) issue in 

   defectsCreatedDuringTestExecution(TEST-123, 'user1|user2')

defectsCreatedForRequirement

(1) 

issue in defectsCreatedForRequirement("REQ-123")

(2) 

issue in defectsCreatedForRequirement("saved_filter")

(1) 

issue in manualTestsWithoutSteps()

(2) 

issue in manualTestsWithoutSteps("saved_filter")

P1 - Test Issue Key/Id or Filter Name/Id

P2 - Test Run Status list separated by "|"(pipe) (Optional)

Returns a list of test executions associated with the input Test Issues from P1 optionally filtered by the current Test status in each Test Execution issue.

Parameter P1 can either be a single Test issue key or Id or a saved filter name or id containing multiple Test issues.

Possible Test Run Status values are: PASS, FAIL, EXECUTING, ABORTED, TODO and all custom statuses.

(1)

issuetype = 'Test Execution' 

   and issue in testTestExecutions('DEMO-9')

(2)

issuetype = 'Test Execution' 

   and issue in testTestExecutions('DEMO-9', 

                                   'PASS')

(3)

issuetype = 'Test Execution' 

   and issue in testTestExecutions(

                      'Saved Test Filter', 

                      'PASS')

P1 - Username (Optional)

P2 - Status (Optional) Username is required in case we use this parameter

Returns a list of test executions where a user has at least one test run assigned to him. You can optionally specify a user with P1, or if the user is omitted the current user will be used. Note that if you are not logged in to JIRA, a user must be specified.

If you use status parameter then user is required

(1)

issuetype = 'Test Execution' and

  issue in testExecWithTestRunsAssignedToUser()

(2)

issuetype = 'Test Execution' and

  issue in testExecWithTestRunsAssignedToUser('userDPC')

(3)

issuetype = 'Test Execution' and

  issue in testExecWithTestRunsAssignedToUser('userDPC', "FAIL")

testSetPartiallyIn

(1)

issuetype = 'Test Set' and

  issue in testSetPartiallyIn('DEMO-15')

(2)

issuetype = 'Test Set' and

  issue in testSetPartiallyIn('testExecList')

(3)

issuetype = 'Test Set' and

  issue in testSetPartiallyIn('testPlanList')

testSetFullyIn

(1)

issuetype = 'Test Set' and

  issue in testSetFullyIn('DEMO-15')

(2)

issuetype = 'Test Set' and

  issue in testSetFullyIn('testExecList')

(3)

issuetype = 'Test Set' and

  issue in testSetFullyIn('testPlanList')

P1 - Test Plan Key/Filter of Test Plans

P2 - Status (Optional)

P3 - Environment (Optional)

Returns a list of tests that are associated with the test plan.

The "status" parameter is optional and allows to filter Test issues in a specific Plan with the specified execution status. If the "status" parameter is present, users might also pass the "environment" parameter. If this parameter is filled, Xray will provide all Tests in a Test Plan that are in the specified "status" and for the specified "environment".

Returns a list of test executions that are associated with a Test Plan or a saved filter of Test Plans.

(1)

issue in testPlanTestExecutions("DEMO-10")

(2)

issue in testPlanTestExecutions("Test Plans saved filter")

testPlanRequirements

(1)

issue in testPlanRequirements("DEMO-20")

(2)

issue in testPlanRequirements("Test Plans saved filter")

issuetype = 'Test Plan' 

   and key in testTestPlan('DEMO-1')

testRepositoryFolderTests

P1 - Project Key

P2 - Folder Path

P3 - Flatten (Optional)

Returns the list of Tests contained in a folder (P2) of the Test Repository of a Project (P1)

May optionally include the Tests in sub-folders by setting Flatten (P3) to "true".

(1)

issue in testRepositoryFolderTests("CALC", 'Parent/Child')

(2)

issue in testRepositoryFolderTests("CALC", 'Parent/Child', "true")

testPlanFolderTests

P1 - Test Plan Key

P2 - Folder Path

P3 - Flatten (Optional)

P4 - Test Run Status (Optional)

P5 - Test Environment (Optional)

Returns the list of Tests contained in a folder (P2) of a Test Plan (P1).

May optionally include the Tests in sub-folders by setting Flatten (P3) to "true".

Can also filter by Tests Run Status (P4) for a given Test Environment (P5).

To analyze the joint values of all Test Environments, "" should be used. To analyze the Test Executions without any Test Environment assigned, then "__NULL__" should be used.

(1)

issue in testPlanFolderTests(CALC-10, 'Parent/Child')

(2)

issue in testPlanFolderTests(CALC-10, 'Parent/Child', "true")

(3)

issue in testPlanFolderTests(CALC-10, 'Parent/Child', "true", "TODO|FAIL", "windows")