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 |