[Dbix-class] Re: "Group by" query in Perl

Dmitri Pissarenko dmitri.pissarenko at gmail.com
Mon May 7 18:40:03 GMT 2007


Hello!

Please ignore my question, I found the solution. My query statement
was wrong. Here is the correct one:

   my @durationSums = $c->model('TimeTrackingAppDB::Activity')->search(
    undef,
    {
      join     => [qw/ goal /],
      select   => [ 'goal.name', { sum => 'me.duration' } ],
      as       => [qw/ name duration /],
      group_by => [qw/ name /]
    }
  );

Best regards

Dmitri



More information about the Dbix-class mailing list