[Catalyst] HOWTO: order_by a field in a related record, for paging

2010-06-12 Thread w...@serensoft.com
$c-model()-search( {}, {order_by=???, page=$page} ) How do we order_by a field from a related record when pulling a resultset? We want to order users by team (then by lastname, firstname) and be able to PAGE back and forth... e.g. a User belongs_to a Team. my $team_name =

Re: [Catalyst] HOWTO: order_by a field in a related record, for paging

2010-06-12 Thread Octavian Rasnita
From: w...@serensoft.com $c-model()-search( {}, {order_by=???, page=$page} ) How do we order_by a field from a related record when pulling a resultset? We want to order users by team (then by lastname, firstname) and be able to PAGE back and forth... e.g. a User belongs_to a Team.

Re: [Catalyst] HOWTO: order_by a field in a related record, for paging

2010-06-12 Thread w...@serensoft.com
Ah, after adding join = 'team' (and tweaking fields to distinguish me.* items) that did the trick, thanks! $team_ids = [ map { me.team = $_ } @id_list ]; my $users = $c-model('My::User') -search_rs( $team_ids, { join = 'team', order_by = [