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

3.1.2:

Postgres 8.1:


Hi,

I have an hql query like this:



My Problem is, that I don't want that the :licenceNumber has to match exactly, so need something like "the LIKE expression for properties" to match the :licenceNumber against the items in the subquery result).

Is this possible?

Thank you.

I know this is a couple of years late... but it might help others that won't need to endure the ghastly amount of time that I have spent trying to answer this problem.

What you are looking to do can be done with a join clause.

say you have an object Foo with a collection of Bar objects:

class Foo(){

...

Foo(){}

List<Bar> bars;

}

To query the bars collection with a LIKE operator:

select f from Foo f join f.bars b where lower(b) like lower(:searchCriteria)