Yes. There is a way to do it. I will dig up my code and post to the list. Michael
Sent from my iPhone > On Feb 27, 2016, at 12:30 PM, ocs.cz <o...@ocs.cz> wrote: > > Hello there, > > I've got a page which lists a number of relationships; for each of them the > user wants to see the number of objects, i.e., essentially something like > this: > > === > <wo:repeat list="..." item="$item"> > for <wo:str value="$item.title"/><br/> > - we got <wo:str value="$item.relationship1.count"/> <!-- here's the problem > --> > rel1 items <wo:hyperlink action="$showItemRel1">show</wo:hyperlink><br/> > - we got <wo:str value="$item.relationship2.count"/> <!-- ditto --> > rel2 items <wo:hyperlink action="$showItemRel2">show</wo:hyperlink><br/> > ... > </wo:repeat> > === > > The first time this page gets displayed, all the relationships are fetched of > course. That, alas, takes a small eternity, not speaking of the memory > consumption. And it is rather superfluous, for of all the relationships, only > one or two will typically be actually shown. > > Since the numbers of items are, alas, needed and cannot be simply omitted to > show them only after the user clicks showItemRelN, I would need a solution to > get a number of items in a relationship quickly without actually fetching > them. That would probably mean exploiting SQL COUNT somehow (but only if the > relationship is not fetched yet, of course; if already happens to be fetched, > simple count is self-evidently most efficient). Hopefully, SQL COUNT will be > fast enough to do each time (if not, some caching and > JS-based-lazy-count-loading etc. will be needed and hilarity will ensue, but > at the moment, I really hope SQL COUNT would suffice). > > Is there a pre-made solution for this in WOnder (or even plain WO) which I > have missed so far, or am I out to DIMyself? > > Thanks a lot, > OC > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/michael%40aspireauctions.com > > This email sent to mich...@aspireauctions.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
