<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=809363513-18072007><FONT face=Arial size=2>Hello, I am trying
to create a view similar to the QuickSearch view.</FONT></SPAN></DIV>
<DIV><SPAN class=809363513-18072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=809363513-18072007>
<DIV><SPAN class=809363513-18072007><FONT face=Arial size=2>3.6.3, Oracle 10g,
apache on RHEL.</FONT></SPAN></DIV></SPAN></DIV>
<DIV><SPAN class=809363513-18072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=809363513-18072007><FONT face=Arial size=2>I have the view
working great, the links when I click them show the correct tickets,
etc.</FONT></SPAN></DIV>
<DIV><SPAN class=809363513-18072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=809363513-18072007><FONT face=Arial size=2>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.
</FONT></SPAN></DIV>
<DIV><SPAN class=809363513-18072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=809363513-18072007><FONT face=Arial size=2>Does anyone know why
my Tickets->Count would not be returning as expected?</FONT></SPAN></DIV>
<DIV><SPAN class=809363513-18072007></SPAN><SPAN
class=809363513-18072007></SPAN><SPAN class=809363513-18072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=809363513-18072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial size=2><IMG
src="cid:809363513@18072007-20E5"></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><table border="0" cellspacing="0"
cellpadding="1"
width="100%"><BR><tr><BR> <th
class="collection-as-table"><&|/l&>Severity
Level</&></th><BR>% for my $condition (@$conditions)
{<BR> <th class="collection-as-table"
align="right"><% $condition->{name} %></th><BR>%
}<BR></tr><BR>% my $i;<BR>% for my $sevlevel (@sevlevels)
{<BR>% $i++;<BR>% my $sevlevel_cond = " 'CF.{Severity
Level}' = '$sevlevel' AND ";<BR>% my $all_q = $sevlevel_cond .
" ( Status = 'open' OR Status = 'new' OR Status = 'stalled' ) AND
";<BR><tr class="<% $i%2 ? 'oddline' : 'evenline'%>"
><BR><td><a href="<%
$RT::WebPath%>/Search/Results.html?Query=<%$all_q%>&Format=<%$Format%>"
title="<% substr($sevlevel,0, 5) %>"><% substr($sevlevel,0,
5)%></a></td><BR>% for my $condition (@$conditions)
{<BR>%
$Tickets->FromSQL($all_q.$condition->{cond}),<BR><td
align="right"><a href="<%
$RT::WebPath%>/Search/Results.html?Query=<%$all_q.$condition->{cond}%>&Format=<%$Format%>"><%
$Tickets->Count %> x</a></td><BR>%
}<BR></tr><BR>% }<BR></table></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV><SPAN
style="FONT-SIZE: 9pt; COLOR: #587076; FONT-FAMILY: 'Microsoft Sans Serif'">
<P class=MsoNormal
style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-pagination: none; tab-stops: 3.0in; mso-layout-grid-align: none"
align=left><FONT size=2><SPAN><STRONG><FONT size=3><FONT size=2>Jeff
Stark, Sr Systems Administrator</FONT><SPAN
style="mso-tab-count: 1">
</SPAN><BR></FONT></STRONG>SumTotal Systems, Inc. (<SPAN
class=grame>Nasdaq</SPAN>; SUMT)<SPAN
style="mso-tab-count: 1">
</SPAN><BR></P></SPAN></FONT>
<P class=MsoNormal
style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-pagination: none; mso-layout-grid-align: none"
align=left><FONT size=1><SPAN><STRONG>OFFICE</STRONG> <SPAN
style="mso-tab-count: 1"></SPAN>+1 919 326 7548<BR><STRONG>MOBILE</STRONG><FONT
color=#000000> </FONT>+1 919 622 0418</SPAN></FONT></P>
<P class=MsoNormal
style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-pagination: none; mso-layout-grid-align: none"
align=left><FONT size=1><SPAN><STRONG>EMAIL<SPAN
style="mso-tab-count: 1"> </SPAN></STRONG></SPAN><SPAN
style="FONT-SIZE: 9pt; COLOR: #587076; FONT-FAMILY: 'Microsoft Sans Serif'"><A
title=mailto:jstark@sumtotalsystems.com
href="mailto:jstark@sumtotalsystems.com">jstark@sumtotalsystems.com</A></SPAN></FONT></SPAN></P>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN style="COLOR: red"><STRONG><FONT color=#808080>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).<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office"
/><o:p></o:p></FONT></STRONG></SPAN></DIV></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>