How to check the JSU usage only for active workflows in Jira Data Center

Instructions

To see which Jira active workflows use JSU post-functions, validators, and conditions, you can use the query below:

SELECT DISTINCT
    jiraworkflows.id AS workflow_id,
    jiraworkflows.workflowname AS workflow_name
FROM jiraworkflows
    INNER JOIN workflowschemeentity
        ON jiraworkflows.workflowname = workflowschemeentity.workflow
    INNER JOIN nodeassociation
        ON workflowschemeentity.scheme = nodeassociation.sink_node_id
    INNER JOIN project
        ON nodeassociation.source_node_id = project.id
WHERE
    sink_node_entity = 'WorkflowScheme'
    AND (
        descriptor LIKE '%com.googlecode.jsu%'
        OR descriptor LIKE '%ch.beecom.jira.jsu%'
    );

Result example:

Docker - Jira - psql DB

How to check the JSU usage only for active workflows in Jira Data Center

Instructions

Related articles