Re: Traversing Multiple Join Tables?
Re: Traversing Multiple Join Tables?
- Subject: Re: Traversing Multiple Join Tables?
- From: Art Isbell <email@hidden>
- Date: Mon, 12 Jul 2004 11:54:24 -1000
On Jul 12, 2004, at 11:39 AM, Lucas Haley wrote:
Object A is joined to Objects B and C across join tables AB and AC.
Object C has a column that is a reference to the pks in Object B.
I'm using a WO Repitition to list the rows in join table AB.
What I would like to do is to include in the AB WORep a column from AC.
Seems like aBItem.a.aCs.anAttribute would describe the path in which
"aBItem" is the current AB object set by the repetition, "a" is the
to-one relationship from AB to A, "aCs" is the to-many relationship
from A to AC, and "anAttribute" is the AC attribute that you would like
to include. However, for each ABItem, there can be many AC objects, so
you'd need to display multiple anAttribute values. You'd also probably
need to do some prefetching or batch fetching to avoid lots of
per-object fetches which would cause serious performance problems.
Aloha,
Art
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.