Jira filter query count to scritrunner script

[Ramaiah Pendli]

Hi,

can some one help me out how to write a scriptrunner script for output of total issues to below filter query.

project = RD AND issuetype = Ticket AND status in (Reopened, "In Progress", Open, Accepted) AND component = SCI

[Thanos Batagiannis _Adaptavist_ · Accepted solution]

Hi Ramaiah

Try this one

import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.web.bean.PagerFilter

def jql = "project = RD AND issuetype = Ticket AND status in (Reopened, 'In Progress', Open, Accepted) AND component = SCI"
def issuesFromJQL = getIssuesFromJql(jql)

def getIssuesFromJql(String jql) {
    def adminUser = ComponentAccessor.getUserManager().getUserByKey("admin") //todo this should be an admin user
    def searchService = ComponentAccessor.getComponent(SearchService)
    def issueManager = ComponentAccessor.getIssueManager()

    SearchService.ParseResult parseResult =  searchService.parseQuery(adminUser, jql)
    if (parseResult.isValid()) {
        def searchResult = searchService.search(adminUser, parseResult.getQuery(), PagerFilter.getUnlimitedFilter())
        return searchResult.issues.collect { issueManager.getIssueObject(it.id) }
    }
}
}

[Ramaiah Pendli]

Hi Thanos,

Can we get the total number of issue with number(ex: 10).

if 11th  issue created it should trigger notification email to the user to say some message like "it will be delay to resolve the issue".

and can i put this script in Script Listeners for send out an email when new issue created condition.