Hybris :

Hybris collection type in type system doesn't work in the Flexisearch query. If we need to use some attribute which is defined as collectiontype need to change to relationship.

This is really big pain. In Hybris version 5 the object is deprecated.