Re: retrieving fields and collections by ReportQuery

hi adid, as carlos said, reportQueries are used to retrieve 'rows' not objects. extending queryByCriteria to load only some attributes (fetch-groups in jdo) is imo rather complicated. hibernate for example supports such lazy attributes only by compiletime bytecode enhancement. jakob Abid

Re: retrieving fields and collections by ReportQuery

hi abid, what about using distinct ? jakob Abid Hussain schrieb: Hallo again, thanks for the quick answer. When I add disciplines.moduleName and disciplines.disciplineName as attributes for the ReportQuery it somehow works: ReportQueryByCriteria q =

Re: retrieving fields and collections by ReportQuery

Hi again, first of all thanks for help. Using distinct would lead to following SQL: SELECT DISTINCT A0.modul_Name,A0.Zuordnung,A0.Haeufigkeit,A1.MODUL_NAME,A1.BEREICH_NAME FROM MODUL A0 INNER JOIN MODUL_BEREICH A1 ON A0.modul_Name=A1.MODUL_NAME ORDER BY 1 I think this wouldn't solve the

retrieving fields and collections by ReportQuery

Hallo everybody, for the following problem I didn't find a proper solution: I'm using the ReportQuery to retrieve data, because the table has about 25 columns and i only need a few. The problem is, in the ReportQuery I can only specifiy the fields which I want to retrieve, but no collections.

Re: retrieving fields and collections by ReportQuery

Hallo again, thanks for the quick answer. When I add disciplines.moduleName and disciplines.disciplineName as attributes for the ReportQuery it somehow works: ReportQueryByCriteria q = QueryFactory.newReportQuery(Module.class, crit);

Re: retrieving fields and collections by ReportQuery

Abid Hussain escribió: Hallo again, thanks for the quick answer. When I add disciplines.moduleName and disciplines.disciplineName as attributes for the ReportQuery it somehow works: ReportQueryByCriteria q = QueryFactory.newReportQuery(Module.class, crit);