Query a field in an epic but from Story

Hi, I have a requirement like this.
Create an eazybi report with the list of stories whose epics have a particular field value.
I tried to create a new dimension as below, but can’t seem to find the new dimension created in reports but available in the eazybi account.

name = “Epic QBR”
source_dimension = “QBR”
issue_key_column = “customfield_21300”
group = “Linked issue dimensions”

customfield_21300 is the field id of that custom field, I tried using issue_id_column/issue_key_column as well.

Appreciate the help

Hi @aswinir,

Link field dimensions work only for specific issue fields listed in the documentation: Issue link field dimensions.

Passing down the custom field “QBR” value from epic to its children so you could filter the report by epic QBR is slightly different.

In this case, you should create a JavaScript calculated custom field like below (the code is intended for eazyBI advanced settings):

[jira. customfield_21300_e]
name = "Epic QBR" 
data_type = "string"
dimension = true
update_from_issue_key = "epic_key"
javascript_code = '''
if(issue.fields. customfield_21300 ) {
   issue.fields. customfield_21300_e = issue.fields. customfield_21300;

Note this works only for a single select custom field. Please see the documentation for more details on this example: JavaScript calculated custom fields - Inherited field dimension.

Zane / support@eazyBI.com

Thanks Zane. I will try this in a while and let you know if any issues