Hi,
Is there a quick way to check where the plugin Issue Alternative Assignee is being used? By DB query or something?
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
and
workflowscheme.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 SCHEME
SELECT
jira.jiraworkflows.workflowname
FROM
jira.jiraworkflows
WHERE
jira.jiraworkflows.descriptor
like
'%company.plugin%';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.