I need to express the following HQL using Criteria:

from filter4 where filter1.filter2.inttest=10

I have tried these alternatives with no success:

Criteria criteria = session.createCriteria("filter4");
criteria.createAlias("filter1", "filter1");
criteria.createAlias("filter1.filter2", "filter2");

criteria.add(Restrictions.conjunction()
.add(Restrictions.eq("filter2.inttest","10"))
);
criteria.list();

And:

Criteria criteria = session.createCriteria("filter4");
criteria.createAlias("filter1.filter2", "a");

criteria.add(Restrictions.conjunction()
.add(Restrictions.eq("a.inttest","10"))
);

criteria.list();

Your help would be greatly appreciated.

Criteria criteria = session.createCriteria("filter4");
criteria.createAlias("filter1", "filter1");
criteria.createAlias("filter1.filter2", "filter2");

criteria.add(Restrictions.conjunction()
.add(Restrictions.eq("filter2.inttest","10"))
);
criteria.list();

it has to work if you have
in filter4 mapping many-to-one filter1
and in filter1 mapping many to one filter2

Thanks for your answer alexandrubarbat, these are my mappings. (I have the mappings you said.)

<class entity-name="filter1" table="filter1" dynamic-insert="true" dynamic-update="true">
<id name="id" type="string" column="id">
<generator class="uuid" />
</id>
<many-to-one name="filter2" class="filter2" lazy="false"
fetch="join" not-null="false" />
</class>
<class entity-name="filter2" table="filter2" dynamic-insert="true"
dynamic-update="true">
<id name="id" type="string" column="id">
<generator class="uuid" />
</id>
<property name="inttest" column="inttest" not-null="false"
type="int" unique="false" />
</class>
<class entity-name="filter4" table="filter4" dynamic-insert="true"
dynamic-update="true">
<id name="id" type="string" column="id">
<generator class="uuid" />
</id>
<many-to-one name="filter1" class="filter1" lazy="false"
fetch="join" not-null="false" />
</class>

I found the problem,

"10" should be just 10, as the inttest column is of type int.

Thanks again alexandrubarbat.