Re: more on the Vertical Inheritance, the sql

2013-01-27 Thread Chuck Hill
On 2013-01-26, at 5:12 PM, James Cicenia wrote: > Hmmm, > > Why would I want it abstract? Is it a real EO? Are there ever instances of that EO? If not, abstract. If so, need a qualifier. > > Anyway, I put a qualifier in the root entity osType = 'All' > > then the sql that was generated w

Re: more on the Vertical Inheritance, the sql

2013-01-26 Thread James Cicenia
Hmmm, Why would I want it abstract? Anyway, I put a qualifier in the root entity osType = 'All' then the sql that was generated was: DEBUG (ERXNSLogLog4jBridge.java:46) - evaluateExpression: Which works! You da man like always! James On Jan 26, 2013, at 6:48 PM, Chuck Hill wrote: > S

Re: more on the Vertical Inheritance, the sql

2013-01-26 Thread Chuck Hill
Sounds like the root entity is not abstract or does not have a restricting qualifier. On 2013-01-26, at 4:43 PM, James Cicenia wrote: > OK - > > This is the SQL that is generated for > > NSArray entries = > Notification.fetchAllNotifications(session().defaultEditingContext()); > > Notice tha

Re: more on the Vertical Inheritance, the sql

2013-01-26 Thread James Cicenia
OK - This is the SQL that is generated for NSArray entries = Notification.fetchAllNotifications(session().defaultEditingContext()); Notice that is first searches all the subclasses then the final query with no osType qualifier. Doesn't make sense to me. DEBUG (ERXNSLogLog4jBridge.java:46)

Re: more on the Vertical Inheritance, the sql

2013-01-26 Thread James Cicenia
I am both in the objects init and in the Qualifier in EOModeler. On Jan 26, 2013, at 3:45 PM, Johnny Miller wrote: > Are you using a restricting qualifier? > > > > On Jan 26, 2013, at 10:36 AM, James Cicenia wrote: > >> OK - >> >> When I just the SQL... >> >> It actually does three sele

Re: more on the Vertical Inheritance, the sql

2013-01-26 Thread Ramsey Gurley
On Jan 26, 2013, at 1:36 PM, James Cicenia wrote: > OK - > > When I just the SQL... > > It actually does three selects and not one. > It does a select for each of the children entities and then for the parent > class. > > Why? I am just asking or fetching the parentClass. Why does it want to

Re: more on the Vertical Inheritance, the sql

2013-01-26 Thread Ken Anderson
James, It would help to provide the definitions of the entities. It all depends on how you setup the restricting qualifiers and primary keys. Do all 3 have the same associated table? Ken On Jan 26, 2013, at 3:36 PM, James Cicenia wrote: > OK - > > When I just the SQL... > > It actually

Re: more on the Vertical Inheritance, the sql

2013-01-26 Thread Johnny Miller
Are you using a restricting qualifier? On Jan 26, 2013, at 10:36 AM, James Cicenia wrote: > OK - > > When I just the SQL... > > It actually does three selects and not one. > It does a select for each of the children entities and then for the parent > class. > > Why? I am just asking or fet

more on the Vertical Inheritance, the sql

2013-01-26 Thread James Cicenia
OK - When I just the SQL... It actually does three selects and not one. It does a select for each of the children entities and then for the parent class. Why? I am just asking or fetching the parentClass. Why does it want to also search by Qualifier of the subclasses? Thanks James ___