Re: max value using wonder??
Re: max value using wonder??
- Subject: Re: max value using wonder??
- From: Theodore Petrosky <email@hidden>
- Date: Fri, 28 May 2010 17:51:42 -0700 (PDT)
so I finally found,.....
Integer i = (Integer)ERXEOControlUtilities.aggregateFunctionWithQualifier(versionListEC, "Version", "itemIndex", "MAX", Version.JOB.eq(theJob()));
I hope this is the 'best'... I hate using raw sql.... (Or maybe I should say I like wonder...)
Ted
--- On Fri, 5/28/10, Michael Sharp <email@hidden> wrote:
> From: Michael Sharp <email@hidden>
> Subject: Re: max value using wonder??
> To: "Theodore Petrosky" <email@hidden>
> Cc: email@hidden
> Date: Friday, May 28, 2010, 8:28 PM
> Have a look at
> ERXEOControlUtilities.aggregateFunctionWithQualifier
>
>
> On 29/05/2010, at 10:22 AM, Theodore Petrosky wrote:
>
> > if I were writing my own sql, I would:
> >
> > SELECT MAX(c_item_index) FROM t_version WHERE c_job_id
> = 100002;
> >
> > is there a way to do this without resorting to raw
> sql?
> >
> > I have so far not had to use any raw sql and was
> hoping there was a "Wonder" way to do this.
> >
> > 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