nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Apply label when an issue is updated, based on logic involving history data and comments data

Amit Gandhi_93cgvm

My requirement is as below. Can you please let me know if that is achievable using JIRA automation?

When a jira issue is updated, I want to apply a label, say XYZ, based on below logic:

Capture the datetime of the second last EVENT, say, DATETIME-SECOND-LAST

AND

Capture the datetime of the last EVENT, say, DATETIME-LAST

EVENT here can be.....

comment added by a user belonging to ABC user group

status changed to TO DO or IN PROGRESS

If the difference of DATETIME-SECOND-LAST and DATETIME-LAST is greater than X hours, then apply the label, XYZ.

Accepted answers

All comments

Bill Sheboy

Hi @Amit Gandhi

I suspect that theoretically you could do that with an automation rule (with the REST API, or with multiple rules and custom fields), however...

That sounds like a brittle solution: depending on the date/time difference between two unrelated events. Particularly because you have no control over what happens during the time between them (e.g. other issue updates).

Would you please describe the problem you are trying to solve? Knowing that may provide context for the community to offer suggestions. Thanks!

Kind regards,
Bill

Amit Gandhi_93cgvm

Thanks for your response.

We have a requirement as below:

ABC team is responsible to update JIRA ticket every X hours. If they miss this update, then we should apply a label, say LBL1, to the JIRA ticket.

The update they do can be a status change (transition to one of the selected statuses) or a comment.

Bill Sheboy

Thanks for clarifying!

I would recommend a single rule, on a scheduled trigger running every X-hours. Then use JQL to find any status changes (or lack thereof) and rule conditions to check for the last comment.

Here is an example below, which you should adjust and test the JQL separately to meet your needs.

trigger: scheduled every X hours (let's assume 6 hours), with JQL
- project = myProjectName AND statusCategory != Done AND NOT status CHANGED AFTER -6h
advanced compare condition: check if the last comment was added after the last 6h
- first value: {{issue.comments.last.created}}
- condition: less than
- second value: {{now.minusHours(6)}}
action: add label

Amit Gandhi_93cgvm

Thanks.

The only confusion I have here is will it take care of OR conditions below?

The update they do can be

a status change (transition to one of the selected statuses)

a comment.

The label should be added if they have not performed EITHER of above actions after X hours passed from last datetime of EITHER of above actions.

Example,

A team is responsible to update jira card every 2 hours.

User1 belongs to this team.

User1 has transitioned to one of the statuses or added a comment at 3 pm

If he/she has not transitioned to one of the statuses AND not added a comment till 5 pm, then the label should be applied.