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)
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
Hi Antoine,
I didn't try your method but i solved the issue by using http request and regex. Thank you for your answer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.