nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How get issue created, and resolved count weekly?

Shah Baloch

We are looking to send a weekly report via email to a group of people. It should have the project name, number of issues that got created, number of issues that got resolved, and how many are still open. It should have a number of issues from Monday to Friday. Here is an example:

Project: ABC
Issue created: 650
Issue Resolved: 590
Issue still unresolved: 60

It should include all projects, every project should have a separate row.

Is it possible to generate numbers like this via a script?

Thank you for your help.

Accepted answers

PD Sheehan

Hi @Shah Baloch

I just whipped this together ... obviously untested (I have >1000 projects in my instance, I would not want to run this).

But here is a starting point on how you might achieve this with a script:

import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.mail.Email
import com.atlassian.mail.MailFactory
import com.atlassian.mail.queue.SingleMailQueueItem
import com.atlassian.mail.server.MailServerManager
import com.atlassian.mail.server.SMTPMailServer
import groovy.xml.MarkupBuilder

def emailRecipients = ''
def adminUser = ComponentAccessor.userManager.getUserByName('admin')
def searchService = ComponentAccessor.getComponent(SearchService)
def writer = new StringWriter()
def builder = new MarkupBuilder(writer)
builder.table {
    thead {
        tr {
            td "Project"
            td "Created"
            td "Resolved"
            td "Unresolved"
        }
    }
    tbody {
        ComponentAccessor.projectManager.projectObjects.each { project ->
            tr {
                def createdJql = "project = $project.key and created > StartOfWeek('1d')"
                def resolvedJql = "project = $project.key and resolved > StartOfWeek('1d')"
                def unresolvedJql = "project = $project.key and resolved is empty"
                def createdJqlParseResult = searchService.parseQuery(adminUser, createdJql)
def resolvedJqlParseResult = searchService.parseQuery(adminUser, resolvedJql)
def unresolvedJqlParseResult = searchService.parseQuery(adminUser, unresolvedJql)
def createdCount = searchService.searchCount(adminUser, createdJqlParseResult.query)
def resolvedCount = searchService.searchCount(adminUser, resolvedJqlParseResult.query)
def unresolvedCount = searchService.searchCount(adminUser, unresolvedJqlParseResult.query)
                td project.key
                td createdCount
                td resolvedCount
                td unresolvedCount
}
        }

    }
}
MailServerManager mailServerManager = ComponentAccessor.mailServerManager
SMTPMailServer mailServer = mailServerManager.defaultSMTPMailServer

if (mailServer && !MailFactory.settings.sendingDisabled) {
    Email email = new Email(emailRecipients)
    email.setMimeType("text/html")
    email.setFrom(mailServer.getDefaultFrom())
    email.setSubject('All Project Report')
    email.setBody(writer.toString())
    ComponentAccessor.getMailQueue().addItem(new SingleMailQueueItem(email))
} else {
    log.warn "Unable to send, outgoing email is currently disabled"
}

Adjust the JQLs as necessary and provide adequate recipients and configure it as a custom scheduled job at the desired day and time of the week.

You may desire to add some styling to the html table.

In which case you can try something like this

builder.table (style:"border-style:solid;border-width:thin"){
  ...
}

All comments

PD Sheehan

Hi @Shah Baloch

I just whipped this together ... obviously untested (I have >1000 projects in my instance, I would not want to run this).

But here is a starting point on how you might achieve this with a script:

import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.mail.Email
import com.atlassian.mail.MailFactory
import com.atlassian.mail.queue.SingleMailQueueItem
import com.atlassian.mail.server.MailServerManager
import com.atlassian.mail.server.SMTPMailServer
import groovy.xml.MarkupBuilder

def emailRecipients = ''
def adminUser = ComponentAccessor.userManager.getUserByName('admin')
def searchService = ComponentAccessor.getComponent(SearchService)
def writer = new StringWriter()
def builder = new MarkupBuilder(writer)
builder.table {
    thead {
        tr {
            td "Project"
            td "Created"
            td "Resolved"
            td "Unresolved"
        }
    }
    tbody {
        ComponentAccessor.projectManager.projectObjects.each { project ->
            tr {
                def createdJql = "project = $project.key and created > StartOfWeek('1d')"
                def resolvedJql = "project = $project.key and resolved > StartOfWeek('1d')"
                def unresolvedJql = "project = $project.key and resolved is empty"
                def createdJqlParseResult = searchService.parseQuery(adminUser, createdJql)
def resolvedJqlParseResult = searchService.parseQuery(adminUser, resolvedJql)
def unresolvedJqlParseResult = searchService.parseQuery(adminUser, unresolvedJql)
def createdCount = searchService.searchCount(adminUser, createdJqlParseResult.query)
def resolvedCount = searchService.searchCount(adminUser, resolvedJqlParseResult.query)
def unresolvedCount = searchService.searchCount(adminUser, unresolvedJqlParseResult.query)
                td project.key
                td createdCount
                td resolvedCount
                td unresolvedCount
}
        }

    }
}
MailServerManager mailServerManager = ComponentAccessor.mailServerManager
SMTPMailServer mailServer = mailServerManager.defaultSMTPMailServer

if (mailServer && !MailFactory.settings.sendingDisabled) {
    Email email = new Email(emailRecipients)
    email.setMimeType("text/html")
    email.setFrom(mailServer.getDefaultFrom())
    email.setSubject('All Project Report')
    email.setBody(writer.toString())
    ComponentAccessor.getMailQueue().addItem(new SingleMailQueueItem(email))
} else {
    log.warn "Unable to send, outgoing email is currently disabled"
}

Adjust the JQLs as necessary and provide adequate recipients and configure it as a custom scheduled job at the desired day and time of the week.

You may desire to add some styling to the html table.

In which case you can try something like this

builder.table (style:"border-style:solid;border-width:thin"){
  ...
}

Shah Baloch

Hi @PD Sheehan

I'm getting some errors when I try to run the script. I added the script in the custom schedule job. Initially I got the "The script could not be compiled" error, then I added "

import groovy.xml.MarkupBuilder" I thought that might be an issue but now I'm seeing the below error.

2022-07-20 11:11:48,155 ERROR [jobs.AbstractCustomScheduledJob]: ************************************************************************************* 2022-07-20 11:11:48,163 ERROR [jobs.AbstractCustomScheduledJob]: Script job: 'email' failed groovy.lang.GroovyRuntimeException: Could not find matching constructor for: groovy.xml.MarkupBuilder(Class) at Script12.run(Script12.groovy:14)

Screenshots are attached.

Any idea how can we fix this?

Thank you for your help.

PD Sheehan

Ah yes, I see the error on my side too.

Try to replace

def writer = StringWriter

with

def writer = new StringWriter()

And yes, you need

import groovy.xml.MarkupBuilder

Shah Baloch

@PD Sheehanit works, thank you, the only issue I'm having with the email that I receive. The table headings are not aligned. I tried to add styling but it didn't work. Here is the styling part I added.

builder.table ("style:border-style:solid;border-width:thin"){
   thead {
        tr {
            td "Project"
            td "Created"
            td "Resolved"
            tr "Unresolved"
        }
}

Here are the screenshots one is with styling that you see code on the top and another one is without styling.

Thank you for your help.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

scriptrunner

issue

adaptavist

jira-server

groovy

report