php - Symfony Doctrine get entity through another entity -

i have 3 entities: user, imaginarybankaccount , recharge. 1 user has 1 imaginarybankaccount , imaginarybankaccount can have more 1 recharges. , want select db recharges belongs 1 user.

i have query:

$resresults = $query->getresult(); $query = $em->createquery('select rec                            appbundle:recharge rec                            rec.datetime > :tresholddate                             , rec.imaginarybankaccount.user = :user                            order rec.datetime' )->setparameter('tresholddate', $datexdaysback)  ->setparameter('user', $filter->getuser()); $recresults = $query->getresult(); 

but throws error:

[semantical error] line 0, col 223 near 'user = :user ': error: class appbundle\entity\recharge has no field or association named imaginarybankaccount.user

how can achieve goal doctrine2?

you have add join clause imaginarybankaccount relation :

select rec appbundle:recharge rec join rec.imaginarybankaccount rec.datetime > :tresholddate , i.user = :user order rec.datetime