Quick way to search where Issue Alternative Assignee plugin is used

[Divya Yathagiri Venkata]

Hi,

Is there a quick way to check where the plugin Issue Alternative Assignee is being used? By DB query or something?

[Francis Vittini]

Hi Divya, 

Maybe the below SQL script can help you:

--LIST THE WORKFLOWS AND THEIR WF SCHEME
SELECT  workflowscheme.name,  workflowschemeentity.scheme,  issuetype.pname,  workflowschemeentity.issuetype
FROM  jira.issuetype,  jira.workflowschemeentity,  jira.workflowscheme
WHERE issuetype.id = workflowschemeentity.issuetype andworkflowscheme.id = workflowschemeentity.scheme and  workflowschemeentity.workflow in 
   (SELECT        jiraworkflows.workflowname    FROM        jira.jiraworkflows    WHERE        jiraworkflows.descriptor like '%company.plugin%'); 




 --LIST THE WORKFLOWS NOT MATTER IF THEY'RE OR NOT ASSIGNED TO A WF SCHEMESELECT jira.jiraworkflows.workflowname  
FROM        jira.jiraworkflows  
WHERE        jira.jiraworkflows.descriptor like '%company.plugin%';

[Divya Yathagiri Venkata]

x