/
qtmj_getBugLinkedWithTRLike

qtmj_getBugLinkedWithTRLike

Description

This function returns a list of bugs discovered during all the executions of test cases or test steps based on the specified test cycle filter criteria.

Details

  • To execute the query successfully, you must provide at least two arguments: the Project Key and a Filter-based argument. The Filter-based argument must align with QMetry Supported Fields.

    • Project Key: It is a Jira Project key for which you will retrieve the stories.

    • Filtered-based arguments: It refers to test cycle filters.

  • The filter applies to both Active and Archived test cases, test cycles and their execution.

  • The filter applies only to linked test cases and their versions.

Supported Operators

  • Jira Operators -IN NOT IN

  • QMetry Operators -IN NOT IN LIKE NOT LIKE AND OR < > =

Supported Fields

Test Cycle

Field Name

Field

Type

Description

 

Project Key

testcycle.projectkey

string

Test Cycle Project Key. Example: testcycle.projectkey = 'PJ'

 

Key

testcycle.key

string

Test Cycle Key. Example: testcycle.key = 'PJ-TR-1'

 

Folder Path

testcycle.folderpath

string

Test Cycle Folder Path. Example: testcycle.folderpath = '/Folder/Sub Folder'

 

Priority

testcycle.priority

string

Test Cycle Priority Name. Example: testcycle.priority = 'High'

 

Status

testcycle.status

string

Test Cycle Status Name. Example: testcycle.status = 'To Do'

 

Assignee

testcycle.assignee

string

Test Cycle Assignee Name. Example: testcycle.assignee = 'John Doe'

 

Reporter

testcycle.reporter

string

Test Cycle Reporter Name. Example: testcycle.reporter = 'John Doe'

 

Component

testcycle.component

array

Test Cycle Component Name. Example: testcycle.component = 'Some Component'

 

Label

testcycle.label

string

Test Cycle Label Name. Example: testcycle.label = 'L1'

 

Sprint

testcycle.sprint

string

Test Cycle Sprint Name. Example: testcycle.sprint = 'Board / Sprint'

 

Fix Version

testcycle.fixversion

string

Test Cycle Fix Version Name. Example: testcycle.fixversion = 'Version 1'

 

Automated

testcycle.isautomated

boolean

Test Cycle is Automated or Manual. Example: testcycle.isautomated = true

 

Planned Start Date

testcycle.plannedstartdate

date

Test Cycle Planned Start Date (Format: 'dd/MMM/yyyy'). Example: testcycle.plannedstartdate = '01/Jan/2024'

 

Planned End Date

testcycle.plannedenddate

date

Test Cycle Planned End Date (Format: 'dd/MMM/yyyy'). Example: testcycle.plannedenddate = '01/Jan/2024'

 

Archived

testcycle.isarchived

boolean

Test Cycle is Archived or Not. Example: testcycle.isarchived = true

 

Test Case Count

testcycle.testcasecount

number

Count of test cases linked with Test Cycle. Example: testcycle.testcasecount = 5

 

Defect Count

testcycle.defectcount

number

Count of Defects linked with Test Cycle. Example: testcycle.defectcount = 5

 

Custom Fields

testcycle.qcf_id

As per the custom field type

The custom fields will be displayed as per the custom fields configured for the project under QMetry > Configuration > Project Configuration > Custom Fields > Test Cycle.

Examples

Example 1

Issue IN qtmj_getBugLinkedWithTRLike("projectkey = 'FIT'", "testcycle.priority = 'High'")

Example 2

Issue IN qtmj_getBugLinkedWithTRLike("projectkey = 'FIT'", "testcycle.priority IN ('High', 'Low') AND (testcycle.status IN ('To Do', 'Done') OR testcycle.fixversion = 'Ver 1')")

Example 3

Issue IN qtmj_getBugLinkedWithTRLike("projectkey = 'FIT'", "testcycle.key IN ('QTM-TR-1', 'QTM-TR-2')")