Lazy Load filter

Posts   
 
    
MWHITEHEAD
User
Posts: 8
Joined: 18-Sep-2007
# Posted on: 30-Oct-2007 13:15:25   

Given the tables Person, PersonRole, Role and that a Person has an attribute to show whether they are active or inactive is it possible to have the result of a lazy load from the Role object to the person object only return 'active' people?

Mark

goose avatar
goose
User
Posts: 392
Joined: 06-Aug-2007
# Posted on: 30-Oct-2007 19:55:20   

Unfortunately no, but you can use prefetch paths with filtering if please see: Generated code - Prefetch Paths - Advanced Prefetch Paths for details.

MWHITEHEAD
User
Posts: 8
Joined: 18-Sep-2007
# Posted on: 31-Oct-2007 00:58:27   

Thanks, I'll try the prefetch path with filter route.