/
qtmj_getStoryLinkedWithTCLike

qtmj_getStoryLinkedWithTCLike

Description

This function returns a list of stories linked to test cases based on the specified test case 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 case filters.

  • By default, the filter applies to both Active and Archived test cases and all versions of the test cases.

Supported Operators

  • Jira Operators -IN NOT IN

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

Supported Fields

Test Case

Field Name

Field

Type

Description

 

Project Key

testcase.projectkey

string

Testcase Project Key. Example: testcase.projectkey = 'PJ'

 

Key

testcase.key

string

Testcase Key. Example: testcase.key = 'PJ-TC-1'

 

Folder Path

testcase.folderpath

string

Testcase Folder Path. Example: testcase.folderpath = '/Folder/Sub Folder'

 

Priority

testcase.priority

string

Testcase Priority Name. Example: testcase.priority = 'High'

 

Status

testcase.status

string

Testcase Status Name. Example: testcase.status = 'To Do'

 

Assignee

testcase.assignee

string

Testcase Assignee Name. Example: testcase.assignee = 'John Doe'

 

Reporter

testcase.reporter

string

Testcase Reporter Name. Example: testcase.reporter = 'John Doe'

 

Component

testcase.component

string

Testcase Component Name. Example: testcase.component = 'Some Component'

 

Latest Execution Result

testcase.latestexecutionresult

string

Latest Execution Result Name of Test Case. Example: testcase.latestexecutionresult = 'Pass'

 

Label

testcase.label

string

Test Case Label Name. Example: testcase.label = 'L1'

 

Sprint

testcase.sprint

string

Test Case Sprint Name. Example: testcase.sprint = 'Board / Sprint'

 

Fix Version

testcase.fixversion

string

Test Case Fix Version Name. Example: testcase.fixversion = 'Version 1'

 

Automated

testcase.isautomated

boolean

Test Case is Automated or Manual. Example: testcase.isautomated = true

 

Archived

testcase.isarchived

boolean

Testcae is Archived or Not. Example: testcase.isarchived = true

 

Latest Version

testcase.islatestversion

boolean

Filter by Latest Version of Test Case or All Versions. If filter is not provided then all Versions are considered. Example: testcase.islatestversion = true

 

Custom Fields

testcase.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 Case.

Examples

Example 1

Issue IN qtmj_getStoryLinkedWithTCLike("projectkey = 'QTM'", "testcase.priority = 'High'")

Example 2

Issue IN qtmj_getStoryLinkedWithTCLike("projectkey = 'QTM'", "testcase.priority IN ('High', 'Low') AND (testcase.status IN ('To Do', 'Done') OR testcase.label IN ('Mobile', 'Web'))")

Example 3

Issue IN qtmj_getStoryLinkedWithTCLike("projectkey = 'QTM'", "testcase.key IN ('QTM-TC-1', 'QTM-TC-2')")