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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
