Using an ItemCollection field in flexible search

Hi,

I'm facing an issue with using a collection type field in my flexible search queries.

• I have defined a PrincipalCollection like this

• I have added that collection to my item type

             <attribute qualifier="assignedPrincipals" type="MyPrincipalCollection">
                   <description>Principal collection</description>
                   <modifiers read="true" write="true" search="true"
                       optional="true" />
                   <persistence type="property" />
               </attribute>
  
  
  

• Now when creating my DAO I have a query that looks like this

  SELECT {item:pk} FROM {MyItem as item} WHERE ?session.user IN ({item:assignedPrincipals})

Now the problem is that this query never returns anything (yes, I was able to add principals to that item and can see them in HMC). The field in the flexible search console query result looks like this

 ,#1,8796093186052,8796093218820,

Any help would be appreciated!

Thanks

Erik