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
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
