JQL: check if issue's epic meets condition

[Arthur]

I want to set up a custom query for Card Colours in Rapid Boards on GreenHopper. I'd like to implement the following logic:

If epic (that a story is linked to) is of certain state (say, OPEN), assign colour to this story. So, I want to indirectly check the state of another (linked) issue (epic) to determine the colour of this issue (story).

I'm talking about an epic as an issue type here, one that can be used not only in Scrum Board, but also on Kanban Board.

Can this be done using JQL?

[Jeff Curry · Accepted solution]

Looks like there is an outstanding feature request for this:

https://jira.atlassian.com/browse/JRA-25640

Afraid I don't see a possibility to do this outside of the above feature request

[joehardin]

Ancient thread, but for people reading this now: that feature request referenced above doesn't correlate to the poster's question since epic relationships are a different sort of "link type"

[Nicholas Muldoon]

Hi Arthur,

The Script Runner issueFunction add-on has some neat functionality you could leverage for this. I've written up how we use it for highlighting dependencies in Using the Epic Workflow in GreenHopper.

From your description you may want to use something similar to:

issueFunction in linkedIssuesOf(“issuetype = Epic and status = Open")

Give that a try and let me know if it solves your problem.

Thanks Arthur,
Nicholas Muldoon

[Arthur]

Hi Nicholas, this sounds very promissing. Can it be used with JIRA ondemand though?

[JamieA]

Unfortunately not.