I am trying to write a complex query using criteria API. I could use some help with this.

I have 3 classes, Assets, AssetComponent and Tasks. The Task class has a 1 to M relationship with AssetComponent and AssetComponent has 1 to M relationship with Asset. I need to find all Assets (it should be unique list) that have some tasks associated with them (the task has a component and the component knows a assets it is connected).

This is what I have so far

public List<Asset> retrieveTask(Project project, boolean assigned) {

DetachedCriteria subquery = DetachedCriteria.forClass(Task.class);

subquery.add(Restrictions.eq("project", project));
if (assigned) {
subquery.add(Restrictions.isNotNull("assignedTo"));
} else {
subquery.add(Restrictions.isNull("assignedTo"));
}

subquery = subquery.createCriteria("component");
subquery.add(Restrictions.isNotNull("asset"));

Criteria criteria = super.createCriteria();
criteria.add(Subqueries.in("id", subquery));

return criteria.list();
}

The deataced query should return all of the tasks that have asset assigned to them and are a part of the give project. Now I need to see what are the unique assets for all of those tasks.

Thanks for helping me with this.

Cheers

yea, I did search but can not find anything useful, I have give my try above so it is not like I have not done anything. I am simply stuck.

so a little help if anyone has any idea would be great

Oh well not very useful suggestion and not a lot of ideas, but what can you do. Stackoverflow was much better so for anyone who runs into something like this, here is the solution http://stackoverflow.com/a/10742687/1415666

cheers and tnx