Hi !
I've got a sale object wich is composed by a custommer. My mapping look like this :

Mapping documents:
<class name="SaleDTO" table="Sale">
<id name="id" type="long" unsaved-value="null">
<column name="Av_Id" sql-type="bigint" not-null="true"/>
<generator class="identity"/>
</id>
<property name="offer">
<column name="Off_Name" length="32" not-null="true"/>
</property>
<many-to-one name="custommer" />
<many-to-one name="employe" />
</class>
<class name="custommerDTO" table="Custommer">
<id name="id" type="long" unsaved-value="null">
<column name="Cl_Id" sql-type="bigint" not-null="true"/>
<generator class="identity"/>
</id>
<property name="name">
<column name="Cl_name" length="32" not-null="true"/>
</property>
</class>

So my question is : Is it possible to add to the saleobject a search criteria like custommer name ?
I have try crit.add(Expression.like("custommer.name", "john")); and it's not working.
Thank you in advance

use createCriteria() or createAlias()

In fact I want to make a method wich is making searches in the sale table based on several criteria. All of this criteria are attributes of sales, except the custommer name. Can I add this criteria to the others ?
Here is a part of my method :

Criteria crit = session.createCriteria(SaleDTO.class);

//search on name
String name = dto.getname();
if (!((name == null) || (name.length() == 0))) {
log.warn("Crit

That's ok, I've found a solution.

But i've got another question : Is it possible to order the list of sales with the name of the custommer for example ?

Thx