Hi All,
I have an object O that has a List collection of N. I wish to write a condition into a HQL query that gets me all Os where a string value matches n.aField. The HQL will be run against the whole O table.
My first thought was something like
Code:
select distinct o from O o where ? in elements(n)
but then realised that that will not work because n is of type N and not String.
Your thoughts appreciated.
Hibernate version:
2.1
Mapping documents:
N/A
Code between sessionFactory.openSession() and session.close():
N/A
Full stack trace of any exception that occurs:
N/A
Name and version of the database you are using:
SQL Server 2000
The generated SQL (show_sql=true):
N/A
Debug level Hibernate log excerpt:
N/A