Assets - Advanced AQL Filter Issue Scope

[Becky Murray]

I am trying to check muliple custom fields are set to a certain value and then set my custom field with the value it needs. We have ObjectSchema Complaint then Object Type Complaint Info then the Following objects:

• Routing (Custom Assets Field) - Set on (priority Consumer Complaint) by object INreference
  • Attributes: Legal, Compliance
• Priority Consumer Complaint (Custom Assets Field) -
  • Attributes: Yes (Routing = Compliance), No (Routing - No Value)
• Primary Category (Custom Assets Field) -
  • Attributes: Home Improvement Services, Credit

I am trying to check if:

• Primary Category = Home Improvement
• Priority Consumer Complaint = Yes
• Then Routing would be set to Compliance

I have tried the following and it does not work:

1. objectType = "Routing" AND (object having inR(objectType = "Priority Consumer Complaint" AND "Name" = ${customfield_XXXXX.label})) AND (object having inR(objectType = "Primary Category" AND Name = "Home Improvement Services"))
2. objectType = "Routing" AND (object having inR(objectType = "Complaint Info" AND "Priority Consumer Complaint".Name = ${customfield_XXXXX.label} AND "Primary Category".Name = "Home Improvement Services"))

Does work is:

1. objectType = "Routing" AND (object having inR(objectType = "Priority Consumer Complaint" AND "Name" = ${customfield_XXXXX.label}))

Routing displays Compliance because of Priority Consumer Complaint = Yes. But i want to check more values than just the one.  Reason is we have different Categories and not all complaints are Priority.   How do i get it to check the other attributes values, and add that in addition to the filter that is working?

[Becky Murray · Accepted solution]

(objectType = "Routing" AND (object having inR(objectType = "Routing" AND "Priority Consumer Complaint" = ${customfield_11662.label} AND "Source" = ${customfield_XXXXX.label} AND "Primary Category" = ${customfield_XXXXX.label})))