I want to count how many child issues have a status of 'Closed' and put that count in the parent iss

[koutarou ishibashi]

I'm not very proficient in English, so I might be mistaken, but I want to put the count of child issues with a status of 'Closed' in the parent issue's field using Jira Automation. Can you please advise me on how to do this?

[Tom Lister]

Hi @koutarou ishibashi 

If you want to use automation, you can use something like this

"Word Count" is a convenient numeric in my setup.

Its value is being set to

{{lookupIssues.size}}

that is the results of the JQL lookup

There are pros and cons to using editable fields vs read-only scripted fields that would depend on your use case.

What are you trying to solve?

[Tom Lister]

[koutarou ishibashi]

Thank you for your answer.　It was solved by implementing it as I was taught.

[Tom Lister]

Hi @koutarou ishibashi 

If one of the answers solved your query, could you mark it as answer accepted for other members to find.

[koutarou ishibashi]

I'm sorry I don't understand the meaning

[Tom Lister]

Hi @koutarou ishibashi 

If you have got an answer to a question that solves your problem, you can click the "Accept Answer" button to indicate to other users with a similar issue that there is a fix.

Best
Tom

[Raja Shekher]

Hi @koutarou ishibashi - You need to have a Scripted field which is available via Script Runner Plug-in and do something like below

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.web.bean.PagerFilter


def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchProvider = ComponentAccessor.getComponent(SearchProvider)
def customFieldManager = ComponentAccessor.getCustomFieldManager()
def customField = customFieldManager.getCustomFieldObjectsByName("FieldName").first()
def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()

// jql query to get the Child Issues with Closed issues
def query = jqlQueryParser.parseQuery("issueFunction in issuesInEpics('project in (MyProject) AND status = "CLOSED')")

def results = searchProvider.search(query, user, PagerFilter.getUnlimitedFilter())

//Get Results
def result = searchService.search(jobUser, query, PagerFilter.getUnlimitedFilter())

def issues= result.getResults()

//log.warn("issues are" + issues)
return issues

[koutarou ishibashi]

Thank you for your answer.　JIRA Automation solved it