Not able to use String function with Smart Value in lookup object

Sarika Dalal

Hi Team,

I got one requirement from customer for insight object, they have one Object Schema In that they are creating object they want once any object got created field AssetID value should be automatically increment by one in the last Object AssetID

Let's take one example here

Object Key    AssetID  

LAB-123        ABC001

LAB-124        ABC002

LAB-125        ABC003

So the field AssetID value should be automatically added, so I am using Automation in JSM

Here is the details about the configuration :

When: Object Created

Then :  Lookup objects

insight query language is  

objectType = TEST ORDER BY AssetIDD DESC

here AssetIDD is text field

Then : edit Object

Select field : AssetIDD

Value : {{lookupObjects.get(1).temp_Asset_ID.charAt(2)}}

ERROR:

Edit Insight field attributes

 

Error updating Object(s)

Objects were skipped

LAB-6858 (temp_Asset_ID = '')

So this is the configuration I have  added but I can see all the text function is not working here and getting always empty value and in Automation audit log I can see error, I can achieve same requirement If I am using only number field but with text field no smart value function is working

following this document : smart-values-text-fields 

Any suggestion why my text function are not working ?

 

Thanks,

Sarika Dalal

Bill Sheboy

Hi @Sarika Dalal 

First thing, I do not have Jira Service Desk, so I will try to help based on what I see in your automation rule.

• Is temp_Asset_ID a defined field in that lookup, as it may not be present if it is returning as empty?
• For {{lookupObjects.get(1)... I believe this is trying to return the second item in the list, as these are 0-base indexed.  Is that what you want?  Otherwise if you want the first one, perhaps try: {{lookupObjects.first...
• Your AssetID values are of the format ABC001, and you are trying to access at charAt(2).  According to the documentation, this one is 1-base indexed, so this may not be what you want.  Consider writing the values to the audit log to confirm what is happening.
• And, as your AssetID values are alphanumeric, if you are trying to increment with a rule, wouldn't you need to split that value into the alpha and numeric parts, increment, and then concatenate the result?

Kind regards,
Bill