[ScriptRunner] Get list of overdue issues

[Deleted user]

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

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

[Jonny Carter]

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.

[Deleted user]

Hi Jonny,

Works for us! Thanks for your help.

Best Regards,

Marius