Reference Select List Attribute in an Object Type

Aaron Lee_kh9c96

In Assets, I have a "Software Model" object type and a "License" object type.

The "Software Model" object type has an attribute field that is a "Select" list with three items. I would like to reference this list in a Custom Field inside the "License" object type.

Ex: One of the license attributes = "Stooges" and opens a Select list populated with "Larry", "Moe" and "Curly".

If I use objectType = "Software Model" it will return all of the objects for "Software Model" object type, BUT I would like to be able to drill down further and pick one of the Stooges from the Select list.

I have also tried the following AQL syntax by inputting into Configure > Filter Objects, but it is returning an empty field when I then try and populate the field in the "License" object:

"objectType = "Software Models.Stooges"

 

Eugenio Onofre_v78igo

Hi @Aaron Lee

Although I do not have access to your data, I will try to suggest some steps:

• Ensure the "Software Model" object type has an attribute that is a select list with the values "Larry", "Moe", and "Curly".
• Understand the structure of the "License" object type and how it's meant to reference the "Software Model" attributes.
• AQL typically queries objects and their attributes, not individual attribute values directly.
• The query "objectType = "Software Models.Stooges" is incorrect because it tries to reference an attribute value as an object type.
• Instead, your AQL should query the "Software Model" objects and retrieve the desired attribute.
• If you need to filter "Software Model" objects based on the select list value (like showing only those with "Larry"), you’ll need a more complex AQL query.
  • For example: objectType = "Software Model" AND attribute = "Larry", where attribute is the actual name of the select list attribute in the "Software Model".

Please remember to accept this answer in case it helps you resolve your question as it may also help other community members in the future.

Regards,
Eugenio