how to get all project id's associated to a particular screen using sql / groovy ?

[Jonnada Kiran]

Hello All,

how to get all project id's associated to a particular screen using sql / groovy ?

Thanks,

Kiran

[Nic Brough -Adaptavist-]

There is no easy answer for this, because there are two ways a project might be using a screen.

The first one is complex, but can be queried with a bit of work.  The relationship is Project -> Issue type screen scheme -> screen scheme -> screen

The second one is harder to query.  The relationship is Project -> workflow scheme -> workflow -> transition screen.  Problem for SQL is that you will need to parse the workflow xml to find each screen that might be in use.

Because of this complexity, I doubt it's actually that useful to you.  Could you explain why you are asking, rather than "how to do it"?  What are you trying to achieve?

[Tarun Sapra]

Hello @Jonnada Kiran

What do you mean by "associated to a particular screen", could you please elaborate a bit more.