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 

[Pete Singleton · Accepted solution]

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").

[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

[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

[Alexey Matveev]

Hello,

You can use the Cleaner for Jira plugin:

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