How to filter a structure view based on a derived formula

[Paul Doman]

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...

Thanks

[David Niro]

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") } : 
       storyPoints
}

You should be able to use something like:

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

Please let me know if it helps.

Best,
David

[Paul Doman]

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.