How to check the JSU usage in projects and IssueTypes in Jira Data Center

Instructions

To see which Jira projects and IssueTypes 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,
    project.pname AS project_name,
    STRING_AGG(DISTINCT issuetype.pname, ',')
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
    INNER JOIN jiraissue
        ON jiraissue.project = project.id
    INNER JOIN issuetype
        ON issuetype.id = jiraissue.issuetype
WHERE
    sink_node_entity = 'WorkflowScheme'
    AND (
        descriptor LIKE '%com.googlecode.jsu%'
        OR descriptor LIKE '%ch.beecom.jira.jsu%'
    )
GROUP BY
    jiraworkflows.id,
    project.pname;

Example result:

How to check the JSU usage in projects and IssueTypes in Jira Data Center

Instructions

Related articles