When you are adding a JIRA filter into Confluence, can you display the values of a of their parent?

[Gaston_Motola]

I'm trying to put a JIRA filter in Confluence, which I've done plenty of times, however for this particular case I need to display in one of the columns, two fields that are not located in the the issue itself, but instead those fields are located on the parent (or Epic).

So I have an Epic called "My_Epic" and I have issues inside "My_Epic", there are two custom date fields in "My_Epic" (let's call it date1 and date2) which are not available in the issues only on the Epic that they are part of, but I do want to display those dates on that filter. so it would look something like this:

Issue                 Epic Link                   Date1                   Date2

My_issue1          My_Epic             My_Epic.date1          My_Epic.date2

My_issue2          My_Epic               My_Epic.date1         My_Epic.date2

Other_Issue       Other_Epic            Other_Epic.date1    Other_Epic.date2

When you click Edit on the filter in Confluence you have a "Display Options" menu (I'm attaching a picture of it) and on the "Columns to display" I want to add the dates from the Epic Link, not from the issue itself.

Hopefully I was able to explain what I'm trying to do. 

[Katerina Kovriga {Stiltsoft} · Accepted solution]

Hi @Gaston_Motola ,

Try to use the Table Transformer macro from the Table Filter and Charts for Confluence app.

Use two Jira filters to get two separate tables (the first one for the Issue data, the second one for the Epic data) and wrap them into the Table Transformer macro:

Now join (or merge) your tables by the Epic Name or Epic Link. Choose the Lookup tables and match your tables by the similar column:

Save the result and get the required table:

[Gaston_Motola]

Thanks for that, I think that would usually do the trick, however in my case I can't match the record by Epic Link or Epic Name. 

I generated my two filters, one for issues, and one for epics, but here's the problem; on the issues filter I have access to the Epic Link field (which is the Epic that the issue belongs to), and on the Epic filter I have access to the Epic Name field (which is the Epic itself), those two are different variables so they can't be used on the "Match record by:"  drop down menu (even though they contain the same information). Furthermore, the Epic Link field is empty on the Epics , since those are not linked to any other. 

What I need is to make the Epic Link and Epic Name be just the same variable so I can use it to Match Records By. Any pointers or suggestions? Thanks again.

[Katerina Kovriga {Stiltsoft}]

So, as I see, you have the Epic Link column in your Issue table and the Epic Name column in your Epic table, but the information there is identical.

For this case you need to choose the Custom Transformation in the Table Transformer macro and insert the following SQL:

SELECT T1.'Key', T1.'Summary', T2.'Epic Name', T2.'Date 1', T2.'Date 2' FROM T1 JOIN T2 ON T1.'Epic Link' = T2.'Epic Name'

At first you choose which columns to show (not to duplicate the Epic Link and Epic Names columns) and in the second part you join (merge) your tables by the reqiured columns.

[Gaston_Motola]

Yep this took care of exactly what I was needing! Thank you @Katerina Kovriga {Stiltsoft}  very much!

[Sachin]

Hey Gaston,

You cannot add any other additional fields other than the Default Jira Columns to display in Jira issue macro. But I think it might be possible as per -  How to Change Default Jira Columns to display in Jira issue macro