Symfony2 + Doctrine. How to get @ORM\ManyToOne relation with a condition?

Question

symfony

Good day
There was a problem, I ask for help from people experienced in Symfony.
There are two tables Offer and CustomerFiles
. CustomerFiles stores all files uploaded by the user, in particular, files for offers. The file type is determined by two fields:
file_type
target_id
I.e. for Offer with ID=22 their values ​​will be
file_type = 'offer_image'
target_id = 22
At the moment I have described the relationship like this:
For Offer

/**<br>
     * @ORM\OneToMany(targetEntity="CustomerFiles", mappedBy="offer", cascade={"all"}, orphanRemoval=true  )<br>
     */<br>
    protected $files;<br>

For CustomerFiles

/**<br>
     * @ORM\ManyToOne(targetEntity="Offer", inversedBy="files")<br>
     * @ORM\JoinColumn(name="target_id", referencedColumnName="id")<br>
     */<br>
    protected $offer;<br>

I get the Offer myself simply:

$offer = $em -> getRepository( 'ProjectMainBundle:Offer' )<br>
                -> findOneById( $offerID );<br>

But in the end, all files with target_id=22 are selected.
How to add WHERE condition file_type = 'offer_image'?
Or is it impossible to do this with the help of annotations and you need to create a repository and write a raw DQL query to get an Offer with all Joins?
Thanks in advance

Answer 1

Since you have files of different types, then start different types for them in the same table. In vain you biked with file_type
doctrine-orm.readthedocs.org/en/2.0.x/reference/dql-doctrine-query-language.html#single-table
Well, then write the links to the desired Entity.

Answer 2

In general, they usually do this: they create their own repository and either add a request there, or overload the findBy method.