JQL to query an attribute on the Epic of a given issue

Thomas Berg_qtkv5v

Trying to write a JQL query for setting card colors on each issue.

Every issue is linked to an Epic, and every Epic has a Category selected (single-select picklist).  I want to define the card color for each issue based on the Category of its related Epic.

Played around with both issue.property and issuefunction after doing a bunch of searching, and I'm unsure if my ask is even possible without subquery functionality.  Hopefully someone can prove me wrong!

Petter Gonçalves

Hello Thomas,

Welcome to Atlassian Community!

I'm not sure if the Card colors query in board recognizes JQL parameters from plugins, however, you can try the following steps:

- Install ScriptRunner plugin

- Navigate to your board > Board settings > Card Colors > Select Queries

- Write the following query for each category you want, selecting the colors as you need:

issueFunction in issuesInEpics("category = XYZ")

For more information about it, check the documentation below:

- Script JQL Functions

Please, let me know if it works for you.