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

JIRA Database transition screens SQL

Dennis S_

Hi everybody,

I want to query all unused screens of my JIRA instance with SQL.

I have already queried all screens, which are not assigned to any screen scheme. But the result also includes transition screens. Now, I want to query all screens, which are used as a transition screen. But I can´t find any connection to transition screens in the database (model).

How could a query to find transition screens looks like or rather where are the respective connections?

Thank you in advance for your support.

Best regards,

Dennis

Accepted answers

Pete Singleton

There is no direct link between workflow transitions and screen ids. However, in the 'JIRAWORKFLOWS' table the XML for the workflow is stored in the column 'Descriptor'. This XML will contain the screen information (look for "jira.fieldscreen.id").

All comments

Alexey Matveev

Hello,

You can use the Cleaner for Jira plugin:

https://remote.automation-consultants.com/knowledge/display/CFJS/Deleting+Unused+Configuration+Items

Dennis S_

Hi Alexey,

thanks for your answer. Looks like an very interesting plugin. Nonetheless, is there any possibility to query the transition screens from the database?

Best regards,

Dennis

Pete Singleton

Alberto Aragón

Hi Dennis,

you simply can use the Groovy scripts provided by Atlassian in this page:

https://confluence.atlassian.com/clean/advanced-cleanup-1018789335.html

Welcome!

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

Quick Links

Find more posts tagged with

server

sql

jira

jira-server

transition

query

screen