• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Qualifier With an Unexpected Empty Result
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Qualifier With an Unexpected Empty Result


  • Subject: Re: Qualifier With an Unexpected Empty Result
  • From: Chuck Hill <email@hidden>
  • Date: Tue, 07 Apr 2015 23:06:58 +0000
  • Thread-topic: Qualifier With an Unexpected Empty Result

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      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Qualifier With an Unexpected Empty Result
      • From: Kevin Hinkson <email@hidden>
References: 
 >Qualifier With an Unexpected Empty Result (From: Kevin Hinkson <email@hidden>)

  • Prev by Date: Qualifier With an Unexpected Empty Result
  • Next by Date: Re: Qualifier With an Unexpected Empty Result
  • Previous by thread: Qualifier With an Unexpected Empty Result
  • Next by thread: Re: Qualifier With an Unexpected Empty Result
  • Index(es):
    • Date
    • Thread