Hi all!

For example, I have classes
class Test {
int field1;
String field2;
List<Code> codes;
}

class Code {
int codeField1;
String codeField2;
}

I have to write a report query wich will retrieve field1, field2 and codeField1 from some of the codes associated with current Test object (with some specified condition on codeField2).
Which is the best and the most efficient way to do this? (even if I cannot do this in one query)

Thank you in advance.

Hi,

I think u can try something like :


select t.field1,t.field2,c.codeField1 from Test t,Code c where c.codeField2 = ?


this can be used by Query.createSQLQuery();


This will return the results in the form of a list of Object[].

abhilashjena, I need only those codes which are referenced from the current Test object, and there aren't any joins or associations in your query..