Calculate "In Progress" issues count in jira using script runner

[Tukaram Bhukya]

Please some one can help to calculate "In Progress" issues count in jira using script runner's scripted field.

[Julian Riedinger _Decadis AG_]

Hey Tukaram,

maybe the following helps you. But I'm not sure why you need this information for a set of issues. Maybe you want to tell us more about your use case?

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.bc.JiraServiceContextImpl;
import com.atlassian.jira.bc.filter.SearchRequestService;
import com.atlassian.jira.bc.issue.search.SearchService;
import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.search.SearchResults;
import com.atlassian.jira.user.ApplicationUser;
import com.atlassian.jira.web.bean.PagerFilter;
import com.atlassian.query.Query;
SearchResults getIssuesByJQL(String jql) throws Exception
    {
        SearchService serchService = ComponentAccessor.getComponentOfType(SearchService.class);
   
      SearchService.ParseResult parseResult =
serchService.parseQuery(ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser(),
 jql);
         
        if (!parseResult.isValid())
        {
            throw new Exception("jql is not valid. jql was "+jql);
        }
         
        Query query = parseResult.getQuery();
  
          SearchResults sr =
serchService.search(ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser(),
 query, PagerFilter.getUnlimitedFilter());
            return sr;
    }
     
 
 
return getIssuesByJQL("status = 'in progress'").getTotal()

Cheers,

Julian

[Tukaram Bhukya]

Thanks Julian,

Actually i need to display monthly  "In Progress" Status count divide by developer group count