find all post functions where an issue type is used

Question

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.

Peter Newton · Answer

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

Thanks

Rilwan Ahmed · Answer

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 · Answer

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