That'd be cool - I've never even heard of it, and a search of the mailing list archives only turns up references in code for patches.
Anyone got a handy description of what projectionAttribute does (and how it's different to, say, prefetchedRelationship) ? Cheers, Charles. > -----Original Message----- > From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] > Sent: 27 October 2004 17:55 > To: OJB Users List > Subject: Re: collection loading and filtering > > > hi gildas, > > could you please post the sql without and with projectionAttribute. > i'd like to write a testcase and eventually document this feature. > > jakob > > LE-QUERE Gildas - REN schrieb: > > Excellent! that's right. > > > > Thanks for your help > > > > Gildas > > > > ----- Original Message ----- > > From: "Maksimenko Alexander" <[EMAIL PROTECTED]> > > To: "OJB Users List" <[EMAIL PROTECTED]> > > Sent: Wednesday, October 27, 2004 4:27 PM > > Subject: Re: collection loading and filtering > > > > > > query.setObjectProjectionAttribute("elements") > > will solve your problem > > > > > >>Hi Alexander, > >> > >>I tried your suggestion. With the > "addPrefetchedRelationship()"method all > >>elements of the relationship are loaded. The filter > criteria, here, is a > >>condition to retrieve the A object. In fact it's the right > behaviour for > >>this request. > >> > >>The problem is to realize a kind of left outer join in OOP > to get the > >>Collection of B which belong to A. > >> > >>In fact I use the A data to find some B elements. Now I > think to load a > >>filtered relationship is not very good idea. > >> > >>As a last resort I can use the sqlStatement but I loose the > transparency of > >>the persistence. > >> > >>Thanks > >> > >>Gildas > >> > >>----- Original Message ----- > >>From: "Maksimenko Alexander" <[EMAIL PROTECTED]> > >>To: "OJB Users List" <[EMAIL PROTECTED]> > >>Sent: Wednesday, October 27, 2004 2:25 PM > >>Subject: Re: collection loading and filtering > >> > >> > >>did you try query.addPrefetchedRelationship("elements") ? > >> > >> > >> > >> > >>>Hi all, > >>> > >>>I have un object A referencing � collection with B elements. > >>> > >>>A has an attribute 'name' and a relation 'elements', B has > an attribute > >>>'filter'. > >>> > >>>I want to load elements where name='xxx' and filter='yyy'. > >>> > >>>I use the PersitenceBroker API, here is my request: > >>> > >>> criteria = new Criteria(); > >>> > >>> criteria.addEqualTo("name", 'xxx'); > >>> criteria.addEqualTo("elements.filter", 'yyy'); > >>> > >>> query = QueryFactory.newQuery(A.class, criteria); > >>> > >>> A a = (A)broker.getObjectByQuery(query); > >>> > >>>With the relationship auto-retrieve=true all elements are loaded! > >>> > >>>If auto-retrieve=false the relationship is not loaded. > >>> > >>>Is there a solution ? > >>> > >>> > >>>Thanks > >>> > >>>Gildas > >>> > >>>----------------------------------------------------------- > ---------- > >>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>For additional commands, e-mail: [EMAIL PROTECTED] > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >> > >> > >>------------------------------------------------------------ > --------- > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > >> > >>------------------------------------------------------------ > --------- > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > >> > >> > >> > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > ___________________________________________________________ HPD Software Ltd. - Helping Business Finance Business Email terms and conditions: www.hpdsoftware.com/disclaimer --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
