so I have 3 entities within one table. I need to be able to search 2 out of the 3 entities in one select statement, but I'm not sure how to do this. Any advice would be greatly appreciated! Cheers!
INSTANCE OF operator in your dql query like this (where
User is your base class):
$em->createQuery(' SELECT u FROM Entity\User u WHERE (u INSTANCE OF Entity\Manager OR u INSTANCE OF Entity\Customer) ');
Doctrine translates this in the sql query in a
WHERE user.type = '...' condition.
See here for more details on the dql query syntax.