Is there a quick way using microsoft sql server to find out where JWME is used in active workflows? I would like to avoid searching inside each workflow XML individually.
Sure, just use the following two SQL queries:
select workflowname from jiradb.jiraworkflows where DESCRIPTOR like '%jmwe%'; select PARENTNAME from jiradb.jiradraftworkflows where DESCRIPTOR like '%jmwe%';
That worked perfectly. But Is there a way pull just those post functions or validators for each workflow without manually sorting through the descriptor?
Not from SQL I'm afraid.
However, you could do the same search in the entities.xml file inside a Jira backup (ZIP) file. This will make it much easier to see the actual JMWE extension definitions.
Sound good. I will use the zip file. Thank you for the suggestions.
It looks like you're new here. Sign in or register to get started.