Can an Asset Custom Field dynamically change it's values based on another Asset Custom Field value?

[Eli Devlin]

Hi,

Let's say I have two Asset type Custom Fields:

I select 'Application A' from the first field, and then I want the second field to only show Assets that have a relationship with the 'Application A'.

If I changed my selection to 'Application B', I want the available options for the second field to then change accordingly without changing the AQL of the field. 

I know that you can achieve this in forms, but what about in Issue View?

I also know that you can achieve 'cascading' options with non-asset custom fields.

The goal would be to allow users to select the affected Application first, and then drill down into it's various services, such as the API, or onboarding, or the portal, etc. so that you may have an Issue relating to Microsoft Teams, specifically it's Telephony aspect.

Is this type of configuration possible?

[Fernando Eugênio da Silva · Accepted solution]

@Eli Devlin 

You can do it!

Let's to say you need to have this configuration for your assets field B

"Aplications" is the name of attribute I'm using to make the relationship between the assets objects, then after you just need to change the field ID.

This works for Help Center and internal view.

Let me know if you have questions.

[Eli Devlin]

Hi @Fernando Eugênio da Silva thanks for your reply. 

In your example, is customfield_10806 used to represent the field for hypothetical "asset field A"? 

So it reads:

For asset field B, only show values where the 'Applications' attribute matches the selected value from asset field A

If I understood that correctly, what a wonderful solution thank you

[Fernando Eugênio da Silva]

@Eli Devlin 

Yeah, you got it! This is exactly the point. The field ID is about customfield Assets A.

Sorry if was not clear :D

Let me know if you have doubts.

[Eli Devlin]

OK that makes sense thank you.

I've tried doing this but haven't been successful yet. Could you see if you can spot what I'm missing, please?

So lets say I have Custom Field 1/Object 1
Name = Bloomberg

Parent Name = Bloomberg

This is stored in custom field 11283

And Custom Field 2/Object 2

Name = Bloomberg Terminal

Parent Name = Bloomberg

For the AQL of the second Custom Field I wrote: "Parent name" = ${customfield_11283}

Then I select Bloomberg in Custom Field 11283, but the second Custom Field doesn't yield any results.

Do I need to append .Name or something similar to the ${customfield_11283} smart value?

[Fernando Eugênio da Silva]

@Eli Devlin 

What is your Object Schema Configuration in Assets.

Should be like this:

For Level 1 I have all Parent objects and for Level 2 I have all Children objects. Then I apply an Object Reference in Assets.

For my Parent Assets field (Field A) I have this configuration:

And this is my configuration for Children Assets value (Field B):

Could you confirm if your configuration is like this?

[Eli Devlin]

It looks like this, where both Bloomberg and Bloomberg Terminal are the same Object Type (Application) and are not hierarchical in the asset schema:

Here's Bloomberg, the "parent":

And here's Bloomberg Terminal, the "child":

Writing this out makes me think that they should actually be different object types and be in a true hierarchy, but it may not be required.

[Fernando Eugênio da Silva]

@Eli Devlin 

Considering your Assets Schema configuration, for your Assets field B you can use this in your Filter Issue Scope (AQL):

objectType = "Applications" AND "Parent Name" = ${customfield_XXXX}

Change XXX for field ID of Assets field A. Just have sure that your attribute are referencing your Object Applications, exactly this:

If you have this attribute type to make reference between your objects, so the configuration will be works fine.

You don't need to use as hierarchy, even being the best way.

Let me know if you have questions.

[Eli Devlin]

@Fernando Eugênio da Silvayou're a star, thank you so much.

I was able to replicate your suggestion successfully, and it works brilliantly.

Thank you!

[Mateusz Muller]

Can you point me in direction on how to achieve this via forms? I can't find any way to dynamically reduce objects on the Portal :D

[Fernando Eugênio da Silva]

@Mateusz Muller 

If you had already configured the Assets in Jira and also configured the AQL for each custom Assets field, you just need to add these fields in your forms and it works normally. Forms has the Assets field option and you just need to say.

For Forms Field 1 > Associate Jira Assets Field 1

For Forms Field 2 > Associate Jira Assets Field 2

Then, if you AQL for the both fields are already played, the value of the second field will be showed dinamically for the value from the field 1

It's same way :D