Any one have a quick and dirty for displaying stalled tickets under
Quick Search?
Tim
Any one have a quick and dirty for displaying stalled tickets under
Quick Search?
Tim
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@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
<&|/l&>Stall</&>
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
< <%$new%>
< <%$open%>
/Search/Results.html?Query=<%$new_q%>&Rows=50"><% $new
%>/Search/Results.html?Query=<%$open_q%>&Rows=50"><% $open
%>/Search/Results.html?Query=<%$stall_q%>&Rows=50"><% $stall
%>–stephen
Stephen Dowdy - Systems Administrator - NCAR/RAP
303.497.2869 - sdowdy@ucar.edu - http://www.rap.ucar.edu/~sdowdy/
-----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@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
<&|/l&>Stall</&>
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
< <%$new%>
/Search/Results.html?Query=<%$new_q%>&Rows=50"><% $new
%>/Search/Results.html?Query=<%$open_q%>&Rows=50"><% $open
%>/Search/Results.html?Query=<%$stall_q%>&Rows=50"><% $stall
%>–stephen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.orgiD8DBQFDAlZdgA0gpghkf88RAp36AJ9loJ3sMaVwvKp64+8CfH+n5bP31gCfXmVk
NSS00/FfjVlzKpWBwJ2AZ98=
=evxJ
-----END PGP SIGNATURE-----