Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Sireesha Dugginapeddi [Appfire] (Inactive)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titleProject Workflow Scheme
select 
(select pname from project where id = source_node_id) as "Project",
(select name from workflowscheme where id = sink_node_id) as "Workflow Scheme"
from nodeassociation 
where source_node_entity = 'Project' and sink_node_entity = 'WorkflowScheme'

 


Putting these together to get projects using schemes with workflows that contain COT functions

Code Block
titleProject's Using COT functions
select 
(select pname from project where id = source_node_id) as "Project",
(select name from workflowscheme where id = sink_node_id) as "Workflow Scheme"
from nodeassociation 
where source_node_entity = 'Project' and sink_node_entity = 'WorkflowScheme'
and sink_node_id in (select id from workflowscheme where name in (select workflowname from jiraworkflows where descriptor ilike '%org.swift.jira.cot%'))

 

...