New Posts New Posts RSS Feed: Filtering navigation entities
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Filtering navigation entities
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
cefernan View Drop Down
Groupie
Groupie


Joined: 13-Jul-2012
Posts: 70 		Post Options Post Options   Quote cefernan Quote  Post ReplyReply Direct Link To This Post Topic: Filtering navigation entities
    Posted: 28-Nov-2013 at 6:03am
I need to load data of people and their phones. My entities are Person and PersonPhone.

In PersonPhone we have a list of phones of some person and only one is set as main phone.

I need to load a list of people including just the main phone. I don't want to retrieve all phone list of each person.

I can't do a query of Person and include PersonPhone because I don't know how to filter an include. Is it possible?
Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1391 		Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post Posted: 28-Nov-2013 at 8:45am
DevForce doesn't support filtering on an Include, but there is a workaround using a projection which might help. Here's more information - http://drc.ideablade.com/devforce-2012/bin/view/Documentation/query-include-predicate.
Back to Top
cefernan View Drop Down
Groupie
Groupie


Joined: 13-Jul-2012
Posts: 70 		Post Options Post Options   Quote cefernan Quote  Post ReplyReply Direct Link To This Post Posted: 28-Nov-2013 at 10:41am
Just as I expected!

Thanks Kim.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down