Scriptrunner conertToSingleSelect Expected Map

Keith Jones_6qip3z

Hello!

 

I'm trying to create a dynamic field that gets converted to a single select list by the code below.

Does anyone know the exact format of the map this code is expecting?

The list needs to be dynamic because it is generated from a continuously changing list from a large SQL table.

I was able to get it working with a rest endpoint but since the sql request is already elsewhere I would like to generate the map at that time.

Thank you!

 

Here is the code I'm trying to use.

 

def bPartNum = getFieldById("");
def map = [:]

def result = []
for (int i = 0; i < aItemNo.size() ;i++)
{
result << [value:aItemNo[i], html:aItemNo[i],label:aItemNo[i]]
}
//Response.ok(JsonOutput.toJson(map)).build()
map.put('items', result)
bPartNum.convertToSingleSelect(map)

PD Sheehan

There are 2 ways to perform the conversion

1) have a rest endpoint that returns a structure like:

[ items: [ [value: valueString, html: valueHtml, label: labelString, icon: iconHref] ],
   total: numberofItems,
   footer: "Prompt when empty

]

 The convertToSingleSelect needs to include ajaxOption parameter like specified in the documentation page.

 

2) use a simple map object. 

//using your aItemNo assuming it is an array of items you want in the map
def map = aItemNo.inject(['':'None']){ map, item ->
  map[item]= item
  map
}
field.convertToSingleSelect().setFieldOptions( map)

The map will end up looking like this:

[ '': 'None', item1: "item1", item2: "item2", item3: "item3"]

If aItemNo includes key/id and label, you could form the map to look like this:

[ '': 'None', item1key: "Label for item1", item2key: "label for item2", item3Key: "labe for litem3"]