Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


How to filter a structure view based on a derived formula

There is a structure showing the status of issues in the current sprint, summarising the issue status at the parent level. It includes a number of formulae including one which interrogates combinations of sub-tasks to derive which contributor is responsible for the next action in the complex workflows. That derived person is shown *at the parent level* so that the view is not cluttered with sub-tasks.

Given that derived contributor/user, there are filters so that team members can view just their content/actions.

However, we have quite a number of contributors who are not in the team, and I have been trying to devise a filter which will show all NON-team members with a next action due.

Using the filter automation, I can select individual derived users very easily:

Attribute: Formula (my derived value)

Operator: is equal to

Value: Fred


That addresses the match-a-single-user question, but I haven't discovered a way to ask "is not in the list (Fred, Bill, Jim, Helen...) so I can identify "Helpers".

Exploring the use of <assignee> in membersOf("MyTeam") failed because my derived/formula user is not a recognised attribute in any context.

So...created another formula which has a CASE statement to list all MyTeam members, so I can derive "Team" or "Helper", and then use this in a filter to select/show all work to be actioned by contributors outside the team in a single, multi-user view.

Is there a way of using <in membersOf( )> so that I have less housekeeping should my team composition change? That would be more elegant...



1 answer

0 votes
David Niro
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Mar 28, 2023

Hello @Paul Doman ,

As of Structure v7, you can use embedded queries in formulas.

One of the examples we share is:

// Collect total story points from all sub-issues assigned to members of Team2 group, unless the stories are under folder "Special"
SUM { 
    IF JQL { assignee in membersOf("Team2") } :
    IF NOT SJQL { descendant of folder("Special") } : 

You should be able to use something like:

IF JQL {assignee in membersOf("yourteam")}:
ELSE: "Helpers"

Please let me know if it helps.


Thanks @David Niro 

I have achieved some success with "membersOf", and this topic is under control for me. Embedded queries have quite a presence in my formula library.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events