qtmj_getStoryHavingAllTCLatestExeLike

Description

This function returns a list of stories where every latest execution of their linked test cases 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: The Jira Space key for which you will retrieve the stories.

    • Filter-based arguments refer to test cycle filters.

    • Filter-based arguments refer to test execution filters.

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

  • The filter applies to latest test case execution only.

  • Use the optional cacheBust parameter to ensure the JQL function runs a fresh query by providing a unique value (for example, a timestamp). If not used, Jira may return cached results when the query remains unchanged.

Supported Operators

  • Jira Operators -IN NOT IN

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

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 Date

execution.executeddate

date

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

Examples

Example 1

WorkItem IN qtmj_getStoryHavingAllTCLatestExeLike("projectkey = 'AJT'", "execution.result IN ('Blocked', 'Fail')", "cacheBust = '18/May/2026 14:59'")

Example 2

WorkItem IN qtmj_getStoryHavingAllTCLatestExeLike("projectkey = 'AJT'", "execution.result IN ('Blocked', 'Fail') AND execution.environment IN ('Production', 'Pre-Production')", "cacheBust = '18/May/2026 15:00'")

In this section:
© 2026
Publication date: