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?

[Douglas B]

Hello Richard,

I understand that you're trying to generate a custom report using the filter query that you've create.
Jira default reports are board related but we can't customise them to use data from a filter without using that filter on a board.

For your case we can think on some solutions:

1. You can associate your filter to a board and use one of the following reports:
   

   Average Age Report: Shows the average age of unresolved issues for a project or filter. This helps you see whether your backlog is being kept up to date.

   Single Level Group by Report: Shows issues grouped by a particular field for a filter. This helps you group search results by a field, and see the overall status of each group. For example, you could view the issues in a version of a project, grouped by Assignee. Note that there is a display limit of 1,000 issues for this report.

2. You can use additional reports (e.g. Gantt Chart Report, Timesheet Report, Jira SQL Plugin, eazyBI, All-in-One reports) are available for download from the Atlassian Marketplace.
3. Issue filters can be exported to Microsoft Excel, where they can be further manipulated into charts and reports. See Working with search results.