Scheduled automation to update the custom fields on the selected issues

[Kavitha]

Hi Everyone, 

I need some suggestion to solve my usecase.

Requirement:

Get the total test execution time on every month

In my JPD initiative - I have the following custom fields:

a. Functional Test Execution Time

b. Operational Test Execution Time

c. Test project ID

Actions:

1. I need to run an action on a monthly bases - Say every first Monday 2PM on a list of selected issues - For ex. Select all the issues if "Test Project ID" is not empty

2. Loop thru each issue from the above list (In this loop, I have to update the total time for Functional and Operational Test execution)

2.1 - For each issue, call an external API  to get all the test cases associated with this issue key

2.2. The test cases may be of any category (Functional, Operational etc) and there is a field for the time spent

2.3 Get the total spent based on each category and update the total back on the initiative

My approach:

1. Schedule an automation rule to run on first Monday 2PM - JQL used to select all the initiatives with "Test Project ID"

2. Reset the existing total count

3. Loop thru each issue 

4. For each issue, call the external api to get the test cases with the execution time

5. Get the total execution based on the category

6. Update the issue back with the total

As this approach required nested loops (Loop thru each issue and for each issue get the test execution time), I am not sure how to use the Advanced branching and Loopup issues ( I am not familiar with {{lookupIssues}} or getting any aggregation like that)

Any help will be highly appreciated!

Kavitha

[Tanguy Crusson · Accepted solution]

Hi Kavitha, I think you should try the community group for Automation, here: https://community.atlassian.com/t5/Atlassian-Automation/ct-p/automation

[Kavitha]

Hi Tanguy Crusson

Thanks for your suggestion, unfortunately, I am not able to get anything to resolve my request.

Thanks,

Kavitha