Criteriabuilder find a children property

[Tropicalista]

I have 2 entity ORM: Orders and Users with many to many relationship.

// M2M -> users

property name="users"

fieldtype="many-to-many" 

type="array" 

lazy="extra" 

cascade="none"

  cfc="user" 

  fkcolumn="FK_orderID" 

  linktable="userOrders" 

  notnull="false"

  inversejoincolumn="FK_userID";

// M2M -> orders

property name="orders"

fieldtype="many-to-many" 

type="array" 

lazy="extra" 

cascade="none"

  cfc="Ordine" 

  fkcolumn="FK_userID" 

  linktable="userOrders" 

  notnull="false"

  inversejoincolumn="FK_orderID";

I'm trying to use criteriabuilder to search a string in fields. 

var c = ORMService.newCriteria( "Order" );

var restrictions = [];

c.createAlias( "users", "u" )

arrayAppend(restrictions, c.restrictions.like( "this.Titolo", "%adm%" ));

arrayAppend(restrictions, c.restrictions.like( "u.username", "%adm%" ));

c.disjunction(restrictions);

var f = c

.withProjections( property="ordineID,Titolo,Descrizione,Data,Data_inizio,Data_completamento,u.username" )

.resultTransformer( c.ALIAS_TO_ENTITY_MAP )

.list();

The problem is with projection of many to many propery "u.username". If I remove that property from projections, query get executed correctly, but of course does not return the user.username field.

How can I solve this?

Thanks

: