How to search based on different criteria from the given below tables and their relation ships?
is there any way to use Criteria API for searching in multiple tables/classes?

E.g.

Table AAA
id (Pk)
group_type_id (fk-CCC)
name
des

Table BBB
id (primary key)
p_id
com_id (fk-DDD)
gp_id (fk-DDD)
st_date
end_date

Table CCC
id (PK)
name
des

Table DDD
com_id (PK)
com_name
set_ref_id

Relation ship b/w tables

AAA - BBB - > one to many
BBB - DDD -> many to one
AAA - CCC -> many to one



[/img]

You should precise your needs if you want to get a better answer.

With the criteria API, you have to create the criteria object defining a root class, this way :


Then, use the names of the properties in te YourEntity class to build your query. For example :
would override the lazy-loading mode for the someCollection collection.

would create what is called a "subcriteria".

Then use the add() method with the criterion you want and your query should be ok :-).