Regex Time Logging from Comment

Question

I'm attempting to automatically log work based on comments which include a "unit of time". If for example a comment is left on the ticket saying "I worked for 45m doing a report on this" it would automatically log 45m of work on the ticket and provide the description as "I worked for 45m doing a report on this".

I've created an automation rule that firstly checks if the comment includes the regexp (\d+)([mhd]). I then create a test action to write a comment of the format {{issue.comments.last.body.regexpMatch("(\d+)([mhd])")}}, this returns empty in the audit log though, wondering if this is the correct way to go about it or if some syntax has changed.

Thanks!

James Purcell_k9mvu5 · Answer

Hi @Mark Segall , thanks for this, this works, however for anyone else viewing this, when you @ someone within a Jira ticket, it will use their UID within the comment text for smart values. This means if someone had an UID which looked like <...400d1h...> it would log 400days and 1 hour onto the ticket. Have now updated the time spent field to

After an awkward ticket had 800 weeks logged of work!

Mark Segall · Answer

Thanks for the added context.  I'm very familiar with corporate slack addiction.  My bad on the expression... Forgot to include the parentheses:

James Purcell_k9mvu5 · Answer

Hi @Mark Segall ,

Thanks for the reply, unfortunately with a test comment of

"hello 2h world" it still comes back that your regex is empty.

The idea was, we currently leverage a slack channel which creates threads when a Jira ticket is created (through a separate automation), raising a thread comment on that slack post will add a comment to the Jira ticket, I then want to use the comment automation to log work on Jira if the Slack comment includes regex of the format \d+[mhd]. That way any practitioner within the channel can simply use slack to post comments on multiple tickets and the work be logged accordingly. It doesn't matter too much if the logger is automation or someone specifically.