How to find the list of projects using a particular screen

[Prakash Ganeshan]

Recently we upgraded from 6.4.9 to 7.8, after the upgrade, in the UI it doesn't give me the full list of projects using a particular scheme.  For example, if there are 55 projects sharing a screen, in UI it does shows only first 15 projects and it hides other 40 projects.  I need to know the hidden 40 projects, how do I do that?  Please find the attachment for more details.

[Suren Raj]

Hi, Prakash.

You need to run the following query to see all the projects related to the screen scheme:

select P.pname from nodeassociation NA
join project P on id = source_node_id
join issuetypescreenschemeentity ITSSE on ITSSE.scheme = NA.sink_node_id
join fieldscreenscheme FSS on FSS.id = ITSSE.fieldscreenscheme
where sink_node_entity = 'IssueTypeScreenScheme'
and FSS.name = '<project_scheme_name>';

Hope it helps. 

[Prakash Ganeshan]

Thanks Suren, it works :)