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
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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]
