qtmj_getStoryLinkedDirectlyWithTRLike

Description

This function returns a list of stories linked directly to the test cycles 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.

  • By default, the filter applies to both Active and Archived test cycles.

Supported Operators

  • Jira Operators -IN NOT IN

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

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

array

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'

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'

Automated

testcycle.isautomated

boolean

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

Archived

testcycle.isarchived

boolean

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

Test Case Count

testcycle.testcasecount

number

Count of Testcases 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_getStoryLinkedDirectlyWithTRLike("projectkey = 'FIT'", "testcycle.priority IN ('High', 'Low') AND (testcycle.status IN ('To Do', 'Done') OR testcycle.fixversion = 'Ver 1')")

Example 2

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

Publication date: