[rt-users] Displaying Stalled Tickets

[Joby Walker]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The 3.5.2 version has a stalled column.

Joby Walker
ITI SSG, University of Washington
- --
PGP key: https://staff.washington.edu/joby/joby-u-pub.asc


Stephen Dowdy wrote:
> Tim Suter wrote:
> 
>> Any one have a quick and dirty for displaying stalled tickets under
>> Quick Search?
>>
>> Tim
> 
> 
> Tim,
> 
> Here's what i do in rt3.4.0 for the local "QuickSearch" Element.
> 
> It also includes a lame hack to force a RED background for a quick
> visual highlight on any queue list (new,open,stalled) for having > 5 NEW
> or STALLED tickets or > 50 open tickets.  (these are hardcoded :-( ).
> 
> 
> saw:Elements# diff /opt/rt3/share/html/Elements/Quicksearch Quicksearch
> 45a46,52
>> %#RAL BEGIN RAL TAGGED BLOCK }}}
>> %#RAL Modification:
>> %#RAL 11-Feb-2005 (sdowdy at ucar.edu)
>> %#RAL         Add in threshhold evaluation to set a background-color
> style of
>> %#RAL         RED on Queue New/Open/Stalled.  (todo: use per-queue
>> %#RAL         customfields for threshhold values?)
>> %#RAL END RAL TAGGED BLOCK }}}
> 52a60
>>        <th class="collection-as-table" align=right><&|/l&>Stall</&></th>
> 62c70,71
> <         my $all_q = "Queue = '".$queue->Name."' AND (Status = 'open'
> OR Status = 'new')";
> ---
>>         my $stall_q = "Queue = '".$queue->Name."' AND Status =
> 'stalled'";
>>         my $all_q = "Queue = '".$queue->Name."' AND (Status = 'open'
> OR Status = 'new' OR Status = 'stalled')";
> 69a79,81
>>         $Tickets->FromSQL($stall_q);
>>      my $stall = $Tickets->Count();
>>
> 76,77c88,90
> < <td align="right"><A HREF="<%
> $RT::WebPath%>/Search/Results.html?Query=<%$new_q%>&Rows=50"><%$new%></a></TD>
> 
> < <td align="right"><A HREF="<%
> $RT::WebPath%>/Search/Results.html?Query=<%$open_q%>&Rows=50"><%$open%></a></TD>
> 
> ---
>> <td align="right" style="<% $new > 5 ? 'background-color: red' : ''
> %>"><A HREF="<%
> $RT::WebPath%>/Search/Results.html?Query=<%$new_q%>&Rows=50"><% $new
> %></a></TD>
>> <td align="right" style="<% $open > 50 ? 'background-color: red' : ''
> %>" ><A HREF="<%
> $RT::WebPath%>/Search/Results.html?Query=<%$open_q%>&Rows=50"><% $open
> %></a></TD>
>> <td align="right" style="<% $stall > 5 ? 'background-color: red' : ''
> %>" ><A HREF="<%
> $RT::WebPath%>/Search/Results.html?Query=<%$stall_q%>&Rows=50"><% $stall
> %></a></TD>
> 
> --stephen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDAlZdgA0gpghkf88RAp36AJ9loJ3sMaVwvKp64+8CfH+n5bP31gCfXmVk
NSS00/FfjVlzKpWBwJ2AZ98=
=evxJ
-----END PGP SIGNATURE-----