JQL to show linked issues and their subtasks

[Sarah Jones]

I want to see all tasks that are linked to a story, a the subtasks of those tasks. (hope that makes sense)  

I have tried: 

project = X AND issue in linkedissues(X-1795) AND issueFunction in subtasksOf(X-5315, X-5423)

But ScriptRunner doesn't like this and I can't see why, its probably something simple.... long day! is this even possible?

[Tim Perrault · Accepted solution]

Hi @Sarah Jones 

Try this:

project = X AND issue in linkedissues(X-1795) OR issueFunction in subtasksOf(X-5315, X-5423)

Thanks,

Tim

[Sarah Jones]

Hi, Tim, nope it doesn't like that either, same error as before

Error in the JQL Query: Expecting operator before the end of the query. The valid operators are '=', '!=', '<', '>', '<=', '>=', '~', '!~', 'IN', 'NOT IN', 'IS' and 'IS NOT'.

[Tim Perrault]

Sorry about that:

project = X AND issue in linkedissues(X-1795) OR issueFunction in subtasksOf("key in (X-5315, X-5423)")

Thanks,

Tim

[Sarah Jones]

@Tim Perrault  Thank you so much!! I've been staring at this for too long hehe