With Project Automation - How do I trap that work has been logged on an issue not in an open sprint

[graemejohnson]

Hi

My development team are also responsible for operational support and bug fixing.  We often get 'beaten up' at the end of a sprint window for not delivering on our committed workload, often due to having to spent time on other things during the sprint.

With Project Automation, I wanted to flush to the surface any time logged on issues not in an open sprint, and send an email/post to a webhook.  

I'm struggling however, to work out how I can check for such a condition.

Any help is appreciated.

[John McKiernan]

Hi Graeme, 

Danyal is right here. 

This isn't possible via Automation for Jira right now. We would need to implement two things. 

1) A way to find issues outside a specific sprint
2) We need to be able to sum up the values of the related issues. We are tracking this here: AUT-476

Once we ship this, we will automatically email you to let you know.

Cheers,

John

[graemejohnson]

Hi John

I ended up having a scheduled event which I run at 10:30pm each day.

It picks up any issues not in a sprint where time has been logged by someone in in a given group since the start of the current day and the issue is not in the current sprint.

Here's the JQL condition....

(sprint is empty or sprint not in openSprints()) and issuetype != 'Bucket Task for Time Recording' and issueFunction in workLogged("inGroup 'Team_1' on startOfDay(-0d)") 

Don't think it'll be perfect (particularly on a day when one sprint ends and another one starts) - but seems good enough.

[John McKiernan]

Hi Graeme, 

that seems a good workaround. As you say - not perfect but gets you close enough. Thanks for sharing this, I'll let other customers will similar issue know. 

Cheers,

John  

[Danyal Iqbal]

+1 for lateral thinking.

[Danyal Iqbal]

This is not possible by default. I would recommend script runner to extend the JQL functions available and use something like:

issuefunction in worklogged(after 2018/01/01 before 2018/03/03) and sprint not in opensprint() and ...