LLBLGen Version: 2.6 Final (April 15th 2009)

Using this as an example, (how do I post a link to the llblgen screen shots page?)

Lets say this hierarchy was extended so that in addition to clerk and manager, you also had a receptionist and executive (with FK to CompanyCar).

How would you construct a query to fetch all Clerks and Executives (ignoring Managers, Receptionists and Board Members) while also Prefetching Company Car and Filtering on a field in the CompanyCar table?

Please check the Filtering on entity type manual section?

Thanks for the link. In addition to that, I realized you need to set the join hint to left for the sub types as well as the sub types relationships (I missed that part).