How to get all issues in project , and how to get issues with status in progress script runner jql

unknown

Hello team

 

i would like to get all issues in one project and to compare the number with issues in the same project which has the status in progress. Thanks

Gezim Shehu [Communardo]

Take a look at the script. I think this gets the job done for you.

In case you want to further process the issues, you can use the optional loop

 

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
import com.atlassian.jira.event.type.EventDispatchOption
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.issue.index.IssueIndexingService
import com.atlassian.jira.util.ImportUtils

def issueManager = ComponentAccessor.getIssueManager()
def customFieldManager = ComponentAccessor.getCustomFieldManager()


def sdUser = ComponentAccessor.getUserManager().getUserByKey('robot')
def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchProvider = ComponentAccessor.getComponent(SearchProvider)
def query1 = jqlQueryParser.parseQuery("project = XYZ")
def query2 = jqlQueryParser.parseQuery("project = XYZ and status =\"In Progress\" ")
def results1 = searchProvider.search(query1, sdUser, PagerFilter.getUnlimitedFilter())
def results2 = searchProvider.search(query2, sdUser, PagerFilter.getUnlimitedFilter())

log.warn("All issues=" + results1.total)
log.warn("In Progress Issues=" + results2.total)
//if you want to do something with the issues, use the following loop
/*
results1.getIssues().each() {
    documentIssue ->
        def issue = issueManager.getIssueObject(documentIssue.id)
        //something goes here
}
*/
//x