Retrieve list of screen used on project using database or rest api

Question

Hello everyone,

I would like to know if it is possible to retrive list of screen used on a specific project using query sql on database? (or using api rest)

chaitali k · Answer

hi RANARIVELO

can you plz tell me solution how you did that ?

ranarivelo · Answer

Hi Antoine,

I didn't try your method but i solved the issue by using http request and regex. Thank you for your answer

Antoine Berry · Answer

Hi @ranarivelo ,

Kindly try this SQL request (MySQL) :

SELECT fieldscreen.NAME from project
JOIN nodeassociation ON nodeassociation.SOURCE_NODE_ID = project.ID
JOIN issuetypescreenscheme ON issuetypescreenscheme.ID = nodeassociation.SINK_NODE_ID
JOIN issuetypescreenschemeentity ON issuetypescreenschemeentity.SCHEME = issuetypescreenscheme.ID 
JOIN fieldscreenscheme ON fieldscreenscheme.ID = issuetypescreenschemeentity.FIELDSCREENSCHEME
JOIN fieldscreenschemeitem ON fieldscreenschemeitem.FIELDSCREENSCHEME = fieldscreenscheme.ID
JOIN fieldscreen ON fieldscreen.ID = fieldscreenschemeitem.FIELDSCREEN
WHERE nodeassociation.SOURCE_NODE_ENTITY = 'Project'
AND nodeassociation.SINK_NODE_ENTITY = 'IssueTypeScreenScheme'
AND project.pkey = 'KEY'

Antoine