Re: left outer join

[Jakob Braeuchi]

hi dean,

what exactly does not work ?
could you please post the generated sql ?

jakob

Dean Tanabe wrote:

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

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]