Custom Field Object Asset AQL Project Key

[Tiziana Pisenti]

In Asset I have the Object Type= Kontaktpersonen. The Attribute "Project Key" is set with type "Project".

I have a Custom Field Type Asset Object. I want, that in that custom field only objects are shown, which are from the same project as I am working in right now. How can I write the Filter Scope AQL? 

[Anusha A]

Hi Tiziana,

Thanks for your question on community. 

You've been using {{project.key}} in AQL, but please note that this smart value is specific to Automation and cannot be used directly in AQL queries. To filter Kontaktpersonen based on the project, you need to set up your filter scope and filter issue scope appropriately.

Recommended Steps -

1. Filter Scope:

• Set your filter scope to:

ObjectType = "Kontaktpersonen" 

2. Filter Issue Scope:

• If your asset has an attribute called "Project Name", use the following in your filter issue scope:

"Project Name" = ${project.label} 

• If you don’t have the "Project Name" attribute, you will need to create a custom field to store the project key. In that case, use:

"Project Key" = ${customfield_10xxx} 

(Make sure to replace customfield_10xxx with the actual ID of your custom field.)

Further reading - 

• https://support.atlassian.com/jira-service-management-cloud/docs/configure-the-assets-object-field/#Filter-using-object-fields-from-within-the-issue 

Hope the above information is helpful. 

Regards,

Anusha A