Jira automation - filter variable by user

Question

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.

JEFFREY SCHNEIDER_cebiol · Answer

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.

Vijay Dadi_b69v44 · Answer

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

JEFFREY SCHNEIDER_cebiol · Answer

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