Assets - Concatenated field

[Vicky Pelgroms]

Hi, 

Is there a way to create a kind of concatenated field in the assets? 

We have an object type "Building", this consists out of some fields like "FullName" and "Code". 

When we want to change the building of a laptop, it would be convenient to search for both "FullName" AND "Code". I know you can put these fields together with an automation rule, but is there a way to make a kind of "calculated" field that is selectable in the assets? 

Thank you for your suggestions. 

Vicky

[Pasam Venkateshwarrao · Accepted solution]

Hi @Vicky Pelgroms 

Welcome to the community, to implement a concatenated field

In your JSM project, add a new custom field of type "Assets objects". 

Configure the field:

 Select the desired asset object schema,Within the "Filter Work Scope (AQL)" section, write an AQL query to specify which attributes from your asset objects you want to include and how to join them together using the "CONCAT" function. 

Example AQL query for a concatenated field:CONCAT(asset.name, ", ", asset.serialNumber, ", ", asset.location)

For detail explanation refer the doc

[Pasam Venkateshwarrao]

@Vicky Pelgroms Have you seen this doc is it helped to you

[Vicky Pelgroms]

Hi @Pasam Venkateshwarrao 

Thank you for your response. I found the suggestion you did, and this works great on JSM forms. But I want to use it in the assets itself. 

ex where I want to use it (see Building field): 

[Pasam Venkateshwarrao]

@Vicky Pelgroms then you can create custom field Building as a "select List (cascading)" type then it will show like this