I want to get the following SQL structure
SELECT * FROM payment as P INNER JOIN paymentType as PT ON P.paymentTypeId = PT.paymentTypeId AND PT.language = ?
On “?” I want to change the question symbol for 1, for example.
How do I get that whenever they are related they take a value from the entity for the language value?
class Payment {
private int $id;
private int $paymentTypeId;
}
class PaymentType {
private int $id;
private int $language;
}
Relations
<entity name="Payment" >
<id name="id" type="integer"/>
<field name="paymentTypeId" type="integer" />
<many-to-one field="paymentType" target-entity="PaymentType">
<join-columns>
<join-column name="payment_type_id" referenced-column-name="id"/>
</join-columns>
</many-to-one>
</entity>
<entity name="PaymentType" >
<id name="id" type="integer"/>
<id name="language" type="integer" />
</entity>