• 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
Query on relationship to abstract entity failing w/horizontal inheritance
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Query on relationship to abstract entity failing w/horizontal inheritance


  • Subject: Query on relationship to abstract entity failing w/horizontal inheritance
  • From: Ken Anderson <email@hidden>
  • Date: Tue, 06 Feb 2007 10:54:39 -0500

Everyone,

I swear this has worked in the past - if I'm mistaken, please remind me!

I have an entity (MemberRuleField) with a relationship to an abstract entity (MemberRule).  MemberRule (and it's sub-entities) has a relationship called MemberCompanyRole (this defines what company the rule is for).  The inheritance structure is implemented using horizontal inheritance (separate table for each concrete sub-entity).

I would like to perform this query:

eos = EOUtilities.objectsWithQualifierFormat(ec, "MemberRuleField", "memberRule.memberCompanyRole = %@", new NSArray(new Object[] {memberCompanyRole}));


What I think this should do is create a query for every concrete sub-entity.  Instead, I get this:

SELECT t0.field_values, t0.long_field_values, t0.member_rule_oid, t0.oid, t0.op, t0.rule_field_oid, t0.trans_id FROM member_rule_field t0, null T1 WHERE T1.member_company_role_oid = ? AND t0.member_rule_oid = T1.oid" withBindings: 1:11(memberCompanyRoleOid)>

I only get one query, and the table name is NULL for the related table.  That unfortunately makes sense, because the memberRule relationship points to the MemberRule entity, which is abstract and does not have a table (yes I know, single table inheritance would solve this problem...and vertical would probably solve it too).

Any thoughts?  I would really prefer to use horizontal here...

Ken
 
 _______________________________________________
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: Query on relationship to abstract entity failing w/horizontal inheritance
      • From: Alexander Spohr <email@hidden>
    • Re: Query on relationship to abstract entity failing w/horizontal inheritance
      • From: Ken Anderson <email@hidden>
    • Re: Query on relationship to abstract entity failing w/horizontal inheritance
      • From: Mike Schrag <email@hidden>
  • Prev by Date: Re: Create new Session & Login as User from Admin Session
  • Next by Date: Re: Query on relationship to abstract entity failing w/horizontal inheritance
  • Previous by thread: Re: Create new Session & Login as User from Admin Session
  • Next by thread: Re: Query on relationship to abstract entity failing w/horizontal inheritance
  • Index(es):
    • Date
    • Thread