Doubts Distinct with Doctrine_Query

Question

Doubts Distinct with Doctrine_Query

Navigation

#1 by (0 votes)

0

I have a table in mysql and I need to return unique values from this table, but I am not able to create a function or query that suits. The SQL statement in the database would be like this and it works fine, but in Doctrine I can not do:

SELECT DISTINCT anodecorrente FROM ct_noticias WHERE categoria = 'Infanto' ORDER BY nt_id ASC

I have the class that maps the table in Doctrine to CtNoticias .

mysql doctrine

asked by anonymous 18.09.2015 / 16:48

1 answer

Get values from WebSQL when loading page through Javascript Installing and using launch-navigator

score 0 · Answer 1

You have the following DQL:

$this
    ->getEntityManager()
    ->createQuery('
        SELECT DISTINCT(c.anodecorrente)
        FROM CtNoticias c
        WHERE c.categoria = :categoria')
        ORDER BY c.ntId ASC
    ->setParameter('categoria', $categoria)
    ->getResult();

You may have to update the property names for the model names of your CtNoticias class.