Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.0

I am trying to build a query to search for a text string in any of the following: Car.name or Car.description or parts name or parts.description.



The above however does not do an "OR" on the parts name but seems to be an "AND" for the child table. How can get all the Cars whose name contains F% or whose description contains F% or whose parts contains F% in the name of the part?

Use Disjunction class e.g.

List cats = sess.createCriteria(Car.class) ;
Disjunction disjunction = Restrictions.disjunction();
disjunction.add(Restrictions.like("description", "F%"));
...

Could you please expand on this?

There are two useful classes Conjunction -> value="a" and value = "b"
and Disjunction -> value="a" or value="b"

To Create either: (your case)
Disjunction disjunction = Restrictions.disjunction();

String[] properties = new String[]{"name1","name2","name3"};
for(int i = 0; i < properties.length; i++)
disjunction.add(Restrictions.ilike(properties[i],"F%");

criteria.add(disjunction);

That would solve your issue. You can take the code above and create generic helper method:

public static final void disjunction(Criteria c,String[] properties;String value) {
Disjunction disjunction = Restrictions.disjunction();
for(int i = 0; i < properties.length; i++)
disjunction.add(Restrictions.ilike(properties[i],"F%");
c.add(disjunction);
}

I prefer this approach since I hate code duplication
Good luck
Roman

Thanks for the responses. I see the use of the disjunction but am not being able to follow as to how it can be used for the child parts without creating a second criteria.



The code in bold will not work. I am missing something wherein I need to add a criteria for parts.

In short, the query:
select * from car c where c.name like 'F%' or c.description like 'F%' or c.id in (select p.carId from parts p where p.description like 'F%');

is what I am trying to build.

What you need is to create an alias:

criteria.createAlias("parts","p");

then use:

disjunction.add(Restrictions.like("p.name","F%"));

That should do the trick


P.S. Please rate my answers
Thanks
Roman

I figured out another way to do this:



The query you mentioned earlier Roman provides duplicate results. The above seems to give me the correct one.

PS: How do I rate you answer or give you points?

Hi, I have looked into using this 'IN' query example but have come across what seems to be a known issue with hibernate DetachedCriteria - the createAlias does not create the required join when using subcriteria (Jira issue 1685).

I am developing quite a complex 'search' facility and as such would like to use the Criteria objects to build up my query, rather than needing to delve into HQL. Could anybody please explain a suitable (simple!) workaround to achieve this, as I am fairly new to the ORM/hibernate world?

Any help would be much appreciated!

Thanks, Carl