python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - doctrine-query

How to query for an entity that contains an asscociated entity in ArrayCollection field (many-to-many) in Doctrine?

Setup & Problem There are two entities in my Symfony project (Entries and Persons) that are associated by a many-to-many relationship. An Entry (extended in Interview and LinkedEntry classes) can ...
test-img

TheodorusMaximus

php

symfony

dql

doctrine-query

Votes: 0

Answers: 0

Doctrine Query Builder with joins resulting in: "Unknown column id in 'on clause'"

Summary I'm trying to use Doctrine's Query Builder to make a SELECT that includes a number of joins. This works fine when all the joins are done through entity relationships, but when I introduce a jo...
test-img

amacrobert

mysql

symfony

doctrine

query-builder

doctrine-query

Votes: 0

Answers: 2

Latest Answer

Figured it out. Since I'm creating the Query Builder from the CampaignStep repository, the CampaignStep select was implicit. By adding ->select('step')->from(CampaignStep::class, 'step'), it was...
test-img

amacrobert

Doctrine Query Error - Column not found: 1054 Unknown column 'u2_.price_type_id' in 'on clause'

I have two tables user and price_types with many to many relations that create the third table user_price_types. I want to find all price_types for a specific user so I created this Doctrine query. /*...
test-img

Andre Van Veen

doctrine-orm

doctrine

doctrine-query

Votes: 0

Answers: 1

Latest Answer

Adding the following statement to the annotation lets doctrine know what column name to look for. joinColumns={@ORM\JoinColumn(name="pricetype_id", referencedColumnName="id Final entity...
test-img

Andre Van Veen

Posts

Questions

Blogs

Jobs