Displaying Stalled Tickets

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 :frowning: ).

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 :frowning: ).

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
-----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-----