Fetching EOs in Vertical Inheritance

Saif <[email protected]> Sat, 24 Jan 2015 20:11:24 +0000 (UTC)
Newsgroups gmane.comp.web.webobjects.devel
Message-ID <[email protected]>
Hi Everyone,

I am trying to use Vertical Inheritance,

Abstract ParentEntity "Applicant"

"Person" and "Company" as two Child entities of Applicant,

Person and Company both can have "Applications", so Applicant has
"toApplications" a toManyRelationship with "Application" table,

Applicant has a boolean field isActive,
Person has a field FirstName,

My goal is to fetch the applications where application.toApplicant isActive
= true and Person.FirstName = 'Saif' sorted by Person.FirstName.

Application does not have any direct relationship with Person.

What should be the Qualifier for such?

So far I could not find any :( What I did as workaround is to first fetch
all persons which are Active and typecast the Persons to NSArray<Applicant>
and us in qualifier with Applications like
Application.TO_APPLICATION.in(person), but I don't think it is a good way to
fetch, 

I will really appreciate any kind of suggestions,

Thanks,
Saif.