Jira automation - filter variable by user

[JEFFREY SCHNEIDER]

I have an automation that starts with a lookup - then a variable is created giving me the total number of issues in the lookup.

I'm using the variable to populate an HTML table sent in email. I have ten columns in this email, meaning 10 lookup/variable combinations.

I have 12 users I'd like to separate in the email into individual tables. Is is possible to add a filter to each table so that I don't need to create 12 variables per initial variable.

[Vijay Dadi]

Hello @JEFFREY SCHNEIDER ,

If your lookupIssues contains a field which holds your intended values you can do this without creating multiple variables. For example, reporter field which stores submitters account id.

You can use branch with smart values step to traverse through your array of outputs and you need not create multiple variables for the same.

as shown in the picture below, within the branch, we can perform your intended operations. Hope this helps!

Vijay

[JEFFREY SCHNEIDER]

@Vijay Dadi - I'm not quite sure how creating branches would work in this use case. I currently have 10 separate lookup actions (each looking at different transitions) each with a corresponding variable to provide a count of issues in the lookup. What I'm trying to do is (in the most efficient way possible) sort each of those lookups by initiator, or assignee (either would work for my case) so that I can provide a table in an email output. 

Trigger - Scheduled

Lookup - FilterA

Create - VarA

Lookup - FilterB

Create - VarB 

Etc. Etc. Etc.

Email - Table = User1 -VarA, VarB, VarC, User2 -VarA, VarB, VarC, User3 -VarA, VarB, VarC. Etc. Etc. Etc.

[Vijay Dadi]

Why can't you merge your FilterA and FilterB etc etc into filter and have only one lookup issue?

[JEFFREY SCHNEIDER]

Theoretically, I could merge some of the different filters with a handful of "or" conditions, but in the end I need to filter by transition and user. 

Each lookup is filtered on a transition. Each Var is providing a count. I'm hoping there is a way to add a filter to each table, so I don't need to create 12 groups of lookup/Var - one for each user.