Re: Fetch Specifications and boolean values

Art Isbell Fri, 21 Apr 2006 19:20:37 -0700

On Apr 21, 2006, at 4:03 PM, Daniel DeCovnick wrote:

I THINK 1 is working. It's generating what looks like valid SQL at least:
SELECT customerID FROM CUSTOMER WHERE hasShipped = ? AND customerID = customerID ORDER BY creationTime asc

Isn't hasShipped a QueueSpot property? If so, the above SQL is invalid.

Hmm... I think I may be misinterpreting the nature of fetch requests then. Given a particular customer, I want to get an array of all their queuespots which have shipped. Something I could call like:

NSArray history = customer.shippingHistory();
or
NSArray history = shippingHistory(session().defaultEditingContext());
whichever's appropriate.

NSArray history = EOUtilities.objectsWithQualifierFormat(session().defaultEditingContext(), "QueueSpot", "customer = $@ and hasShipped = $@", new NSArray(new Object[] {customer, Boolean.TRUE)});

Aloha,

Art

 _______________________________________________
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]

Re: Fetch Specifications and boolean values

Reply via email to