JQL query for extracting tests linked to number of requirements

[jui kulkarni]

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?

[Carlos Garcia Navarro]

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]

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]

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]

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