How to identify which workflows use a given status property?

Karl Todd Jr

I need to bulk change issues across many different projects and workflows, but some of them have the issue.editable property set to false and it is preventing me from performing the operation. Ultimately, I need to edit these issues.

From my understanding, the way to do that is by editing each status in every workflow with the editable property set to false and then performing the change, and then setting the properties back afterwards. If this is true, is there a way I can quickly identify workflows that utilize this property?

 

Otherwise, is there another way to circumvent this property and perform the changes I need to perform?

Jaron Stevenson

Hi Karl!

So, this is actually a rather difficult question because the properties are nested in the status within the workflow. I can't figure out a way to get at that info from the REST API, nor from the DB Console (though I'm sure there must be some way). There may be some way to do it with ScriptRunner, I will look into that and report back.

Based on what I'm seeing, your best bet might be doing an XML backup of the system, isolating the workflows in a text editor, and searching for the jira.issue.editable property.

Edit:

After a bit more work and research (thanks to this article especially), I managed to figure out how to do this using ScriptRunner. Running this in the console should print a list of workflows (and which status) with the jira.issue.editable property set to false:

import org.apache.log4j.Logger
import org.apache.log4j.Level
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.config.StatusManager
import com.atlassian.jira.workflow.WorkflowManager

def log = Logger.getLogger("WorkflowProperties")
log.setLevel(Level.DEBUG)

StatusManager statusManager = ComponentAccessor.getComponent(StatusManager)
WorkflowManager workflowManager = ComponentAccessor.getWorkflowManager()

def workflows = workflowManager.getWorkflows()
for(workflow in workflows){ 
  def statuses = workflow.getLinkedStatusObjects()
  for(status in statuses){
    try{
      Map attributes = workflow.getLinkedStep(status).getMetaAttributes()
      attributes.each{ k, v -> 
        if(k == 'jira.issue.editable' && v == 'false'){
          log.debug "${workflow.getName()} - ${status.getName()}"
          log.debug "${k}:${v}"
        }
      }
    }
    catch(e){
      continue
    }
  }
}

 

It's worth looking at the article I linked to above, as it includes some code for adding a property, which I think could easily be modified to change the property to true, allowing you to automate this whole process rather than manually going through and changing that property in every workflow.