How can I filter through lookupIssues with if statement

[Vitali Fedarau]

I need to create a report with Jira automation, that will combine tasks by epics, like that:

Epic 1:

Task 1

Task 2

Epic 2:

Task 3

Task 4

I have gon through A LOT of articles and made A LOT of testing, but the best possible result I see the usage of filtering through lookupIssues. I have used this article as basis for that: https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588

In my head, it should work in some way like this:

{{#lookupIssues}}
{{ #if({{equals(issue.epic.key,"EPIC-1"))}}}}

Epic 1 sumary
<{{url}}|{{key}} {{summary}}>
{{ /}}
{{/}}

{{#lookupIssues}}
{{ #if({{equals(issue.epic.key,"EPIC-2"))}}}}
Epic 2 summary
<{{url}}|{{key}} {{summary}}>
{{ /}}
{{/}}

So kinda filtering through epic key should allow to show only those tasks who are part of EPIC-1 or EPIC2. Unfortunately, that doesn't work at all.

Does anyone know what is the good way of doing this?

[Alex Koxaras -Relational-]

Hi @DOMENICO TROISI 

You can use Jira automation to do that. Have you tried that already?