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.
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.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG