Hello, I am trying to create a view similar to the QuickSearch view. 3.6.3, Oracle 10g, apache on RHEL. I have the view working great, the links when I click them show the correct tickets, etc. However, the Tickets->Count is only returning for the first query. I have updated the view to include an "x" so that I could test the links.
Does anyone know why my Tickets->Count would not be returning as
expected?
<table border="0" cellspacing="0" cellpadding="1" width="100%">
<tr>
<th class="collection-as-table"><&|/l&>Severity Level</&></th>
% for my $condition (@$conditions) {
<th class="collection-as-table" align="right"><%
$condition->{name} %></th>
% }
</tr>
% my $i;
% for my $sevlevel (@sevlevels) {
% $i++;
% my $sevlevel_cond = " 'CF.{Severity Level}' = '$sevlevel' AND ";
% my $all_q = $sevlevel_cond . " ( Status = 'open' OR Status = 'new'
OR Status = 'stalled' ) AND ";
<tr class="<% $i%2 ? 'oddline' : 'evenline'%>" >
<td><a href="<%
$RT::WebPath%>/Search/Results.html?Query=<%$all_q%>&Format=<%$Format%>"
title="<% substr($sevlevel,0, 5) %>"><% substr($sevlevel,0,
5)%></a></td>
% for my $condition (@$conditions) {
% $Tickets->FromSQL($all_q.$condition->{cond}),
<td align="right"><a href="<%
$RT::WebPath%>/Search/Results.html?Query=<%$all_q.$condition->{cond}%>&F
ormat=<%$Format%>"><% $Tickets->Count %> x</a></td>
% }
</tr>
% }
</table>
Jeff Stark, Sr Systems Administrator
SumTotal Systems, Inc. (Nasdaq; SUMT)
OFFICE +1 919 326 7548
MOBILE +1 919 622 0418
EMAIL [EMAIL PROTECTED]
The contents of this communication are considered SumTotal Confidential,
and should not be shared with anyone outside of SumTotal, either
electronically or verbally, without the express permission of the
author(s).
<<Outlook.jpg>>
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
