The thing is, if you try to fetch everything with a single query (SQL or not) your resultset will get really big. Depending on how many records you're dealing with, you could try using the "in" operator, i.e. "where policy.Id in (:policyIds)" IIRC then you'll have to bind parent/child relationships manually.
On Dec 21, 12:17 pm, Pbirkoff <pbirk...@gmail.com> wrote: > Hi Mauricio, > > Thanx for your reply. > > I've read the sites you provided, but the problem with these examples > is that they all are about retrieving one record, they always provide > an ID. > > My problem is that I want all the case-objects, not just one. I think > there's nothing left to do than to use normal SQL.. -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to castle-project-us...@googlegroups.com. To unsubscribe from this group, send email to castle-project-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.