/
qtmj_getStoryHavingTCExeLike

qtmj_getStoryHavingTCExeLike

Description

This function returns a list of stories where any of their test case executions match 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 case filters.

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

  • Filter applies to all executions.

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'

 

Assignee

execution.assignee

string

Execution Assignee Name. Example: execution.assignee = 'John Doe'

 

Planned On

execution.plannedon

date

Execution Planned On Date (Format: 'dd/MMM/yyyy'). Example: execution.plannedon = '01/Jan/2024'

 

Has Defect

execution.hasdefect

boolean

Execution Has Defect or Not. Example: execution.hasdefect = true

 

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'

 

Custom Field

execution.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 Execution.

Examples

Example 1

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

Example 2

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