Find Stories associated with epics from another project category

[Luiz Gregorio]

Hello all, I am struggling with a JQL to find the following scenario:

I have 200 projects within  project category A

I have other 800 projects within project category B

I need to see all stories created under projects from category B which are associated to Epics (epic link) created within category A.

No matter other filters.

Can you help me? I have tried using linkedIssuesOf sort of JQL but I am not getting the results I expect.

BTW, I have ScriptRunner plugin up and running

[Tarun Sapra · Accepted solution]

Hello @Luiz Gregorio 

With Script runner it's pretty starightforward

I need to see all stories created under projects from category B which are associated to Epics (epic link) created within category A.

issueFunction in issuesInEpics('category = A') and type = story and category = B

[Luiz Gregorio]

@Tarun Sapra thank you very much, I have tried much more complex solutions, never thought of something so simple.

Worked perfectly.

Thank you again!!