Dear Members,
Please help to find a solution.
Need to make a trigger when total time logged hits a certain threshold, rule trigger and send mail.
Thanks in Advance
BR,
M Faizan
@Faizan Iftikhar
You can write an automation rule by checking if Value changes for Time tracking. After that you can put the numeric condition to compare if total time is > then your threshold, then use New Action to trigger Email action.
I haven't tried this... but this approach should work.
I have a rule to warn if overbudget occurred, you can play with the work ratio to meet the needed threshold. And the rule runs every time anyone is logging time or like mentioned above to use 'scheduled' trigger with CRON expression
You could use the Scheduled trigger and run it every 5min for example.
In the JQL field you can filter for all issue having more than X hours logged. Example for more than 4 hours: timespent > 4h
And as an action you can use the Send Email action
Hello @Faizan Iftikhar ,
Could you please clarify where the time is being logged/set? Do you need to have some custom menu/UI to set the time for sending email or it is just inside some custom code (add-on) that is required? Is it JIRA cloud or server ?
THank you
Hi
Thankyou for reply
- time logged in JIRA cloud
- every ticket belongs to bucket i.e. category, which have limit of hours i.e. 50 or 60 hrs per month
- if bucket hours is reach limit of 30hours , trigger start work and send mail notification
Thanks
Hi @Vishal Biyani what condition need to put in JQL for total time spent i.e. if i am putting time spent it is fetching project ticket details that is above threshold , please comment
Thankyou for your reply
Facing issue as in return any ticket that has above 30 hours spent is reporting back. need to know the query name of time logging means work log created so that in return got a proper figure.
Hi @Alexey would you please clarify what work ratio? Is 100 representing hours restriction?
Let me try to elaborate a bit more. There is No need for JQL, if you are interested in Time tracking changes.
When the rule checks for "Value Changes for Time Tracking" it will get fired when time is logged against any issue in project. You can include the event. I had selected "Create Issue" and "Edit Issue"
see the right side of the screenshot.
After that you can use smart values like {{issue.aggregatetimeoriginalestimate}} to check for instance i can say
if {{issue.aggregatetimeoriginalestimate}} > 40*3600 Then trigger email
Hope this helps.
[Note: 40*3600 means 40 hours since in my instance time is set to minutes granularity]
Thanks @Vishal Biyani for extended help.
I have added one extra condition as it works for overall project hours so restricted on a particular category PFB snapshot.
If you can validate that would Great help !!
Thanks in Advance!!
@Faizan Iftikhar yes, it's % of the logged time, its original estimate vs remaining/logged
It looks like you're new here. Sign in or register to get started.
