Jira Automation: How to make Epic status change by percentage of completed stories of epic

[Jonathan Chatfield]

Hello,

I have automated the process of story's status automatically changed at a certain percent of completed of sub-tasks status to Done. I am now looking at automatically updating the epic status progress from the completion of percentage of the automated story status with Done to change the Epic status to In Progress then after all the automated stories statuses are in  Done Status then put the Epic status to Done status as well. My To Do status category is Backlog. 
This is a project plan so we are going to have every task be a sub-task and those tasks live in Stories then every story is under a umbrella of a epic. Here is a example of that setup! 

I do not have the function LookupIssue and I have been told that I will need to do a process that uses REST API. I do not know much about this process but I am excited to hear from anyone out there! =D

[Bill Sheboy]

Hi @Jonathan Chatfield 

You describe your automation rules do not have the Lookup Issues action; thus I am guessing you have Jira Server, correct?

If so...

First thing, please write some JQL which returns the child (and grandchild) issues for an epic, without returning the epic itself.

Then your rule could use the Send Web Request action to call the REST API issue search with that JQL.  Here is a how-to article for that technique and the issue search function documentation.

• https://community.atlassian.com/t5/Jira-Software-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828
• https://docs.atlassian.com/software/jira/docs/api/REST/9.13.0/#api/2/search-search

When you have the response, you could use math expressions and smart value, list filtering to get the percentage from the count "done" / total count.

• https://confluence.atlassian.com/automation/jira-smart-values-math-expressions-993924866.html
• https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588

Kind regards,
Bill

[Dave Rosenlund]

Hi, @Jonathan Chatfield. I'm not a developer myself, but I do have some getting-started tips for you:

• I'm told Atlassian's documentation for REST APIs is very good.
• Also, Atlassian has a dedicated developer community that you can join. 

Hope it helps,

-dave