Re: how to handle Views
Re: how to handle Views
- Subject: Re: how to handle Views
- From: Theodore Petrosky <email@hidden>
- Date: Tue, 10 Feb 2009 20:31:11 -0800 (PST)
Thank you... this is exactly what I needed and it works great. There are so many times I am so impressed with WebObjects....
Ted
> Well, he's looking for all clients
> that have open jobs. In that case, you would create a
> fetch specification for Client where jobs.status =
> 'open'. Then make sure to do call setUsesDistinct with
> true on the fetch specification.
>
> A view is basically just a canned query - you can get the
> same results, and similar speed, by doing the proper join
> inside WebObjects via qualifiers.
>
> Ken
>
>
> On Feb 10, 2009, at 6:16 PM, Chuck Hill wrote:
>
> >
> > On Feb 10, 2009, at 2:33 PM, Theodore Petrosky wrote:
> >
> >>
> >> I have two tables.
> >>
> >> jobs and clients
> >>
> >> clients have many jobs but a job has only one
> client.
> >>
> >> I need to generate a list of clients that have
> open jobs. If I were doing this 'normally' I would create a
> View on the table such that it was a listing of clients with
> open jobs. Then I could query this view for the list of
> clients. works really fast.
> >>
> >> how can I accomplish the same thing in webobjects?
> Is there a way to create this view using migrations?
> >
> >
> > If you are thinking about the database, you are using
> WebObjects incorrectly. Just fetch jobs where client =
> client and status = 'open'
> >
> >
> > Chuck
> >
> > --Chuck Hill
> Senior Consultant / VP Development
> >
_______________________________________________
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