Set custom field in post function based on content of summary?

Timothy Harris

So, been a while since I have done some workflow stuff. 

 

I seem to remember being able to set a custom field value in a post function based on some JQL.

But, for the life of me, I can't remember which plugin gives this functionality. 

Pretty sure I can use script runner for this, but wanted to see, if there is a free plugin which will provide the same functionality. The customer isn't really into scripting and maintaining scripts...

Jonny Carter_3nm6du

FWIW, you're right that ScriptRunner can totally do this. It's pretty straightforward to execute a JQL query in your script, then assign a value derived from the results to a system or custom field. 

For example, let's say you just wanted a field that displayed the number of issues returned by a particular query:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.web.bean.PagerFilter

def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchProvider = ComponentAccessor.getComponent(SearchProvider)
def user = ComponentAccessor.getJiraAuthenticationContext().getUser()

// edit this query to suit
def query = jqlQueryParser.parseQuery("project = JRA and assignee = currentUser()")
def results = searchProvider.search(query, user, PagerFilter.getUnlimitedFilter())

def customFieldManager = ComponentAccessor.customFieldManager
def numberCf = customFieldManager.getCustomFieldObjectByName("My Number Field")
issue.setCustomFieldValue(numberCf, results.total )

You could use Groovy's iterators to aggregate up particular data points.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.web.bean.PagerFilter

def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchProvider = ComponentAccessor.getComponent(SearchProvider)
def user = ComponentAccessor.getJiraAuthenticationContext().getUser()

// edit this query to suit
def query = jqlQueryParser.parseQuery("project = JRA and assignee = currentUser()")
def results = searchProvider.search(query, user, PagerFilter.getUnlimitedFilter())

def customFieldManager = ComponentAccessor.customFieldManager
def numberCf = customFieldManager.getCustomFieldObjectByName("My Number Field")
def someOtherNumberCf = customFieldManager.getCustomFieldObjectByName("Some other number field")

def issueManager = ComponentAccessor.issueManager
def sum = results.issues.sum{ resultDocumentIssue ->
    def resultIssue = issueManager.getIssueByCurrentKey(resultDocumentIssue.key)
    resultIssue.getCustomFieldValue(someOtherNumberCf) as int
}
issue.setCustomFieldValue(numberCf, sum)

<mostly shameless sales pitch>

If the concern is just having the institutional knowledge to maintain the scripts, there is a course available on ScriptRunner for JIRA.

</mostly shameless sales pitch>