How can I set an Insight custom field from a ScriptRunner behaviour

Question

Hello.
We recently started to use Insight in our Jira Software. We have created the object schema. Inside this scheme we have objects with 2 insight custom field with multiple selection: 'Country' and 'Month'.

Goal: on the creation of an issue, filter the objects depending the 'Country' and the 'Month' and set all the objects in a new insight custom field 'Camp'. It would be similar to the IQL: Country in ({values of the custom field 'Country'}) AND Month in ({values of the custom field 'Month'})

Problem: in a first instance, when you set the IQL filter to this new insight custom field, due to the multiple selection, when you select more than 1 value it change the option 'IN' to 'AND'. If for example you select 2 countries and 1 month it make the following: Country in (value1) AND Country in (value2) AND Month in (value1) instead of Country in (value1, value2) and Month in (value1).

Solution: as solution I created a behaviour with the add-on "ScriptRunner" to parse the value of the custom fields, make the IQL search correctly and set the obtained values to the custom field 'Camp'.

Problem of the solution: after search and obtain the correct objects from insight, I can't find the way to set the obtained objects in the new custom field 'Camp' from this behaviour on ScriptRunner. I have the id of the objects.

In summary, in my script I can't set the objects on a insight custom field once I have find this objects. Please, help me to find the solution. Thanks in advance.

Martin Hohenberg_c2aqfd · Answer

Have you ever found a solution for this? Looking at a similar problem.

https://xkcd.com/979/ applies here, painfully :)

Lucía Ruz Sáez · Answer

I tried to set the options with "setFieldOptions" but with the Insight object does not change anything. I also tried to set it manually instead use the List with the IQL, introducing the key as String of the objects, but neither...

def camp = getFieldByName("Campaign")

def camp2 = customFieldManager.getCustomFieldObject(17873)
def config2 = camp2.getRelevantConfig(issueContext)

def options2 = ComponentAccessor.optionsManager.getOptions(config2)

camp.setFieldOptions(options2.findAll {it.value in ["MAR-190822"]})

Dirk Ronsmans · Answer

well I believe your issue is just with the last 2 lines:

List<ObjectBean> objects = iqlFacade.findObjects(8,IQL)

//Set field Camp
getFieldById("customfield_17873").setFormValue(objects)

you are setting objects through the setFormValue but the parameters is just expecting a list of Strings and not objectBean's.

I believe I had to do a similar thing in the past where I iterate over the beans and just create a String of objectKey's and set those on the setFormValue()