JQL epics found in one project that aren't in another

[Talha Shah]

I have a reference jira project called project A that has a masterlist of epics. Project B is a project with a few epics that overlap with project A (they have the same summaries but are distinct and unique epics, ie they have different issuekeys). I would like to execute a Jira query that checks all epics that exist in the reference project A that dont exist within project B. This JQL query should only compare the summaries of the epics for similarity. Is there any way to implement this functionality?

[Mark Segall · Accepted solution]

Hi @Talha Shah - You're not going to natively get that from JQL.  However, assuming you don't have empty Epics, you could create a quick dashboard where you do something like this:

Filter

• Project in (projectA,projectB)

Two-Dimensional Filter Gadget

• X-Axis = Project
• Y-Axis = Epic Link

All Epics will show in this view and any where ProjectB has 0 means that the Epic doesn't exist.

Your other option would be to simply execute a query like this:

project in (projectA,projectB) AND issueType = Epic

Then download the results to a spreadsheet and get the total there.

[Hamza Chundrigar]

This is not possible (with JQL) as a native function out of the box. But you could use an add-on like ScriptRunner and execute an expression  to search for the same.