SQL query to list all projects that use WorkflowScheme id 123

Tayyab Bashir

Hi, 

I'm looking for an Sql query that lets me find all the projects that belong to a particular workflow. 

In total I needed a query that returns all the projects that are in Project Caterogy 'abc' and have workflowscheme id 123. 
I can get projects with category abc but Im unable to get the projects with particualr workflow. 

 

Nic Brough -Adaptavist-

Start with nodeassociation which links the workflow schemes to projects.

Select * from nodeassociation where sink_node_entity = 'WorkflowScheme' and sink_node_id = '123'

will give you the basics.  The category for projects is in the same table.