[rt-users] Help with Ticket Count

[Jeff Stark]

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     jstark at sumtotalsystems.com

 
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).
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070718/32dea618/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook.jpg
Type: image/jpeg
Size: 10671 bytes
Desc: Outlook.jpg
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070718/32dea618/attachment.jpg>