Hello all,
i have been trying hard to form a query through my controller to extract
records. example:
my $loan_list = $c->model('MyAppDB::TblLoan') ->search
(
{userid => $userid},
{
select => [ 'userid', 'loanid', { max => 'price' } ],
group_by => [qw/ loanid /]
}
);
i want to extract a loan list. i have userid. but i want to extract loans only
with maximum price. So i am just wondering how should i write the maximum
condition in the above situation. right now it does nt seem to work.
Thanks!
_______________________________________________
List: [email protected]
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
