Help With Query to find User stories without a linked zephyr test

[michael mittiga]

Trying to create JQL query that will identify all User Stories for a specific fixversion that do not have a zephyr test ticket linked to them.

Nothing seems to work using the jira issue navigator or Script Runner

This Query is timing out on me in Script Runner:

project = ABCD AND fixVersion ~ "*1.22" AND issuetype in ("User Story", Bug) AND issueFunction not in linkedIssuesOf("issuetype = Test")

Any help or suggestions would be appreciated. 

[Divya Shree]

Hi Michael,

Welcome to Atlassian Community! Here you are trying to fetch all User Stories and Bugs from a specific FixVersion that do not have a Zephyr Test linked. The current query using issueFunction not in linkedIssuesOf(...) is timing out because it's too heavy without a specific link type. I suggest the below query:

project = ABCD
AND fixVersion ~ "*1.22"
AND issuetype in ("User Story", Bug")
AND issueFunction not in linkedIssuesOf("issuetype = Test", "tests")

Make sure to replace "tests" with the actual Zephyr test link type used in your instance.

Let me know if it worked!