Hi Chuck, I haven’t checked the SQL, but next time I run into an issue like that I’ll remember to take a look there. I ended up using Ramsey’s suggestion as to how to chain the dot methods and that worked. Thanks for your help.
> On Apr 7, 2015, at 7:06 PM, Chuck Hill <ch...@gevityinc.com> wrote: > > What SQL is it generating? > > > > On 2015-04-07, 4:02 PM, "Kevin Hinkson" wrote: > > Hi, > > I’m not certain I will explain this question very well, but I’ll do my best. > > I am using single table inheritance for a group of objects. I also have items > in the same table that relate to each other in a parent/child tree. I was > attempting to filter up that parent/child tree all the way to the top using a > qualifier so that I can find items in a to many relationship that have the > same parent as the one I am starting with. > > Eg: > VariantCart variant = anAlreadyExistingEO; > VariantAvailable availableVariant = > variant.parentVariant().parentVariant().parentVariant(); > EOQualifier qualifier = > VariantCart.PARENT_VARIANT.dot(VariantInventory.PARENT_VARIANT.dot(VariantOrdered.PARENT_VARIANT.dot(VariantAvailable.PARENT_VARIANT.eq(availableVariant)))); > > Then apply said qualifier to a to-many relationship containing VariantCart > EOs. > > This doesn’t work and it’s not clear to me why (I’m assuming it might be > something to do with the inheritance filtering?). So while I’m fine walking > up the tree manually and comparing each parent at the top instead of using a > qualifier I was curious as to if anyone knew off the top of their head why > that didn’t work. > > PS: hopefully I’m not abusing the .dot method — I’ve only recently started > using that. > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com > <mailto:Webobjects-dev@lists.apple.com>) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/chill%40gevityinc.com > <https://lists.apple.com/mailman/options/webobjects-dev/chill%40gevityinc.com> > > This email sent to ch...@gevityinc.com <mailto:ch...@gevityinc.com>
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
