Query for any Stories linked to an Epic with differing Account field

Question

So Epics that have Account = (this value) and any Story linked to that Epic where Account != (this value).

Or even fancier: Show me any Stories that have a different Account value than their parent Epics.

I do have Script Runner.

Thanks in advance - I've spent hours on this and figured I'd ask the Community!

Efrat Noam · Answer

Can you think about alternative which will work for Next-gen projects (Jira cloud)?

Petter Gonçalves · Answer

Hello Scottie,

Using JQL functions for Scriptrunner, I believe the following query should work to return all the Stories where you have a specific different value for the account field than their respective Epic:

issueFunction in issuesInEpics("account = thisvalue") and account != thisvalue

Unfortunately, it is not possible to perform this verification without defining a specific value for one of the account fields, so I don't think you will be able to perform the fancier way you mentioned using only Scriptrunner.

Let us know if this information helps.