find all post functions where an issue type is used

[Peter Newton]

Hi,

I need to remove an issue type from Jira but before doing this, I need to check all existing workflows and see if it was used in a post-function, validation, etc

Anyone have a scriptunner script that can help me with this, please?

Thanks

P.N.

[Rilwan Ahmed]

Try this plugin

https://marketplace.atlassian.com/apps/1216607/custom-field-manager-for-jira?hosting=server&tab=overview 

[Peter Newton]

I understand that publicity is the core of any business but still, I specifically mentioned that I need a scriptrunner script, not an app...

[Rilwan Ahmed]

Try below in DB. Replace '0000' with required fieldID

Select workflowname, DESCRIPTOR from jiraworkflows where DESCRIPTOR LIKE '%customfield_00000%'
OR DESCRIPTOR LIKE '%{0000}%'
OR DESCRIPTOR LIKE '%cf[0000]%';

You can remove DESCRIPTOR  from select part. It gives along text, but will have where exactly the field is used.

[Peter Newton]

I posted wrongly initially. It is about issue type that needs to be removed not custom field

Thanks