Step-by-step guide

1. Run the following SQL query to get the md5 hashcode of a workflow based on the workflow name:

   select md5(workflowname) from jiraworkflows 
   	where workflowname = 'JIRA MD5 Workflow';

   Please replace the 'JIRA MD5 Workflow' with the actual name of your workflow. The md5 hashcode returned by the query looks like "a5f6ec9e0aaa7ed764a8f1a58d4b95ab" (actual value would vary based on the workflow name supplied).

2. Run the following query to get the Diagram (replace the hashcode accordingly):

   select 
     pe.id, 
     pe.property_key, 
     pt.propertyvalue 
   from 
     propertyentry pe 
     inner join propertytext pt on pe.id = pt.id 
   where 
     entity_name like '%workflow%' 
     and property_key like '%<md5 value>';

   In this example the query would look like this:

   select 
     pe.id, 
     pe.property_key, 
     pt.propertyvalue 
   from 
     propertyentry pe 
     inner join propertytext pt on pe.id = pt.id 
   where 
     entity_name like '%workflow%' 
     and property_key like '%a5f6ec9e0aaa7ed764a8f1a58d4b95ab';

   Replace <md5 value> with the actual value returned by the previous query. Please make sure to put the '%' sign before the md5 hashcode value in the query, since the value at property_key has similar to the following format "jira.workflow.layout:a5f6ec9e0aaa7ed764a8f1a58d4b95ab"