hi i've been trying to perform the outer join as per examples and other messages here,
but I can't seem to get it to work. Just wondering if anyone could help me out.
Criteria criteria = new Criteria();
criteria.addEqualTo("logEntries.userId", userId);
ReportQueryByCriteria query =
QueryFactory.newReportQuery(ExperienceTypeVO.class, criteria);
query.setAttributes(new String[] { "experienceId",
"sum(logEntries.experienceCount)" });
query.addGroupBy(new String[] { "experienceId" });
query.setPathOuterJoin("logEntries");Much thank,Dean
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
