nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Comments

Pasam Venkateshwarrao

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)

Screenshot 2025-03-12 at 10.43.47 PM.png

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

Screenshot 2025-03-16 at 12.03.13 AM.png Screenshot 2025-03-16 at 12.02.38 AM.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

assets