Need suggestion to build a query to get all the test cases linked to Jira stories that are in turn l

[Krishnan Gs]

I am looking for something like this:

issuetype = test where the test is linked to story that is linked to stories ( S1, S2, S3 )

S4 linked to S1, S2 and T40, T41, T42

S5 linked to S1, S3 and T50, T51

S6 linked to S2 and T60

Output:

S1 -> S4, S5 -> T40, T41, T42, T50, T51

S2 -> S4, S6 -> T40, T41, T42, T60

S3 -> S5 -> T50, T51

or

T40 -> S1, S2

T41 -> S1, S2

T42 -> S1, S2

T50 -> S1, S3

T51 -> S1, S3

T60 -> S2

[Crystelle S]

If you have scriptrunner you can use recursive search. Other than that I have not seen this done. 

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/issue-links