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

Cleaning up Resolutions and Statuses

Adam_G

I am attempting to consolidate two separate instances of Jira Software into one and would like to trim Resolutions and Statuses to only be those currently in use. When I go to delete an unused resolution/status, it will give me the number of issues, but does not tell me that its used by X filters, Y dashboards, or Z workflow post functions. Is there any way to find this information easily?

Accepted answers

Jack Brickey

yep, you won't get that info. I don't know of any way to gather this automatically. Manual scrub and then wait for someone to report something not working.

All comments

Jack Brickey

yep, you won't get that info. I don't know of any way to gather this automatically. Manual scrub and then wait for someone to report something not working.

Adam_G

I think I actually figured it out using Postgres. There's probably an easier way, but this is how I did it:

Get Resolution IDs
1. go to the admin console, hover over the edit button on a resolution, and write down the number (Step 2) and the name (Step 3)

Find Workflows that use that Resolution ID

Do a SQL query for what you're looking for. for me, it was something like:

SELECT workflowname 
FROM JIRAWORKFLOWS
WHERE DESCRIPTOR LIKE '%<arg name="field.name">resolution</arg>

             <arg name="full.module.key">com.atlassian.jira.plugin.system.workflowupdate-issue-field-function</arg>

             <arg name="field.value">10</arg>%';

There is your list of workflows that are impacted if you delete a resolution.

Find Filters that use that Resolution

Do a SQL query for impacted filters

SELECT *
FROM searchrequest
WHERE reqcontent LIKE '%resolution = %'
AND reqcontent NOT LIKE '%resolution = Unresolved%'
AND reqcontent NOT LIKE '%resolution = unresolved%'
AND reqcontent NOT LIKE '%resolution = \"Old Resolution I want to get rid of%'

There is your list of filters that are impacted if you delete a resolution.

Hubert Kut_tg1xyl

Hi @Adam_G
For cleanup custom fields, data management, Jira administration and much more I would recommend to give a try to our app.
Doctor Pro: Audit, Optimize & Manage Configuration for Jira
https://marketplace.atlassian.com/apps/1231705/doctor-pro-audit-optimize-manage-configuration-for-jira?hosting=cloud&tab=overview

If you have any questions feel free to reach out to us!
Best
Hubert

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server