Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

List of projects associated with a screen

I need list of projects associated with screen or screen schema. is there way like SQL query Capture21.PNG

1 answer

0 votes

An SQL query is a pain - you would have to read every issue type screen scheme and screen scheme for the basic list of screens and where they are used, then the project configs to see which issue type screen schemes are in use where, and then read the whole workflow table parsing it for the screen ids in use in transitions, then the workflow schemes and the projects again.

The UI at leasts helps you a bit with this when you look at the list of screens.

So how do I get list of projects for particular screen schema ?

UI doenst tell hidden project

The admin pages show all projects,so just go to the list of issue type screen schemes.

That shows the projects associated with the issue type screen scheme but each screen could be associated with multiple issue type screen schemes. It gets pretty messy to roll up if you're doing widespread changes across many screens. I'm trying to determine scope for impact and communication purposes so I'm making an excel with the screen changed and the issue type screen scheme(s) associated, pasting all the associated projects then removing dupes but that "hidden projects" message would be so much more useful and less of a tease if it just revealed the rest of the projects so i could copy/pasta.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you