Splitting an Insight LookupObjects smart value - Jira Assets

[Ahmad Sidawi]

Hi, 

I have a field in a Jira Assets/Insight schema which i'd like to split the value for. I've used the split in the past but in Asset fields its returning nothing.

We have something like XX12344-1234. I'd like to return the XX12344 only.

I've tried:

{{lookupObjects.first.id.split("-").first}}

the {{lookupObjects.first.id}} works fine, just the split doesn't return anything. 

Thanks :)

[Bill Sheboy · Accepted solution]

Hi @Ahmad Sidawi 

First thing: I am not using Insights, and so I am basing my suggestion on what I know about automation rules.

I believe lookup objects is returning, well...an object.  That has structure to it and is not just text.  Perhaps try accessing the value attribute before the split, like this:

{{lookupObjects.first.id.value.split("-").first}}

or

{{lookupObjects.first.id.value.split("-").get(0)}}

Kind regards,
Bill

[Ahmad Sidawi]

Neither worked unfortunately. They work fine with lookupIssues but don't seem to work with lookupObjects. Logs returned no result

 

[Bill Sheboy]

I wonder if the dynamic nature of assets and lookup objects is preventing this, similar to what happens for calculated fields with marketplace addons.

Let's try a work-around:

• with a Create Variable action, save the value {{lookupObjects.first.id}} and let's name that varFirstId
• write that to the audit log to confirm it worked
• now let's try the split with {{varFirstId.split("-")}}

Saving the object to a variable will both look it up and force it to text.  And, writing it to the log will confirm it contains what you expected before we try other things.

[Ahmad Sidawi]

That worked! What a pain ;P. 

Thank you so much 💛