$c->model('ORANGES::AccountView')->search({},{order_by=>'account_code'})->all()
I'd recommend that you look into iterating thru the recordset in the
template, instead of rendering all rows of data before it's rendered:
my $acct_rs =
$c->model('ORANGE::AccountView')->*search_rs<http://search.cpan.org/~arodland/DBIx-Class-0.08196/lib/DBIx/Class/ResultSet.pm#search_rs>
*(
{},
{
order_by => 'account_code',
page => $page_no,
rows => $rows_per_page,
},
);
$c->stash( accounts => $acct_rs );
then in your template
[% WHILE ( acct = accounts.next ) %]
See
http://search.cpan.org/~danieltwc/DBIx-Class-0.07002/lib/DBIx/Class/Manual/Cookbook.pod#Searching
On Fri, Apr 27, 2012 at 10:09 AM, Kenneth S Mclane <[email protected]>wrote:
>
> I swear I tried that and it still didn't work. It does now, thank you. Can
> you tell me what I need to add to "$c->stash(accounts => [
> $c->model('ORANGES::AccountView')->all ]);" to sort by the account_code in
> ascending order? It's obviously "sort, but the actual syntax is what I'm
> looking for. Thanks again.
>
>
>
> From: Will Crawford <[email protected]> To: The elegant MVC web
> framework <[email protected]> Date: 04/27/2012 09:55 AM Subject: Re:
> [Catalyst] No data showing
> ------------------------------
>
>
>
>
>
> On 27 April 2012 15:50, Kenneth S Mclane
> <*[email protected]*<[email protected]>>
> wrote:
> This was a test to make sure I was actually getting data. My intention is
> to return all rows in pager format. I haven't made it to that part yet.
> Here is my template code:
>
> <table width="100%" border="1">
> <tr><th>Department</th><th>Account Code</th><th>Account
> Name</th><th>Policy</th><th>Compliant</th><th>Servers</th><th>Subsystems</th><th>Complete</th><th>Status</th></tr>
> [% # Display each account in a table row %]
> [% FOREACH account IN accounts -%]
> ^^^^^^^
> <tr>
> <td>1[% accounts.department_id %]</td>
> ^^^^^^^^
>
> You're simply referring to the list instead of the item here.
> _______________________________________________
> List: [email protected]
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/[email protected]/
> Dev site: http://dev.catalyst.perl.org/
>
>
>
> _______________________________________________
> List: [email protected]
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/[email protected]/
> Dev site: http://dev.catalyst.perl.org/
>
>
--
"We act as though comfort and luxury were the chief requirements of life,
when all that we need to make us happy is something to be enthusiastic
about." -- Albert Einstein
_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
