How to create filters for multiple projects

Questions & Answers
, ,
1

Good morning,
Please, I need help creating a filter for my project - there is a print of it in the picture attached.

In this example, there a “father” project named GDOCORP and inside each Jira of it there another associated Jira, which is like a “son” Jira.

In this table example, when I select the fields and set up them in the pages, this filter refers to each one of the Jira “sons” and not to GDCORP.

What I need is that I could filter the fields related to GDCORP and not the “sons” Jiras.

Thank you!

EazyBI - Multiple projects
EazyBI - Multiple projects1366×796 259 KB

2

Hi @Danilomz ,
If your fields are single-select fields, then you can filter your children’s issues by creating an inherited field dimension, see an example here: JavaScript calculated custom fields

best,
Gerda // support@eazybi.com

3

Hello Gerda,
Thanks for your reply. I have no formula or coding ability, and I have just checked that this topic is really hard to understand or apply in my case.

Is that possible to apply this filter in an other way that would no need to apply a formula?

Thank you!

4

Hi @Danilomz ,
The solution works only for single select fields and depends on your Issue hierarchy. If it is Epic hierarchy, then the solution would be to add this code to eazyBI advanced settings:

[jira.customfield_NNNNN_e]
name = "Epic custom field name" 
data_type = "string"
dimension = true
update_from_issue_key = "epic_key"
javascript_code = '''
if(issue.fields.customfield_NNNNN ) {
   issue.fields.customfield_NNNNN_e = issue.fields.customfield_NNNNN;
}
'''
  1. Where NNNNN is your Parent custom field ID
  2. And update_from_issue_key identifies that the value is passed to epic children. If you are using, e.g., Advanced Roadmap (previously Portfolio) then you may want to see this solution on how to get the level:

best,
Gerda