DB query to get list of projects that are associated to a workflow schema/workflow

[Akhil Krishnan]

Can anyone help me with DB query which will fetch list of Jira projects with project leads that are associated to a workflow or workflow schema ?

Any other way ( script runner ) also would be appreciated. 

Akhil Krishnan

Akamai Technologies

[Derek Fields (RightStar) · Accepted solution]

This works in postgresql:

select id, pname, lead
from project a
inner join nodeassociation b on b.source_node_id = a.id
and b.sink_node_entity =
'WorkflowScheme';

Note that it only returns the project information. It does not show which workflow scheme is associated with the project. 

[Akhil Krishnan]

Thanks @Derek Fields (RightStar)