Doctrine QueryBuilder: avg returns string value, not numeric

Asked Aug 31 '16 at 14:14

Active Aug 31 '16 at 15:30

Viewed 341 times

I can't filter my results with andHaving condition, because AVG function returns string values.

 $qb = $this->getDoctrine()->getRepository('AppBundle:Service')->createQueryBuilder('s');
 $qb->join('s.ratingList', 'r')
    ->addSelect('AVG(r.rating) as avg_rating')
    ->addGroupBy('s.service')
    ->andHaving('avg_rating >= :rating')
    ->setParameter('rating', $rating)
  ;

In results see that avg_rating is string format not number, that's why filtering doesn't work. Now how can I get avg_rating as integer?

edited Aug 31 '16 at 15:30

asked Aug 31 '16 at 14:14

blahblah

1,010
15
40

having and where are different things. please see: http://stackoverflow.com/questions/9253244/sql-having-vs-where – Canser Yanbakan Aug 31 '16 at 14:23
I know difference, but the problem is that parameter is not setting. – blahblah Aug 31 '16 at 14:36
Now, change having with where and see that parameter works or not. That's why i mention these are different. – Canser Yanbakan Aug 31 '16 at 14:37
if I do what you advised I have : `Column not found: 1054 Unknown column "sclr_8" in "where clause"` (sclr_8 - i guess is avg_rating) – blahblah Aug 31 '16 at 14:41
try `->where('AVG(r.rating) >= :rating')` – VaN Sep 01 '16 at 10:00
@VaN it didn't work – blahblah Sep 02 '16 at 08:02

Doctrine QueryBuilder: avg returns string value, not numeric

0 Answers0