Re: @sum and
Re: @sum and
- Subject: Re: @sum and
- From: Theodore Petrosky <email@hidden>
- Date: Sun, 13 Jun 2010 19:30:51 -0700 (PDT)
I think I understand the issue... there is no relationship between the user and project... so even though theUserListItem in a single object when I ask for the @sum there is no way to limit the sum to just the one project....
I have to rethink how to display just the sum for the one project in the last column....
--- On Sun, 6/13/10, Ramsey Lee Gurley <email@hidden> wrote:
> From: Ramsey Lee Gurley <email@hidden>
> Subject: Re: @sum and
> To: "Theodore Petrosky" <email@hidden>
> Cc: email@hidden
> Date: Sunday, June 13, 2010, 8:54 PM
>
> On Jun 13, 2010, at 8:33 PM, Theodore Petrosky wrote:
>
> >
> >
> > userList = User.fetchDistinctUsers(timeListEC,
> User.IS_ACTIVE.eq(true).and(User.ETIMES.dot(ETime.JOB).dot(Job.PROJECT).eq(theProject())),
> null);
> > userListDG.setObjectArray(userList);
> >
> > I have a repetition fed with this
> >
> > UserListRep : WORepetition {
> > list =
> userListDG.displayedObjects;
> > item = theUserListItem;
> > index = session.index;
> > }
> >
> > The userList if perfect... however I have a row of my
> table like this:
> >
> > <td><webobject name = "AmountOfTime"
> /></td>
> >
> > WOD
> >
> > AmountOfTime : WOString {
> > value = email@hiddentOfTime;//valid
> > numberformat = "##.##";
> > }
>
> Hi Ted,
>
> Does
> User.ETIMES.dot(ETime.JOB).dot(Job.PROJECT).eq(theProject())
> work? If theUserListItem.etimes produces an array,
> wouldn't that path produce an array of Projects instead of a
> single project for the qualifier comparison? What does
> your theUserListItem.etimes() array look like before you try
> to sum its amountOfTime attribute?
>
> Ramsey
>
>
> >
> > the Value displayed is the sum of "ALL" entries in the
> ETime table for ALL projects/jobs.
> >
> > I was expecting that:
> > value = email@hiddentOfTime;//valid
> > would only display the sum.amountOfTime for the row
> (theUserListItem) displayed...
> >
> > am I doing something wrong?
> >
> > Ted
> >
> >
> >
> > _______________________________________________
> > Do not post admin requests to the list. They will be
> ignored.
> > Webobjects-dev mailing list (email@hidden)
> > Help/Unsubscribe/Update your Subscription:
> >
> > This email sent to email@hidden
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
| References: | |
| | >Re: @sum and (From: Ramsey Lee Gurley <email@hidden>) |