Re: Outer Join Question [solution]
Re: Outer Join Question [solution]
- Subject: Re: Outer Join Question [solution]
- From: email@hidden
- Date: Tue, 3 Jun 2003 17:18:46 -0400
Hello,
I solved this problem by creating a view in the database to compute the
totals for service reservations by day. Than, I used
EOFetchSpecification.setHints(new NSDictionary(request,
EODatabaseContext.CustomQueryExpressionHintKey)) to force it using a
raw SQL request that fetches Person data using my view.
Hoping this will help somebody,
Serge Froment
Informagique inc.
Le mardi, 29 avr 2003, ` 11:08 America/Montreal, email@hidden a
icrit :
> I have Person entities that offer Service entities, for which
> reservations can be arranged. When I create reservations, I update an
> Availability table so I can later found available Person for a given
> service at a given date. Each Availability record gives the number of
> seats available for a particular date and service. As availabilities
> are set only when a reservation is arranged, so I need to find all
> Person entities that have the needed number of seats available for a
> given date as well as all Person entities that have no Availability
> record for that date. The latter Persons have no reservation at all
> for that day, so they are fully available and should be fetched.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.