ScriptRunner Issue Picker from Issue type and custom field match

Rich Wolverton

We have a JIRA Custom Issue type called Host that contains the details of Host servers that may participate in data transfer. It has a select list for Owner.

We have a Custom Issue type for Data Transfer Request that contains a custom field select list for Business Partner.

We have a working Scriptrunner Issue Picker for Requested Host on the Data Transfer Request that returns all issues of type Host. We would like to add match to the Owner on the Host issue type with the Business Partner on the Data Transfer Request to limit the list of possible Hosts

I am not seeing how to construct the JQL systax or Adaptavist Behavior to make this happen. Any example of this possibility would be appreciated.

Kian Stack Mumo Systems

Hey Rich,

This was a fun little exercise to do and I learned something new about Scriptrunner in the process.

It looks like this is something that you can do using behaviors for Scriptrunner.

After configuring my custom issue picker,  custom fields, and issue types, I build the following behavior:

 

def partner = getFieldByName("Business Partner")
def partnerValue = partner.getValue()
//This is my issue picker field, rename it to what yours is.
def issuePicker = getFieldByName("Issue Picker")

//Update your JQL here. 
issuePicker.setConfigParam('currentJql', 'project = ESTD AND issuetype = Host AND Owner = ' + partnerValue )

The  last  line is really what is key here for how the ticket will update the values available as you update the Business Partner Field.