Automations based on amount and time of activity on that ticket

alessio.tiqets

hi I would like to create automation like color coding or labels if an issue had no recent activity in the past 2 weeks (frozen, one label or color) if has recent activity let's say 10 days then another one (warm, one label or color) and if had many recent activities (hot, one label or color). How is that possible? 

Mikel Garcia Bartolome

Jira Cloud automation doesn't directly support color-coding issues, but you can achieve a similar effect using labels and automation rules. Here's how to set it up:

Labels

Create three labels: "frozen" (for inactive issues), "warm" (for somewhat active issues), and "hot" (for highly active issues). Choose distinct colors for each label for visual identification.

Automation Rule

• Go to the Automation page in your Jira project settings.
• Click Create rule.
• Choose a descriptive name for your rule, like "Issue Activity Labeling."
• Under Trigger, select Issue is updated.
• Leave the other trigger options blank.
• Under Conditions, add a new condition:
  • Choose JQL as the condition type.
  • Enter the following JQL code, replacing <project key> with your actual project key:

project = "<project key>" AND updated >= -2w

(This checks if the issue was updated within the past two weeks)

• In the Actions section, choose Add labels.
• Select the "warm" label you created earlier.

Adding another condition (Optional):

To differentiate between "warm" and "hot" issues, you can add another condition after the first one:

• Click Add condition.
• Choose JQL again.
• Enter this JQL code:

project = "<project key>" AND updated >= -10d AND updated < -2w

This checks for updates within the last 10 days (but not in the past two weeks).

• In the corresponding Actions section, choose Add labels and select the "hot" label.

Final Step

• Finally, at the bottom of the rule configuration, add another action for issues that don't meet any previous conditions.
• Choose Add labels and select the "frozen" label.

Explanation

1. Whenever an issue is updated, the rule triggers.
2. The first condition checks if the update happened within the past two weeks. If yes, the "warm" label is added.
3. The optional second condition checks for updates within the last 10 days, but not in the past two weeks. If met, the "hot" label is added.
4. Any issue that doesn't meet the previous conditions (no update in the past two weeks) receives the "frozen" label.

How to apply card colors

1. Go into Board settings of the Project.
2. Click Card Colors.
3. Click on the drop-down field called Colors based on — here you can choose the card color based on:
   • JQL Query 
     • Make the color based on the label, blue for frozen, etc.

Hope this helps.