nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Aggregate Children Based on a Condition

Todd_Levinson

I'm trying to create a column in a structure that joins the summaries of each issue in an epic based on the sprint each issue is in. For example, I want a comma separated list of all the issues in "Sprint 1". I see how to use an aggregation function to do this for all the issues, but can't figure out if there is a way to aggregate based on a conditional statement.

Accepted answers

Egor Tasa [ALM Works]

Hi Todd,

You can aggregate things conditionally, so the formula you are looking for is probably:

JOIN#subtree{IF(sprint="Sprint 1", summary)}

Note that it works if only one sprint at a time is assigned. If issue is a part of several sprints you'd have to use IF(SEARCH("Sprint 1", sprint), summary)

Please, let me know if this helps.

Regards,
Egor Tasa

ALM Works

All comments

Egor Tasa [ALM Works]

Hi Todd,

You can aggregate things conditionally, so the formula you are looking for is probably:

JOIN#subtree{IF(sprint="Sprint 1", summary)}

Note that it works if only one sprint at a time is assigned. If issue is a part of several sprints you'd have to use IF(SEARCH("Sprint 1", sprint), summary)

Please, let me know if this helps.

Regards,
Egor Tasa

ALM Works

Todd_Levinson

Thanks so much. This works. In the documentation it uses semi-colons between arguments in the IF function. Are commas and semi-colons interchangable?

Egor Tasa [ALM Works]

Yes, you can use either comma or semicolon.

Regards,
Egor

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

addon-com.almworks.jira.structure

aggregate