qtmj_getStoryHavingAnyTCLatestExeLike

Description

This function returns a list of stories where any of their latest test case executions matches the specified execution 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 execution filters.

• The filter applies to both Active and Archived test cases.

• The filter applies to latest test case execution only.

Supported Operators

• Jira Operators -IN NOT IN

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

Supported Fields

Test Execution

Field Name

Field

Type

Description

Environment

execution.environment

string

Execution Environment Name. Example: execution.environment = 'Dev'

Build

execution.build

string

Execution Build Name. Example: execution.build = 'Beta'

Execution Result

execution.result

string

Execution Result Name. Example: execution.result = 'Pass'

Executed By

execution.executedby

string

Executed By Name. Example: execution.executedby = 'John Doe'

Executed On

execution.executedon

date

Executed On Date (Format: 'dd/MMM/yyyy'). Example: execution.executedon = '01/Jan/2024'

Examples

Example 1

Issue IN qtmj_getStoryHavingAnyTCLatestExeLike("projectkey = 'FIT'", "execution.result IN ('Blocked', 'Failed')")

Example 2

Issue IN qtmj_getStoryHavingAnyTCLatestExeLike("projectkey = 'FIT'", "execution.result IN ('Blocked', 'Failed') AND execution.environment IN ('Production', 'Pre-Production')")