Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL query for extracting tests linked to number of requirements

jui kulkarni October 2, 2021

I would like to get a list of tests which are linked to more that 10 requirements. Can someone help with JQL query for this please?

1 answer

0 votes
Carlos Garcia Navarro
Community Champion
October 2, 2021

Hi @jui kulkarni , Can you please provide more details? Are the 'requirements' and 'tests' issue types in Jira that are linked to each other with a specific relationship? Thanks

jui kulkarni October 2, 2021

Hello @Carlos Garcia Navarro,

We have a requirement project (issue type: requirement) and a test project (issue type: test)

Users create test cases and link requirement to test cases. There are few test cases where users linked more that 5-7 requirements to a single test case.

We want to query all such test cases.

Carlos Garcia Navarro
Community Champion
October 4, 2021

I see, thanks! If you have Adaptavist Scriptrunner you could use the linkedIssuesOf function as described here:

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html

E.g.,

issueFunction in linkedIssuesOf("status = Open", "blocks") 
Govind Khatri
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 31, 2024

@Carslos Garcia Can you help me which queries to identify the Test case which are not linked to Artifacts

Suggest an answer

Log in or Sign up to answer