[Catalyst] Datagrid with details view?

Kenneth S Mclane ksmclane at us.ibm.com
Thu Apr 5 18:07:16 GMT 2012

I am trying to duplicate a .aspx website. I have succeeded in getting a 
page based on a db view. In the original site you can click on a row and a 
details view appears at the bottom of the page. I don't know if this is 
possible, but I have been trying to simply get a second page to come up 
with the details. I created a view with the fields I need and re-created 
my schema. I created a controller and added this code:

sub detail :Local :Args(1) {
    my ($self, $c, $acctid) = @_;
    $c->stash(details => 
[$c->model('ORANGES::AccountDetails')->search({account_id => {'=', 
    $c->stash(template => 'accountdetails/detail.tt2');
This appears to create a valid sql query, I get results when running it 
directly on the db.

I added code to my list.tt2 file to create a link to the 
/accountdetails/detail URI by wrapping one of my TD in an href statement 
like this:

<td><a href="[% c.uri_for('/accountdetails/detail/') %][% 
account.account_id %]">[% account.account_code %]</a></td>

I created my detail.tt2 file containing this:

[% META title = 'Account Detail' -%]
<table border="1" style="width:33%;border-collapse:collapse;">

<tr style="backround-color:#F8F8F8;">
<td style="background-color:#E5ECF9;">Account Code</td><td>[% 
details.account_code %]</td></tr>
<tr style="backround-color:White;">
<td style="background-color:#E5ECF9;">Account Name</td><td>[% 
details.account_name %]</td></tr>
<tr style="backround-color:#F8F8F8;">
<td style="background-color:#E5ECF9;">Account Policy</td><td>[% 
details.account_policy %]</td></tr>
<tr style="backround-color:White;">
<td style="background-color:#E5ECF9;">Account Target</td><td>[% 
details.account_target %]</td></tr>
<tr style="backround-color:#F8F8F8;">
<td style="background-color:#E5ECF9;">Account Workitem</td><td>[% 
details.account_workitem %]</td></tr>
<tr style="backround-color:White;">
<td style="background-color:#E5ECF9;">Start Date</td><td>[% 
details.start_date %]</td></tr>
<tr style="backround-color:#F8F8F8;">
<td style="background-color:#E5ECF9;">Kit Date</td><td>[% details.kit_date 
<tr style="backround-color:White;">
<td style="background-color:#E5ECF9;">Upgrade Date</td><td>[% 
details.upgrade_date %]</td></tr>
<tr style="backround-color:#F8F8F8;">
<td style="background-color:#E5ECF9;">Approval Date</td><td>[% 
details.approval_date %]</td></tr>
<tr style="backround-color:White;">
<td style="background-color:#E5ECF9;">Sunset Date</td><td>[% 
details.sunset_date %]</td></tr>
<tr style="backround-color:#F8F8F8;">
<td style="background-color:#E5ECF9;">Alert Flag</td><td>[% 
details.alert_flag %]</td></tr>
<tr style="backround-color:White;">
<td style="background-color:#E5ECF9;">Cirats Flag</td><td>[% 
details.cirats_flag %]</td></tr>
<tr style="backround-color:#F8F8F8;">
<td style="background-color:#E5ECF9;">Report Flag</td><td>[% 
details.report_flag %]</td></tr>
<tr style="backround-color:White;">
<td style="background-color:#E5ECF9;">Sample Flag</td><td>[% 
details.sample_flag %]</td></tr>
<tr style="backround-color:#F8F8F8;">
<td style="background-color:#E5ECF9;">Sample Rate</td><td>[% 
details.sample_rate %]</td></tr>
<tr style="backround-color:White;">
<td style="background-color:#E5ECF9;">Department Code</td><td>[% 
details.department_code %]</td></tr>


My link works, I get the detail page with all the formatting and the 
pre-populated TD's, but the data is not showing up. I think I am missing 

Once again all help is appreciated.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20120405/f6b1697e/attachment.htm

More information about the Catalyst mailing list