...
This is a bunch of queries to show where COT functions are used related to workflows and project. These are examples against JIRA 5.2 on PostgreSQL, your query may need to be adjusted for JIRA version or database differences.
...
Workflows using COT functions
| Code Block |
|---|
select * from jiraworkflows where descriptor ilike '%org.swift.jira.cot%' |
| Code Block | title |
Workflow schemes with workflows using COT functions
| Code Block |
|---|
select (select name from workflowscheme where id = scheme) as "Workflow Scheme" from workflowschemeentity where workflow in (select workflowname from jiraworkflows where descriptor ilike '%org.swift.jira.cot%') |
| Code Block |
Project Workflow Scheme
| Code Block |
|---|
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
...
Projects Using COT functions
| Code Block |
|---|
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%')) |
...