Filtering User Storys through 2 issueFunction

Question

Hello,

i have a (maybe weired) Question :)

Is there a possibility to set up a Filter to get only particular User Storys:

- The User Story inherits a Testcase

- This Testcase is part of a Testplan

What i need is: I need all User Storys, wehere the Testcases are part of a particular TestPlan.
Is this maybe possible with two issueFunctions?

How could the JQL be seems like? Somthing like: 
issuetype = Story AND issueFunction in linkedIssuesOf("issuetype = Test AND issueFunction in linkedIssueOf(TestPlan = 123))

Thanks in advance

Crystelle S · Answer

Or maybe avoid the nested function altogether and save the second bit as a filter and just write it

issuetype = Story AND issueFunction in linkedIssuesOf('issuetype = Test AND filter = ""')

Also there is this thread that might help - https://community.atlassian.com/t5/Marketplace-Apps-Integrations/ScriptRunner-nested-query-select-issues-from-epics-linked-to-an/qaq-p/777719

Talks about putting in "\" to escape the quotes of a nested function.

Crystelle S · Answer

It's going to sound really weird but give this a try - swap out your quotes to single quotes:

...issueFunction in linkedIssueOf('issuetype = "Test Plan" AND key = 1238')")

This sometimes works for me, I can't explain it (maybe a developer could since I am sure it has something to do with how the program reads the expression but that's not me :)  )

unknown · Answer

All of these are Ticket Types respectivly issuetypes.

My JQL from above do no work, because i get i Error Message in Terms of Syntax:
--> Error in the JQL Query: Expecting ')' or ',' but got 'issuetype'. (line 1, character 109)

I tried also this one:

issuetype = Story AND issueFunction in linkedIssuesOf("issuetype = Test AND issueFunction in linkedIssueOf("issuetype = "Test Plan" AND key = 1238")")

And again the same Error:

--> Error in the JQL Query: Expecting ')' or ',' but got 'issuetype'. (line 1, character 109)