How to get the first entity from linked entity

Question

I have the

Class User  {

@OneToMany
    private $profiles
}

Now I have the $user entity in my controller but I also want the first or last profile based on date. How can I achieve this?

I have the method getProfiles() but I think that will return the array collection.

Answer 1

$user->getProfiles()->first()

will do it, as long as you are declaring the $profiles property as a

\Doctrine\Common\Collections\ArrayCollection

in the constructor of your class.

Answer 2

You can easily get the first one like that :

$first = $this->get('doctrine.manager')->getRepository(MyEntity::class)->findOneBy([]);