CODEWITHSUNDEEP
phpsql-serverdoctrinegroup-bydistinct
WilliamTeodoro
WilliamTeodoro

Reputation: 61

Doctrine 2 SQL Server query (MSSQL / SQLSRV) (WiTH DISTINCT)

Hi Guys! Thank you for the quick response of all. I am working with Doctrine 2. In it, I did the following query:

$qb =    $em->createQueryBuilder()
                ->select('obj.objRowid')
                ->from('MapAdminCaminhoCriticoIndicadores', 'cci')

                ->innerJoin('cci.cciIndicadordr', 'ind')
                ->innerJoin('cci.cciCaminhodr', 'ccr')
                ->innerJoin('ind.indObjetivodr', 'obj')

                ->groupBy('obj.objRowid')

                ->getQuery();

Return correct (grouped) for echo 'objRowid':

2
4
11

Now, I insert the column 'cci.cciRowid' in 'select' and 'GroupBy':

$qb =    $em->createQueryBuilder()
                ->select('obj.objRowid, cci.cciRowid')
                ->from('MapAdminCaminhoCriticoIndicadores', 'cci')

                ->innerJoin('cci.cciIndicadordr', 'ind')
                ->innerJoin('cci.cciCaminhodr', 'ccr')
                ->innerJoin('ind.indObjetivodr', 'obj')

                ->groupBy('obj.objRowid, cci.cciRowid')

                ->getQuery();

Return without group, repeating the value '4 ':

2
4
4
11

Do you have any idea? Thanks guys!!! ;)

Upvotes: 0

Views: 821

Answers (1)

Joe Stefanelli
Joe Stefanelli

Reputation: 135928

You're second query selects two columns, but you only show one in your output. I suspect the 4 is repeating for obj.objRowid because there are different two values for cci.cciRowid when obj.objRowid is 4.

Upvotes: 1

Related Questions