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; } } }

How to update issue rank when status changes with Jira Automation?

Alejandro Blanco

Hi. I'm trying to update the rank of issues when they get moved to a new status (column in board). I want to create an automation rule that will rank all new issues in that column to its very bottom.

So far I have been unsuccessful. I've tried to edit the rank custom field with the advance JSON update syntax:

{
  "fields": {
    "customfield_10019": {
      "rankAfterIssueIdOrKey": null,
      "rankBeforeIssueIdOrKey": null
    }
  }
}

And I've also tried using a pivot issue (always at the bottom of the column), putting its ID in the rankAfterIssueIdOrKey property, but that doesn't work either.

How can you edit the issues' rank with Jira automation?

Accepted answers

Stefan Salzl_0i980g

Hi @Alejandro Blanco

this seems similar to a question I answered in the past. Please see my answer in the link below:

https://community.atlassian.com/t5/Jira-Service-Management/Move-cloned-issues-to-top-of-the-backlog/qaq-p/2116786

Best
Stefan

All comments

Stefan Salzl_0i980g

Hi @Alejandro Blanco

this seems similar to a question I answered in the past. Please see my answer in the link below:

https://community.atlassian.com/t5/Jira-Service-Management/Move-cloned-issues-to-top-of-the-backlog/qaq-p/2116786

Best
Stefan

Alejandro Blanco

Thank you! I've found a potential solution through that link, in this question: https://community.atlassian.com/t5/Marketplace-Apps-Integrations/With-the-Automation-plugin-is-there-a-way-to-set-the-rank-of-an/qaq-p/1087874?utm_source=dm&utm_medium=unpaid-social&utm_campaign=P:online*O:community*I:social_share*

I'll try that.

Alejandro Blanco

I've managed to pull it off. I'll leave a description of the solution here, in case someone else comes looking for the same behaviour.

I've created an automation rule like this:

When: Issue transitioned to <status>
Send web request
- Figure out latest issue in the column
Send web request
- Update rank value for the issue being moved

For the first request I've used the /rest/api/3/search endpoint. That accepts a JQL query, I've used this:

project = <proj_name> AND status = <status_name> ORDER BY Rank DESC

That return the list of issues in the column (status) that we want, with the one at the bottom being first in the list.

Docs: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-get

For the second request I've used the /rest/agile/1.0/issue/rank endpoint. That accepts a JSON file where you send something like this:

{
  "rankAfterIssue": "{{webResponse.body.issues.first.key}}",
  "rankCustomFieldId": 10019,
  "issues": [
    "{{issue.key}}"
  ]
}

Use {{webResponse.body.issues.first.key}} to access the result of the previous request, the last ticket in the column.

You will have to figure out what the rank custom field id is in your project. You can do that by inspecting the Jira website, looking at the column in a JQL search (add the rank column to the results).

Docs: https://developer.atlassian.com/cloud/jira/software/rest/api-group-issue/#api-rest-agile-1-0-issue-rank-put

For both requests I've used basic auth: https://developer.atlassian.com/cloud/jira/platform/basic-auth-for-rest-apis/

I don't think it would be possible to use oauth for requests made from Jira automation.

Stefan Salzl_0i980g

Hi @Alejandro Blanco

Wow.....Awesome effort! Thanks for sharing your solution in such a detailed way so that other community users can benefit from it.

Best
Stefan

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

automation