Request Tracker Wiki - User contributions [en]

SessionTimeout

2020-02-14T14:07:30Z

LB: Allow users to find Session Timeout settings more easy.

There are several solutions to managing your Session in Request Tracker

= RT 4.x =

Tested only with 4.4.4, but probably also valid for older 4.x versions.

== Option 1: AutoLogoff ==

Set `AutoLogoff` Setting in your config, i.e. to 60 Minutes:

<pre><nowiki>
Set($AutoLogoff, 60);
</nowiki></pre>

According to the RT_Config docs, setting this value automatically logs off any user after 60 minutes of inactivity (i.e. 60 minutes after your last action).

Source: https://docs.bestpractical.com/rt/4.4.4/RT_Config.html#AutoLogoff

== Option 2: SetupSessionCookie ==

Alternative: Set $Expires next to $SessionCookie in /opt/rt/share/html/Elements/SetupSessionCookie

<pre><nowiki>
$SessionCookie => undef
$Expires => '+8h'
</nowiki></pre>

This means any session inactive for more than 8h (i.e. no action done in 8h), will expired. This alone is not enough to ensure the session won't work anymore.

You need to setup a cronjob to clean up old sessions, because the session cookies in your browser won't have an expiry date and the sessions in the database will remain there, unless cleaned up by a cronjob.

<pre><nowiki>
/opt/rt/sbin/rt-clean-sessions --older 1H
</nowiki></pre>

Add --skip-user if you allow one user to possibly have multiple sessions at the same time, i.e. in different browsers or workstations. Add --debug to debug what is going an.

MakeClicky

2020-02-05T12:51:18Z

LB: Add Patch for Umlaut support. Fix syntax.

= 3.8.x =

This is now built-in functionality. From [[RT Config|RT_Config]].pm:

<pre><nowiki>=item C<@Active_MakeClicky>

MakeClicky detects various formats of data in headers and email messages,
and extends them with supporting links. By default, RT provides two formats:

* 'httpurl': detects http:// and https:// URLs and adds '[Open URL]' link after the URL.

* 'httpurl_overwrite': also detects URLs as 'httpurl' format, but replace URL with link
and *adds spaces* into text if it's longer then 30 chars. This allow browser to wrap long
URLs and avoid horizontal scrolling.

See F<share/html/Elements/MakeClicky> for documentation on how to add your own.

=cut

Set(@Active_MakeClicky, qw());

</nowiki></pre>

If you're new to this, the option you choose is contained in qw(), frex:
<pre><nowiki>
Set(@Active_MakeClicky, qw(httpurl));
</nowiki></pre>

Note that httpurl will result in things like
<pre><nowiki>
http://www.someplace.tld/path/morepath/etc/target.htm [Open URL]
</nowiki></pre>

where the [Open URL] is your clickable link. httpurl_overwrite will make the existing link clickable (oddly enough). Try both and see how it works on your links; don't forget to reload your webserver when you change it.

If you want to add your own actions be aware that the documentation in docs/extending_clickable_links.pod is not correct where it says to create the file ' local/html/[[MyCallbacks]]/Elements/[[MakeClicky]]/Default' it needs to be ' local/html/Callbacks/[[MyCallbacks]]/Elements/[[MakeClicky]]/Default' otherwise it will not be picked up by rt. Doc fixed in 3.8.5. '''NOTE''' that such things should be reported via bug tracker.

== Known Problems ==
; html #anchors
* httpurl_overwrite does not work well with http anchors like http://en.wikipedia.org/wiki/HTML_anchor#Anchor
* Workaround

<pre><nowiki>
cp $RTHOME/share/html/Elements/MakeClicky $RTHOME/local/html/Elements/MakeClicky
$EDITOR $RTHOME/local/html/Elements/MakeClicky
</nowiki></pre>

Now change regex to also match # qr@(?<!src=["'])https?:([\w\/\@\-~%#?=;,.:+\[\]]|\&|\[\])+[\w\/]@,
<pre><nowiki>
my @types = (
{
name => "httpurl",
regex => qr/$RE{URI}{HTTP}{-keep}{-scheme => 'https?'}/,
action => "url",
},
{
name => "httpurl_overwrite",
#regex => qr/$RE{URI}{HTTP}{-keep}{-scheme => 'https?'}/,
regex => qr@(?<!src=["'])https?:([\w\/\@\-~%#?=;,.:+\[\]]|\&|\[\])+[\w\/]@,
action => "url_overwrite",
},
);
</nowiki></pre>

= Earlier Versions =

This is a patch to make links clickable when displaying a ticket. Works for 3.0, success has been reported for 3.4 too.

Regexp based on work by Abigail. As always, mind the tab damage.

<pre><nowiki>
$ diff -u /usr{,/local}/share/request-tracker3/html/Ticket/Elements/ShowMessageStanza
--- /usr/share/request-tracker3/html/Ticket/Elements/ShowMessageStanza 2004-02-13 19:21:02.000000000 +0100
+++ /usr/local/share/request-tracker3/html/Ticket/Elements/ShowMessageStanza 2005-05-08 01:04:15.000000000 +0200
@@ -37,6 +37,9 @@
$m->comp('/Elements/Callback', content => \$content, %ARGS);
$content =~ s/\n/<br>/gi;

+ # Make URLs in plaintext clickable. This is dangerous!
+ $content =~ s@(https?://(?:(?:(?:(?:(?:[a-zA-Z\d](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?))|(?:(?:\d+)(?:\.(?:\d+)){3}))(?::(?:\d+))?)(?:/(?:(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[;:\@&=#])*)(?:/(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[;:\@&=#])*))*)(?:\?(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[;:\@&=#])*))?)?)|(?:ftp://(?:(?:(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[;?&=])*)(?::(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[;?&=])*))?\@)?(?:(?:(?:(?:(?:[a-zA-Z\d](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?)\.)*(?:[a-zA-Z](?:(?:[a-zA-Z\d]|-)*[a-zA-Z\d])?))|(?:(?:\d+)(?:\.(?:\d+)){3}))(?::(?:\d+))?))(?:/(?:(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[?:\@&=])*)(?:/(?:(?:(?:[a-zA-Z\d$\-_.+!*'(),]|(?:%[a-fA-F\d]{2}))|[?:\@&=])*))*)(?:;type=[AIDaid])?)?)|(?:mailto:(?:(?:[a-zA-Z\d$\-_.+!*'(),;/?:\@&=]|(?:%[a-fA-F\d]{2}))+))@<a href=\"$1\" target=\"_blank\">$1</a>@g;
+
</%perl>
<%$content |n%><br>
% }
</nowiki></pre>
----

Alternatively you could implement this callback by Dirk Pape which goes in

[=$your-rt-path/local/html/Callbacks/MI/Ticket/Elements/[[ShowMessageStanza]]/Default]
<pre><nowiki>
<%init>
my $val = $$content;
use bytes;
$val =~ s/https?:([\w\/\@\-~%#?=;,.:+]|\&)+[\w\/]/<a href="$&" target="_blank">$&<\/a>/gi;
$val =~ s/(s?ftp|ftps):[\w\/\.:+\-]+/<a href="$&">$&<\/a>/gi;
$val =~ s/(mailto:)?([a-zA-Z0-9_\+\-\.]+\@([a-zA-Z0-9][\w\.\+\-]+\.[a-zA-Z]{2,})(\?([\w\/\@\-~%#?=;,.:+]|\&)+[\w\/])?)/<a href="mailto:$2">$&<\/a>/gi;
$val =~ s/\<((url:\s*)?\w+:[^&<>]+)\>/<<a href="$1" target="_blank">$1<\/a>>/gi;
$$content = $val;
</%init>
<%args>
$content => undef
</%args>
</nowiki></pre>
----

For what it's worth, the above file content worked for me accept for the 6th line, which contains the "mailto:" parsing. My system complained about the syntax of this line. I deleted it from my Default file, and all works well on my resulting RT 3.4.2 system.

-Matt England

----

There was a typo in line 6. It read "$val =~ s/(mailto ... <\/a>/ gi;" but the space before "gi" is too much. I removed it, and removed the cached file [=/var/cache/request-tracker3.4/mason_data/obj/local/Callbacks/MI/Ticket/Elements/[[ShowMessageStanza]]/Default] (on our server). It then worked as expected.

-Andreas

----

A small enhancement to Disk's Callback method, where long http(s) URL's are truncated when displayed:

<pre><nowiki>
<%init>
my $val = $$content;
use bytes;
my @parts = ();
my @markup = ();

my $max_length = 67;
my $http_regex = 'https?:[\w\/\@\-~%#?=;,.:+&]+[\w\/]';
my $ftp_regex = '(s?ftp|ftps):[\w\/\.:+\-]+';
my $mail_regex = '(mailto:)?([a-zA-Z0-9_\+\-\.]+\@([a-zA-Z0-9][\w\.\+\-]+\.[a-zA-Z]{2,})(\?([\w\/\@\-~%#?=;,.:+]|\&)+[\w\/])?)';
my $url_regex = '\<((url:\s*)?\w+:[^&<>]+)\>';

$val =~ s/$ftp_regex/<a href="$&">$&<\/a>/gi;
$val =~ s/$mail_regex/<a href="mailto:$2">$&<\/a>/gi;
$val =~ s/$url_regex/<a href="$1" target="_blank">$1<\/a>/gi;

@parts = split(/($http_regex)/, $val);
foreach my $bit (@parts) {
if ($bit =~ m/$http_regex/) {
if (length($bit) < $max_length) {
$bit = '<a href="'.$bit.'" target="_blank">'.$bit.'</a>';
} else {
$bit = '<a href="'.$bit.'" target="_blank">'.substr($bit, 0, $max_length).'...</a>';
}
}
push(@markup, $bit);
}

$$content = join("", @markup);
</%init>

<%args>
$content => undef
</%args>
</nowiki></pre>

-Shane PS Copy it in "Edit" mode

= URL with special characters =

This is not a direct edit of MakeClicky, but it's a fix for a problem that MakeClicky can't and should be handled by the module used by MakeClicky (which is Regexp::Common).

As of RT 4.4.4 (using Regexp::Common Version 2013031301-1 or 2017060201), there is no support for URLs that contain Umlaut characters in their path.

This patch adds support for german Umlauts and other special language characters to Regexp::Common::URI. Note that this is an external Perl module, not directly provided by Bestpractical.

<pre><nowiki>
diff -ur /usr/share/perl5/Regexp/Common/URI/RFC2396.pm.orig /usr/share/perl5/Regexp/Common/URI/RFC2396.pm
--- /usr/share/perl5/Regexp/Common/URI/RFC2396.pm.orig 2020-02-05 11:23:35.217557749 +0000
+++ /usr/share/perl5/Regexp/Common/URI/RFC2396.pm 2020-02-05 12:02:50.441450768 +0000
@@ -54,12 +54,12 @@
# unreserved | escaped | [:@&=+$,]
$uric = "(?:[;/?:\@&=+\$,a-zA-Z0-9\\-_.!~*'()]|$escaped)";
# reserved | unreserved | escaped
-$urics = "(?:(?:[;/?:\@&=+\$,a-zA-Z0-9\\-_.!~*'()]+|" .
+$urics = "(?:(?:[;/?:\@&=+\$,a-zA-Z0-9\x7f-\xff\\-_.!~*'()]+|" .
"$escaped)*)";

$query = $urics;
$fragment = $urics;
-$param = "(?:(?:[a-zA-Z0-9\\-_.!~*'():\@&=+\$,]+|$escaped)*)";
+$param = "(?:(?:[a-zA-Z0-9\x7f-\xff\\-_.!~*'():\@&=+\$,]+|$escaped)*)";
$segment = "(?:$param(?:;$param)*)";
$path_segments = "(?:$segment(?:/$segment)*)";
$ftp_segments = "(?:$param(?:/$param)*)"; # NOT from RFC 2396.
</nowiki></pre>

The character range is currently <code>\x7f-\xff</code>, extend it if you need other characters.

This will parse URLs correctly, that have special characters in them.

If you need support for special character domains, also change <code>$domainlabel</code>.

---

[[Category:3.8.x]]
[[Category:Configuration]]
{{Template:3.8.x}}
{{Template:Configuration}}

ForceHTTPSLogin

2020-02-01T11:17:40Z

LB: Add syntaxhighlight tags to show code properly.

<syntaxhighlight>
#
# rt-3.4.5-ForceHTTPSLogin.patch
#
# Warning: this patch is under devel, barely tested!!!
#
# * 2005.01.13 Paulo Matos <paulo.matos@fct.unl.pt>
# - Updated to apply directly to 3.4.5.
# * 2005.01.06 Paulo Matos <paulo.matos@fct.unl.pt>
# - Redirect to https when credentials are not found;
# - Redirect to http when credentials are found;
# - Changed cookiename removing SERVER_PORT.
#
diff -uNr rt-3.4.5.orig/html/autohandler rt-3.4.5/html/autohandler
--- rt-3.4.5.orig/html/autohandler 2005-02-01 14:20:40.000000000 +0000
+++ rt-3.4.5/html/autohandler 2006-01-13 01:20:03.000000000 +0000
@@ -72,6 +72,11 @@

$m->comp('/Elements/SetupSessionCookie', %ARGS);

+# check credentials and HTTPS, if so redirect to HTTP
+if ($session{'CurrentUser'} && $session{'CurrentUser'}->Id && $ENV{'HTTPS'}) {
+ $m->redirect('http://'.$ENV{SERVER_NAME}.$ENV{REQUEST_URI});
+}
+
unless ($session{'CurrentUser'} && $session{'CurrentUser'}->Id) {
$session{'CurrentUser'} = RT::CurrentUser->new();
}
@@ -218,6 +223,10 @@

# If we have no credentials
else {
+ # check if we are in HTTPS mode
+ if (! $ENV{'HTTPS'} ) {
+ $m->redirect('https://'.$ENV{SERVER_NAME}.$ENV{REQUEST_URI});
+ }
$m->comp('/Elements/Login', %ARGS);
$m->abort();
}
diff -uNr rt-3.4.5.orig/html/Elements/SetupSessionCookie rt-3.4.5/html/Elements/SetupSessionCookie
--- rt-3.4.5.orig/html/Elements/SetupSessionCookie 2005-04-18 02:44:50.000000000 +0100
+++ rt-3.4.5/html/Elements/SetupSessionCookie 2006-01-13 01:20:03.000000000 +0000
@@ -47,7 +47,9 @@
return if $m->is_subrequest; # avoid reentrancy, as suggested by masonbook

my %cookies = CGI::Cookie->fetch();
-my $cookiename = "RT_SID_".$RT::rtname.".".$ENV{'SERVER_PORT'};
+# removed SERVER_PORT from cookie name so it can be valid on HTTP and HTTPS
+#my $cookiename = "RT_SID_".$RT::rtname.".".$ENV{'SERVER_PORT'};
+my $cookiename = "RT_SID_".$RT::rtname.".".'0000';
my %backends = (
mysql => 'Apache::Session::MySQL',
Pg => 'Apache::Session::Postgres',
</syntaxhighlight>

PersistentSessions

2020-02-01T11:15:05Z

LB: Fix code formating errors, add syntax highlighting for perl.

If you would like to alleviate the need to constantly log in every time you close your browser, you can make the sessions persistent by modifying the cookie set to record the session ID. In the file Elements/[[SetupSessionCookie]] modify this code (near the bottom):

<syntaxhighlight lang="perl" line='line'>
if ( !$cookies{$cookiename} ) {
my $cookie = new CGI::Cookie(
-name => $cookiename,
-value => $session{_session_id},
-path => $RT::WebPath,
-secure => ($RT::WebSecureCookies ? 1 :0),
);
$r->headers_out->{'Set-Cookie'} = $cookie->as_string;
}
</syntaxhighlight>

to add an 'expires' key:

<syntaxhighlight lang="perl" line='line'>
if ( !$cookies{$cookiename} ) {
my $cookie = new CGI::Cookie(
-name => $cookiename,
-value => $session{_session_id},
-path => $RT::WebPath,
-secure => ($RT::WebSecureCookies ? 1 :0),
-expires => '+1M',
);
$r->headers_out->{'Set-Cookie'} = $cookie->as_string;
}
</syntaxhighlight>

This particular setting makes the session good for one month. You can find out what time values are valid by looking at the CGI.pm documentation: [http://search.cpan.org/~lds/CGI.pm-3.25/CGI.pm#CREATING_A_STANDARD_HTTP_HEADER: http://search.cpan.org/~lds/CGI.pm-3.25/CGI.pm#CREATING_A_STANDARD_HTTP_HEADER%3A]

Be sure to look at the following two articles to help clean up your old sessions (a good idea, evidently, whether or not you're planning on using this patch):

* RT 3.8.8

For RT 3.8.8 version you need to edit the file $RTHOME/lib/RT/Interface/Web.pm. Look for the "sub [[SendSessionCookie]]" function and add the '''-expires''' key as stated above.

* [[CleanupSessions]]

Tested on 3.8.7, file to modify is : /usr/share/request-tracker3.8/lib/RT/Interface/Web.pm (on a Debian/squeeze). -- jissouille

This was tested on RT 3.6.3, but I'm sure it would apply to most versions. -- [[JoeCasadonte]] I'm sure this should work for any version greater than 3.0.0 --[[RuslanZakirov]]

ShowStatusInColor

2018-04-23T18:34:15Z

LB: Fix: Correct directory path display without wiki links

Colorize ticket links based on status or, as in one example below, by priority.

== RT 3.8.2 ==

=== Simple ===

Below is a modified local/html/Elements/ShowLink. It will display inter-ticket links colored to match the status of the ticket with the same color scheme used in graphs, via inline CSS. --Jerrad

<pre><a href="<%$URI->Resolver->HREF%>">
% if ($URI->IsLocal) {
% my $member = $URI->Object;
% if (UNIVERSAL::isa($member, "RT::Ticket")) {

#Customization
<%perl>
require RT::Graph::Tickets;
my $status = $member->Status;
my $class = $member->QueueObj->IsInactiveStatus($status)?'ticket-inactive':'';
my $color = $RT::Graph::Tickets::ticket_status_style{$status}->{'fontcolor'};
</%perl>
<span class="<% $class %>" style="color: <% $color %>">

<%$member->Id%>: (<%$member->OwnerObj->Name%>) <%$member->Subject%> [<% loc($member->Status) %>]
</span>

% } elsif ( UNIVERSAL::can($member, 'Name')) {
<%$URI->Resolver->AsString%>: <%$member->Name%>
% } else {
<%$URI->Resolver->AsString%>
% }
% } else {
<%$URI->Resolver->AsString%>
% }
</a>
<%ARGS>
$URI => undef
</%ARGS>
</pre>

=== Full-featured ===

by Dan Cook, updated with CSS callback dox by Matt Zagrabelny

This is how I've set things up. I have shamelessly robbed most of this from the posts above (Thanks Guys!).

(And Baylink, in turn, moved it to the top; if you're running older code, read on down. In particular, I modified the Colored-Priority code to use inline styles and reverse out the color into the background a bit further down.)

* Create the directory: `<RTInstallationDir>/local/html/Callbacks/MyCallbacks/Elements/RT__Ticket/ColumnMap`

You can do that, in Linux, by typing

<pre># mkdir -p local/html/Callbacks/MyCallbacks/Elements/RT__Ticket/ColumnMap</pre>

from your RT installation directory, which is /opt/rt3 unless someone built it differently.

* Note: There are '''2 underscores''' between RT and Ticket

Then you can

<pre># cd local/html/Callbacks/MyCallbacks/Elements/RT__Ticket/ColumnMap</pre>

to create the file, which is '''also named''' [[ColumnMap]], and should contain this:

----
8<-----------------------------8<----------
<pre>
<%INIT>

sub statusInColor {
my $Ticket = shift;
my $status = $Ticket->Status;
my $css = "status" . lc $status;
my $LastUpdater = $Ticket->LastUpdatedByObj->EmailAddress;
my $TicketRequestors = $Ticket->Requestors->MemberEmailAddressesAsString;
my $TicketCC = $Ticket->Cc->MemberEmailAddressesAsString;

if (($TicketRequestors =~ $LastUpdater) || ($TicketCC =~ $LastUpdater))
{
$css = "status" . lc "reply";
$status = "<div class=\"$css\">$status REP</div>";
}
else {
$status = "<div class=\"$css\">$status</div>";
}

return \"$status";
}

$COLUMN_MAP->{Status}->{value} = \&statusInColor;

</%INIT>
<%ARGS>
$COLUMN_MAP => undef
</%ARGS>

----
8<-----------------------------8<----------
</pre>

* Onto the next part...
* RT 3.8 and up use a different CSS theme. Web2 is the default theme.
* If you use other themes you will need to do the following steps for each theme you use.
* Create the directory: <RTInstallationDir>/local/html/Callbacks/<SiteCallbacks>/NoAuth/css/web2/main.css`
* Create the file: `<RTInstallationDir>/local/html/Callbacks/<SiteCallbacks>/NoAuth/css/web2/main.css/End`

And in that file, put:

<pre>
@import "statuscolor.css";

* In the directory just created `<RTInstallationDir>/local/html/NoAuth/css/web2` you will need to create a new file.
* Name the file statuscolor.css and place the following content in it.

/* Status Colours */

.statusnew {
color: #bb0000;
text-align: left;
font-weight: bold;
}

.statusopen {
color: #0000bb;
text-align: left;
font-weight: bold;
}

.statusreply {
color: #00bb00;
text-align: left;
font-weight: bold;
}

.statusresolved {
color: #888888;
text-align: left;
font-weight: bold;
}

.statusrejected {
color: #884444;
text-align: left;
font-weight: bold;
}
</pre>

* Don't forget to clear your Mason cache (apache restart, unless you've enabled $[[DevelMode]] in [[RT SiteConfig|RT_SiteConfig]].pm) and perform a "hard" refresh in your browser (Shift + Ctrl + R) to clear your local CSS cache.

So basically what you will get from the above is the status' listed in the statuscolor.css file will be colored. You may edit the statuscolor.css file to suit your needs. Just make sure you follow the convention of the file format i.e. to color status stalled you would use something like:

<pre>
.statusstalled {

color: #884422;
text-align: left;
font-weight: bold;

}
</pre>

and so on so forth. Next thing to note is that along with coloring the status this also puts an REP flag next to any tickets where the last reply is by the requestor or cc (i.e. not the staff) (Thanks Johan Baarman !)

----

== RT 3.8.x/4.0.x ==

==== Full featured ColumnMap script ====

by Alex Young

Confirmed working with 3.8.2, 3.8.6, 3.8.8.

Confirmed working with 4.0.x, but ColumnMap file is renamed to Once, and web2 location is changed to aileron.

I have combined the scripts on this wiki page to work in 3.8.x/4.0.x, so thanks to all the people that did all the hard work! Only the [[ColumnMap]] file is different from the other guides on this page.

Changes from the other scripts

* Changes REP flag to New Reply.
* Doesn't display New Reply when the current user is the last to comment.
* New Reply tag is displayed in its own colour, while keeping the default status colours.
* New Reply tag links to the last unread message and can mark the messages as read.
* New Reply tag isn't displayed if there are no unread messages.
* Changed colours for Priorities. Removed light colours that prevented the text from being easily read on a white background.
* Updated Extended Status code to display number of pending tickets.

This uses a similar statuscolor.css file found elsewhere on this page. Follow those instructions for setup, or use the following contents.

/* Status Colours */

.statusnew { color: #bb0000; text-align: left; font-weight: bold;}
.statusopen { color: #0000bb; text-align: left; font-weight: bold;}
.statusreply { color: #009900; text-align: left; font-weight: bold;}
.statusresolved { color: #737373; text-align: left; font-weight: bold;}
.statusrejected { color: #884444; text-align: left; font-weight: bold;}
.statusstalled { color: #884444; text-align: left; font-weight: bold;}

The files should map to your system like so:
<pre>

<RTInstallationDir>/local/html/
`-- Callbacks
`-- MyCallbacks
|-- Elements
| `-- RT__Ticket
| `-- ColumnMap
| `-- ColumnMap|Once
`-- NoAuth
`-- css
`-- web2|aileron
`-- main.css
`-- End
<RTInstallationDir>/local/html/
`-- NoAuth/
`-- css
`-- web2|aileron
`-- statuscolor.css
</pre>

Here's the complete `<RTInstallationDir>/local/html/Callbacks/MyCallbacks/Elements/RT__Ticket/ColumnMap/ColumnMap` script.

<pre><%INIT>

# Show status in colour.
sub statusInColor {
my $Ticket = shift;
my $status = $Ticket->Status;
my $css = "status" . lc $status;
my $cssreply = "status" . lc "reply";
my $LastUpdater = $Ticket->LastUpdatedByObj->EmailAddress;
my $TicketRequestors = $Ticket->Requestors->MemberEmailAddressesAsString;
my $TicketCC = $Ticket->Cc->MemberEmailAddressesAsString;
my $CurrentUser = $session{'CurrentUser'}->EmailAddress;

# Added $CurentUser ne $LastUpdater to prevent showing New Reply tag when the last updater is the current user.
if (($CurrentUser ne $LastUpdater) && ($TicketRequestors =~ $LastUpdater) || ($TicketCC =~ $LastUpdater))
{
my $txn = $Ticket->SeenUpTo or return \"<div class=\"$css\">$status</div>";
# my $TicketLink = RT->Config->Get('WebPath') ."/Ticket/Display.html?id=". $Ticket->id. "#txn-".$txn->id;
# Comment out the line above and uncomment the following line to mark posts as seen when following link.
my $TicketLink = RT->Config->Get('WebPath') ."/Ticket/Display.html?id=". $Ticket->id ."&MarkAsSeen=1". "#txn-".$txn->id;
$status = "<div class=\"$css\">$status <a href=\"$TicketLink\"><span class=\"$cssreply\">New Reply</span></a></div>";
}
else {
$status = "<div class=\"$css\">$status</div>";
}

return \"$status";

}

# Show extended status in colour. This will change the front page and other search pages where the ExtendedStatus is displayed.
sub extStatusInColor {
my $Ticket = shift;
if ( my $count = $Ticket->HasUnresolvedDependencies ) {
my $status;

if ( $Ticket->HasUnresolvedDependencies( Type => 'approval' )
or $Ticket->HasUnresolvedDependencies( Type => 'code' ) ) {
$status = "<em>" . loc('(pending approval)') . "</em>";
} else {
$status = "<em>" . loc('(pending [quant,_1,other ticket])',$count) . "</em>";
}
return \$status;
} else {
return statusInColor($Ticket);

}
}

# Set the priority numbers to a colour.
sub PriorityInColor {
my $Ticket = shift;

my $priority = $Ticket->Priority;
my $colors = undef;

# Change priority numbers to reflect your priority system.
if ($priority >= '50') {
$colors = "#FF0000";
} elsif ($priority >= '45') {
$colors = "#FF2000";
} elsif ($priority >= '40') {
$colors = "#FF4000";
} elsif ($priority >= '35') {
$colors = "#FF6A00";
} elsif ($priority >= '30') {
$colors = "#FF6600";
} elsif ($priority >= '25') {
$colors = "#FFA000";
} elsif ($priority >= '20') {
$colors = "#0033CC";
} elsif ($priority >= '15') {
$colors = "#809FFE";
} elsif ($priority >= '10') {
$colors = "#004600";
} elsif ($priority >= '5') {
$colors = "#006400";
} elsif ($priority >= '0') {
$colors = "#009000";
}

if ($colors) {
$priority = "<div style=\"color: $colors;\">$priority</div>"
}

return \"<b>$priority</b>";
}

# Comment out any line to disable colour change.
$COLUMN_MAP->{Priority}->{value} = \&PriorityInColor;
$COLUMN_MAP->{Status}->{value} = \&statusInColor;
$COLUMN_MAP->{ExtendedStatus}->{value} = \&extStatusInColor;

</%INIT>
<%ARGS>
$COLUMN_MAP => undef
</%ARGS>
</pre>

----

=== Earlier forms ===

* Tested and works in RT 3.2.x
* Results in a a reference error in 3.2.2
* Error in 3.4.1 - http://lists.bestpractical.com/pipermail/rt-users/2005-May/030943.html
* Works in 3.4.2, small change needed - http://lists.bestpractical.com/pipermail/rt-users/2005-August/033080.html
* Works in 3.6.1, added localization support (2007/5/11)
* Changes for 3.6.5, see below (2008/2/5)
* Working as below in 3.8.2 - 2009-Feb-12 Baylink

(Baylink reads further down... wow. Everyone else already did this. :-)

Simply do the following:

* Create the directory: `<RTInstallationDir>/local/html/Callbacks/MyCallbacks/Elements/RT__Ticket/ColumnMap`
* Put the contents of the following file into the file: `<RTInstallationDir>/local/html/Callbacks/MyCallbacks]]/Elements/RT__Ticket/ColumnMap/ColumnMap`

Note: in debian the right path is `/usr/local/share/request-tracker3.6/html/Callbacks/MyCallbacks/Elements/RT__Ticket/ColumnMap/ColumnMap`

----
<pre>
<%INIT>

sub statusInColor {
my $Ticket = shift;
my $status = $Ticket->Status;
my $color = undef;

if ($status eq 'new') {
$color = "900000";
} elsif ($status eq 'open') {
$color = "#AA8000";
} elsif ($status eq 'stalled') {
$color = "#000090";
} elsif ($status eq 'rejected') {
$color = "#999999";
} elsif ($status eq 'resolved') {
$color = "009000";
}

$status = loc($status);

if ( $Ticket->HasUnresolvedDependencies ) {
$status = "<i>$status<i>"
}

if ($color) {
$status = "<font color=$color>$status</font>"
}

return \"<b>$status</b>";
}

sub extStatusInColor {
my $Ticket = shift;

if ( $Ticket->HasUnresolvedDependencies ) {
my $status;
if ( $Ticket->HasUnresolvedDependencies( Type => 'approval' )
or $Ticket->HasUnresolvedDependencies( Type => 'code' ) ) {
$status = "<em>" . loc('(pending approval)') . "</em>";
} else {
$status = "<em>" . loc('(pending other Collection)') . "</em>";
}
return \$status;
} else {
return statusInColor($Ticket);
}
}

$COLUMN_MAP->{Status}->{value} = \&statusInColor;
$COLUMN_MAP->{ExtendedStatus}->{value} = \&extStatusInColor;

</%INIT>
<%ARGS>
$COLUMN_MAP => undef
</%ARGS>
</pre>

===== Priority color =====

by Riccardo Capecchi

My users wanted also the priority coloured in shade of red and yellow based on priority (red = big problem), i used the above code and added these lines to show a coloured field priority. You must add these lines with or without the above code into the file: `<RTInstallationDir>/local/html/Callbacks/MyCallbacks/Elements/RT__Ticket/ColumnMap/ColumnMap`

edit: $priority is an integer, not a string. I've used >= operator instead of ge operator.

<pre>
----

sub PriorityInColor {
my $Ticket = shift;

my $priority = $Ticket->Priority;
my $colors = undef;

if ($priority >= 90) {
$colors = "#FF0000";
} elsif ($priority >= 80) {
$colors = "#FF2000";
} elsif ($priority >= 70) {
$colors = "#FF4000";
} elsif ($priority >= 60) {
$colors = "#FF6000";
} elsif ($priority >= 50) {
$colors = "#FF8000";
} elsif ($priority >= 40) {
$colors = "#FFA000";
} elsif ($priority >= 30) {
$colors = "#FFC000";
} elsif ($priority >= 20) {
$colors = "#FFE000";
} elsif ($priority >= 10) {
$colors = "#FFFF00";
} elsif ($priority >= 0) {
$colors = "009000";
}

if ($colors) {
$priority = "<font style=\"color:black;background-color:$colors\">&nbsp;$priority&nbsp;</font>"
}

return \"<b>$priority</b>";
}
$COLUMN_MAP->{Priority}->{value} = \&PriorityInColor;
</pre>

(This one also works in 3.8.2 as of 2009-Feb-12; I've modified it slightly to colorize the '''background''', and also to use inline CSS instead of deprecated tags. If you use both, put this one '''inside''' the other one's %INIT tags. --Baylink)

==== Using CSS For Styling ====

by Graham Briggs

As an alternative to the above, you might choose to use CSS to define styling of the Status field. I have the following setup:

In file `$RT_HOME/local/html/Callbacks/MyCallbacks/Elements/RT__Ticket/ColumnMap/ColumnMap` replace the above status[[InColor]] method with the following:

<pre>
sub statusInColor {
my $Ticket = shift;
my $status = $Ticket->Status;
my $css = "status" . lc $status;
$css =~ s/[\W]//g;

if ( $Ticket->HasUnresolvedDependencies ) {
$status = "<i>$status<i>";
}

$status = "<div class=\"$css\">$status</div>";

return \"$status";
}
</pre>

In file `$RT_HOME/local/html/Callbacks/MyCallbacks/NoAuth/webrt.css/Default`

<pre>
/* Status Colours */

.statusnew {
color: #bb0000;
text-align: center;
font-weight: bold;
}

.statusopen {
color: #0000bb;
text-align: center;
font-weight: bold;
}

.statustesting {
color: #00bb00;
text-align: center;
font-weight: bold;
}

.statusresolved {
color: #888888;
text-align: center;
font-weight: bold;
}

.statusrejected {
color: #884444;
text-align: center;
font-weight: bold;
}
</pre>

== RT 3.6.5 (and up?) ==

Thanks Johan Baarman for the solution.

The problem with newer version is that the CSS file is not read from the directory mentioned above. Follow the steps below to solve it:

Create a directory `$RT_HOME/local/html/NoAuth/css/3.5-default/` and copy `$RT_HOME/share/html/NoAuth/css/3.5-default/main.css` to it. Now edit the local main.css file and add the following line at the end: import "statuscolor.css"; Create a new local file `$RT_HOME/local/html/NoAuth/css/3.5-default/statuscolor.css` and populate it with the above css tags. I've also changed the .statustesting above to .statusreply in my statuscolor.css file in order to color replies.

In addition to coloring the status, the following alternative status[[InColor]] function will set a "REP" flag for each status to indicate a ticket that had been updated by anyone else than the staff, i.e. requestor or any of the [[CCs]], in case any of the users are colorblind.

<pre>
sub statusInColor {
my $Ticket = shift;
my $status = $Ticket->Status;
my $css = "status" . lc $status;
my $LastUpdater = $Ticket->LastUpdatedByObj->EmailAddress;
my $TicketRequestors = $Ticket->Requestors->MemberEmailAddressesAsString;
my $TicketCC = $Ticket->Cc->MemberEmailAddressesAsString;

if (($TicketRequestors =~ $LastUpdater) || ($TicketCC =~ $LastUpdater))
{
$css = "status" . lc "reply";
$status = "<div class=\"$css\">$status REP</div>";
}
else {
$status = "<div class=\"$css\">$status</div>";
}

return \"$status";
}
</pre>