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

Question

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 Answer

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.