$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 =
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.
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 = [