Add several objects to asset field based on multiselect field

[A_ Boehme _Communardo_]

Hi everyone,

Due to the missing feature of showing Asset objects to anonymous customers in the Jira Service Management customer portal, I'm using a multiple select field ("Customer Portal app") externally where the customer selects one or more values and I'm filling an Asset field ("Apps") internally to provide the agents with enriched information about the selected apps.

When an issue is created the following steps are performed:

This is alright when one Customer Portal App has been selected, but does not work for several. 

I checked that the correct AQL syntax would be 

Name IN ("customer portal app1", "customer portal app2","...","customer portal app n"))

However I'm unclear how to transform the customerPortalApp smart value, which reads according to the log

App 1, App 2, ..., App n

so I can perform the lookup objects successfully. Any assistance is appreciated.

Thanks 

[Marc -Devoteam-]

Hi @A_ Boehme _Communardo_ 

Use flatten() in you smart value. This will make the items appear as a list.

Does this help you further?

[Andrea Robbins]

I've done this before! Real world example! There's a limitation where the real Affected services asset field was not able to be set by non-licensed users, so I had a multi-select field with the same values called, Services List. This is what I put in the lookup objects action:

Name in ({{#issue.Services List}}"{{value}}"{{^last}},{{/}}{{/}})

Where Services List is the name of the field (better to use custom field id tbh) and value is the value selected. In other words, it loops through each value selected and comma separates them except for the last item in the list.