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; } } }

Active Sprints in Structure Formula

Poojaa Sudhakaran

Hello There,

I have a use case where I need to count the stories in open sprints in Structure. I tried using Structure Formula but I'm receiving an error when I'm trying to put "sprint in openSprint()".

My Use Case:

a. Structure will list all the stories in the project

b. Stories are grouped by Teams

c. One column gives the Team wise count on active sprint, another column that shows team wise count on closed sprints

I cannot use Filter option in structure since I have to display both closed and active sprint in the same view.

Is there a generic way to mention active sprints in Structure Formula column instead of selecting each sprint?

Regards,

Poojaa

Accepted answers

Egor Tasa [ALM Works]

Hi Poojaa,

At the moment Structure Formula language cannot reference JQL functions and statements, though we have plans to eventually integrate this. Also, formulas cannot access sprint attributes like start, end dates, and status, except if they are made an issue's attributes. So potentially you can create a scriptable field that shows if the issue is in an open or closed sprint, and then formulas will be able to count issues based on their sprint status.

Sorry for the inconvenience.

Egor Tasa

ALM Works

All comments

Egor Tasa [ALM Works]

Hi Poojaa,

Sorry for the inconvenience.

Egor Tasa

ALM Works

Poojaa Sudhakaran

Thanks @Egor Tasa [ALM Works]

I was able to achieve this after creating a script field and putting it in the formula.

Still it would be great if we can have jql support in Structure formula.

Regards,

Poojaa

Egor Tasa [ALM Works]

Yes, Poojaa, we have such plans.

Regards,
Egor

Aasha_g5w76o

@Poojaa Sudhakaran - Could you please help to achieve this in stucture?

One of my user requesting the same and unfortunately i couldnt?

Aasha_g5w76o

@Poojaa Sudhakaran - Pooja surething. Can i share my screen and show you this it would be easy for you to take a look.

Please let me know your convenient time

Dave Rosenlund _Trundl_

Hi @Poojaa Sudhakaran & @Aasha. There's some news that's relevant to this thread.

In case you missed it, ALM Works recently released Structure 7. The keystone feature is a major update to the Structure Formulas language, Expr.

Expr 2.0 includes major improvements that make it easier to extract project data from Jira and use it in creative ways in your reporting. If you want to learn more, this article will get you started.