Hi I want to setup a automation rule which will be a scheduled job based on JQL. The JQL condition I want to write is if the total time reported against a project during the current month passes a certain limit, I want to trigger a email notification. I did searched a lot but could not find a way to get the total reported time with above conditions. Can you help me on this please. Thank you very much.
I do not believe you can do that with out-of-the-box JQL features, as there is no summing feature. There are probably Atlassian Marketplace addons for JQL to do this.
As a work-around, you could use JQL with a scheduled trigger to check on Worklog Date, and then sum the time logged in the rule for your threshold check:
I recommend getting your JQL to do what you want first, and then try using it in a rule to check the worklog data/smart values:
👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event