Search created should have returned only entities that have one parent hierarchy, but is returning entities that have more than one parent hierarchy. Why?

Problem

I created a search filter and the search result (with Hierarchy Parent Count =1) is returning profiles with more than one parent.

((equals(type,'configuration/entityTypes/Customer') 
and (equals(attributes.Source,'EVEREST') and 
equals(attributes.HierarchyParent.EnterpriseDEA.count,1))) or (equals(type,'configuration/entityTypes/Customer') 
and (equals(attributes.Source,'EVEREST') and 
equals(attributes.HierarchyParent.EnterpriseGLN.count,1))) or (equals(type,'configuration/entityTypes/Customer') 
and (equals(attributes.Source,'EVEREST') and equals(attributes.HierarchyParent.EnterpriseGLN.count,1))))

Solution

The filter that was initially created is working as expected.  The filter used is NOT about Hierarchy Parent Count = 1, but it is about a sub-attribute count =1 for a specific nested attribute.

Based on this fact the attributes.HierarchyParent.EnterpriseDEA and attributes.HierarchyParent.EnterpriseGLN has at least 1 sub-attribute.  The incorrect filter is asking for a condition that is very different from Hierarchy Parent Count equal 1. 

The correct definition of the filter should be:

This would generate the more efficient and correct filter 

((equals(type,'configuration/entityTypes/Customer') and

 (equals(attributes.HierarchyParent.EnterpriseDEA.count,1) 
or equals(attributes.HierarchyParent.EnterpriseGLN.count,1) 
or equals(attributes.HierarchyParent.EnterpriseHIN.count,1))) 

and (equals(type,'configuration/entityTypes/Customer') 
and (equals(attributes.Source,'EVEREST') 
and equals(attributes.HierarchyParent.count,1))))

This filter is performing the following search definition:

Must have:

·         Source = Everest
·         Hierarchy Parent = 1

 

Must also have at least one of the following:

·         GLN count = 1
·         HIN count = 1
·         DEA count = 1

 

References

https://docs.reltio.com/entitiesapi/entitiesfiltering.html