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

[Thomas Berg]

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.