Hello,
Here my BDM (3 objects)
Employee <-1:1 -> Contact (name)
Employee <1-n> Phone (phoneNumber)
Request 1 :
I want to find an EMPLOYE from a CONTACT.NAME
CustomQuery on EMPLOYEE
Is the request is: select e from EMPLOYEE e where e.contact.name = :name ?
Request 2 :
search an EMPLOYE form a Phone Number
CustomQuery on EMPLOYEE
Is the request is:
select e from EMPLOYEE e where e.phone.phonenumber = :phonenumber?