Questions about dql
Read more about dql
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Set a field value based on an expression in DQL
I'm trying to update a field in all the lines of a database table, by using an expression as the value. In practice, the field is_new_arrival must be set to true only if new_arrival_start_date and new...
yolenoyer
Votes: 0
Answers: 0
Why Does SQL return the correct info but QueryBuilder / DQL returns NULL for joined table
I have 2 statements that I believe are identical:
SQL Version:
$em = $this->getDoctrine()->getManager();
$RAW_QUERY = 'SELECT *
FROM licences
JOIN users ON licences....
Steve
Votes: 0
Answers: 0
Doctrine DQL with SELECT, GROUP BY, COUNT Semantical Error
I'd like to perform query like:
SELECT o.lang, COUNT(o.id) FROM `order` o GROUP BY o.lang;.
I try:
$entityManager->getRepository(Order::class)
->createQueryBuilder('o')
->select([&quo...
Krzysztof Marczak
Votes: 0
Answers: 1
