Since the core class you are doing the restriction with is the contact class, I'm wondering if using the 'contact.' in front of your properties is causing a problem?
Regardless, start small. See if you can get it to work without any restriction. Get one filter field working, and then integrate the other two.
Joined: Jun 16, 2008
i tried without contact. part its the same.
When i am adding restrictions on same table fields i.e firstName and middleName i am getting correct results.
As soon as i add restrictions on communication table i am getting 0 results.
I searched on google and found that i must use Disjunction beacause i need or operator in query.
this is the code
executing this i am getting results but i now getting duplicate records..
Any idea why ??
subject: Quering on multiple tables using criteria api