Assets Filter Issue Scope (AQL)

[Artem Semenov]

Hello,
Maybe someone has encountered or worked a lot with assets in Jira, do you have a question about how to configure the relationship between assets fields?
The situation is like this, there are 2 fields, one with Partners and the other with Services, and it is necessary that only their services are displayed for certain partners, and for the rest, or if no Partner is specified at all, the list remains the same.
I have configured links between directories and filtering in the dependent field.
This is not how filtering works, if nothing is specified in the Partner field, it outputs the necessary values, and when we select a Partner, those related to the selected partner are added to the current Services, although only the services of the selected partner should be displayed.

[Rudy Holtkamp]

I thinks it is this part, where you forgot the parenthesis

Status not in (Inactive)

[Artem Semenov]

Hello, 

AQL: (objectType = "ИТ Сервис" OR objectType = "ИТ Сервис Internal") AND "Project" IN ("Helpdesk") AND Status NOT IN Inactive  -  it works correctly!

The problem is filtering the values associated with another field, when ${customfield_21001} is not filled in, everything works fine, but when I specify a certain value in customfield_21001, the selection list should correspond to the objects associated with it, but this does not happen, all values + values associated with this object are displayed.

[Rudy Holtkamp]

Ok, are you sure that customfield_21001 is a key or is it an object. If it is an object, you should use ${customfield_21001.key}.

Try to debug it, by hardcoding one key in the AQL filter and go from there.

[Marc -Devoteam-]

Hi @Artem Semenov 

Are the Partner referenced as an attribute on the Services or the other way around?

This s required if Service and Partner are in different object Types in Assets.

https://support.atlassian.com/assets/docs/configure-the-assets-object-field/ 

filter-assets-object-within-a-issue-based-on-other-object-custom-field-storing-multiple-objects 

[Artem Semenov]

@Marc -Devoteam- 

Hi,

Yes, there is a connection set up between these objects. The Service refers to the partner through an attribute with the link type Reference.

[Artem Semenov]

@Marc -Devoteam- 

Following your instructions from the table, I found that the new user does not seem to be working as it should.:
("Internal" = false AND "Partner" IS NOT EMPTY AND object HAVING outboundReferences(objectType = "Партнеры" AND Key IN (${customfield_21001${0}}))) OR ("Internal" = true AND "Partner" IS EMPTY AND object NOT HAVING outboundReferences(objectType = "Партнеры" AND Key IN (${customfield_21001${0}})))
the condition after OR does not exclude values without links, but complements this list.

[Marc -Devoteam-]

HI @Artem Semenov 

Why the OR option, this is the opposite of the first AQL, so it will complement the list.