Extract the Project Lead(s) for list of issues with bad/inactive assignees

Morten Stensgaard
Contributor
November 20, 2023

Hi Community.

Is there any way to iterate over all the issues in Jira, and then extract the Project Lead(s) for the individual issue - but only get/notify the Project Lead once per project?

Example:

1) Search for all issue with a bad/inactive assignee

Result: (ABC-1, ABC-2, BCA-1, BCA-3 etc)

2) Get the List of Project Leads for those issues

Result: Can be done with Lookup issues of smart value {{issue.project.Project Lead.emailAddress}}

3) Notify Project Lead(s), that they should ensure to have correct assignee or un-assign the issue
Problem: The above logic will generate MANY emails times per Project Lead(one per issue)

 

Expected result:

Only notify the Project Leads ONCE, although the have multiple issues with inactive Assignees.

 

Even better:

Notify Project Lead once with the exact LIST of issues with inactive Assignees


Is there a way for filtering out duplicate records here? (Or stop the iteration at first issue per project)

 

Hope you can help here.

 

Thanks in advance

Morten

1 answer

0 votes
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 20, 2023

I am not on cloud so I dont have these functions but from what I have read in these forums, your solution will look like below.. once your step 2 has email addressess, do a distinct and save the list in a variable. Then do advanced branching and run JQL again for issues but with additional project lead as criteria,  then you bulk process to send 1 email but with their list of issues.

Lets wait for experts to refine the logic.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events