[ScriptRunner] Get list of overdue issues

Hey all

I have just added an escalation service in scriptrunner which triggers my custom event which then triggers my mail listener.

The goal is to get all overdue issues of each reporter and send them an email containing a list of said issues with the task to go through them.

I've so far only been able to trigger one mail per overdue issue which can be quite overwhelming depending on how many there are.

Now, how could I get a list or a collection of all overdue issues for each reporter and send them only one email with this list?

Here's my code so far.

Generate Event

grafik.png

Send Custom Mail

Condition and Configuration

//---Ressources
    
    //---Main

        import com.atlassian.jira.component.ComponentAccessor
    
    //---Render Manager

        def rendererManager = ComponentAccessor.getComponent(com.atlassian.jira.issue.RendererManager.class)
        def fieldLayout     = ComponentAccessor.getFieldLayoutManager().getFieldLayout(issue)
        
        //---Description
        
            def rndDesc = rendererManager.getRendererForField(fieldLayout.getFieldLayoutItem("description"))
    
//---Issue Info

    config.issueKey = issue.key
    config.issueSum = issue.summary

    config.issueRep = issue.reporter?.displayName

    config.issueAssignee = issue.assignee?.displayName
    config.issuePrio     = issue.priority?.name

    config.issueStatus = issue.status?.name
    config.issueURL    = "[OUR_JIRA]/browse/$issue.key"
    
    config.issueDesc = "Keine."
    
//---Format specific values
        
    //---Description
        
        if (issue.description)
        {
            config.issueDesc = rndDesc.render(issue.description, null)
        }

//---Conditions

    issue.reporter != issue.assignee

Thanks for any help

Marius

1 answer

Perhaps you could accomplish something similar with Jira's built-in Issue Filter subscriptions? https://confluence.atlassian.com/jira064/receiving-search-results-via-email-720416706.html 

Each user could just subscribe to a filter with JQL like

duedate < now() and resolution = Unresolved and assignee = currentUser()

 

If all the users are in a group, you could just setup a subscription to that filter for them.

Screen Shot 2017-10-09 at 4.27.37 PM.png

Hi Jonny,

Works for us! Thanks for your help.

Best Regards,

Marius

Suggest an answer

Log in or Join to answer
Community showcase
Emilee Spencer
Published 8 hours ago in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

30 views 0 3
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot