Selecting multiple object assets in insight object field using jira automation

Question

I am currently trying to take data from a multi - select field that the customer fill out and then lookup objects that match the values in this field. Then I would like to add those objects to an insights custom object field on my issue using Jira automation.

Currently I am able to use advanced branching to edit the each value in the multi-select list to match the key of the object using split.

Then I am using lookupObjects to get the key for the two items from the multi select list, but when i try and edit the insight objects field of my issue it only adds one of the two items shown in the log output of lookupObjects.

Wondering what i am doing wrong, or if anyone has a better way of doing this.

Any help would be greatly appreciated.

Marini Marini_oy8r62 · Answer

Hi @Adam Galdeman

Let me know if I understand the requirements correctly.

* Packer serial number (NZ) may have values such as APB-123 and AP-123
* If the value starts with APB-xxx, you would like to lookup the asset object in the:* object schema: Double Apple Pickers
* objectType: e.g. ObjectTypeA

* If the value starts with AP-xxx, you would like to lookup the asset object in the:* object schema: Double Apple Pickers
* objectType: e.g. ObjectTypeB

In this case, your lookup AQL can be as follow:

objectType IN ("ObjectTypeA", "ObjectTypeB") AND "Packer serial number" IN ({{#issue.Packer Serial Number (NZ)}}"{{value}}"{{^last}}, {{/}}{{/}})

Then you can edit the asset custom field, Double Packer serial number#, with the lookup smart value.

Cheers,

Marini

Adam Galdeman · Answer

Hey @Marini Marini

So I have managed to figure out that splitting part i mentioned above and have got it working so thanks heaps, and dont worry about that.

I now have a another issue i'm hoping you will be able to help me with.

There are actually two types of serial numbers that can be selected from the Packer serial number (NZ) APB-123 and AP-123 and each have their respective objects which are a different object type unfortunately.

My question is, Is there a way to check every item in the list for Packer Serial Number (NZ) so that i can call the appropriate lookup object for the serial number that returns?

I have tried using the if else condition however it only checks the first value in the list which is always the serial number AP-123 and does not meet the condition for APB-123.

Do you know of a way to check if any item in the list contains the regex not just the first?

Adam Galdeman · Answer

Thanks heaps for this i think its definitely a better way to go for simplification.

I think I have got the object field set to allow multiple as I can definitely select multiple manually.

Sorry i dont think i made it super clear, but the reason i was using the advanced branching is because the values in the Packer Serial Number (NZ) list aren't identical to the key for the objects.

For example:

The packer serial number (NZ) contains the following: "APB-123 Packer 1" , "APB-345 Packer 2"

The objects on the other hand are only identified as "APB-123" and "APB-345".

I was using the advanced branching to split each value on white spaces individually and then taking the first item in the split list.

Does this make sense?

There may be a way similar to what you have done with the single lookup object that can do this?

Thanks heaps for your reply again, much appreciated.