Symfony2 + Doctrine : select query with conditional statment

Question

I would like to do something like :

return $qb
        ->select("f, g")
        ->addSelect(" (CASE WHEN (f.type = 'p') THEN 'panel' ELSE 'glass' END) as 'typeLable' ")
        ->from("Win4uAdminBundle:Filling", "f")
        ->join("f.gammes", "g")
        ->andWhere("f.isActive = :active")
        ->andWhere("g.id = :gamme")
        ->setParameter("active", 1)
        ->setParameter("gamme", $gammeId)

But doesn't work. error is :

[Syntax Error] line 0, col 74: Error: Expected Doctrine\ORM\Query\Lexer::T_FROM, got 'typeLable'

The goal is select the type and translate it in the query.

Thanks!

Tomasz Madeyski · Accepted Answer · 2014-11-26 16:31:32Z

2

It is just a typo, typeLable should be without quotes:

->addSelect(" (CASE WHEN f.type = 'p' THEN 'panel' ELSE 'glass' END) as typeLable ")

answered Nov 26, 2014 at 16:31

Tomasz Madeyski

10.9k3 gold badges54 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Anthony Over a year ago

Right, but now I get this error : Expected argument of type "object or array", "string" given

Tomasz Madeyski Over a year ago

what is the whole call stack? What is causing this error?

Karol Wojciechowski Over a year ago

g is object, so: ->andWhere("g = :gamme") and ->setParameter("gamme", $gammeEntity)

Anthony Over a year ago

The latest issue wasn't part of this trac. Thanks everything is ok now.

Collectives™ on Stack Overflow

Symfony2 + Doctrine : select query with conditional statment

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related