[rt-users] Colons in queue name seems to break Quicksearch display in rt-3.4.3
Marc A Tisseur
marct at alcor.concordia.ca
Fri Aug 12 19:24:03 EDT 2005
After installaing 3.4.3 I noticed the number of new or open tickets
in the Quicksearch list allways shows up as 0 for any queue containing a ":" in
its name. Selecting the queue will list the tickets however. rt-3.4.2's
quicksearch doesn't suffer the same problem. The principal diff between the two
is as follows;
--- rt-3.4.3/html/Elements/Quicksearch 2005-06-23 17:37:31.000000000 -0400
+++ rt-3.4.2/html/Elements/Quicksearch 2005-02-01 09:20:40.000000000 -0500
@@ -57,11 +57,9 @@
while (my $queue = $Queues->Next) {
next unless ($queue->CurrentUserHasRight('ShowTicket'));
- my $name = $m->interp->apply_escapes($queue->Name, "u");
-
- my $new_q = "Queue = '$name' AND Status = 'new'";
- my $open_q = "Queue = '$name' AND Status = 'open'";
- my $all_q = "Queue = '$name' AND (Status = 'open' OR Status = 'new')";
+ my $new_q = "Queue = '".$queue->Name."' AND Status = 'new'";
+ my $open_q = "Queue = '".$queue->Name."' AND Status = 'open'";
+ my $all_q = "Queue = '".$queue->Name."' AND (Status = 'open' OR Status
= 'new')";
$Tickets->FromSQL($open_q);
my $open = $Tickets->Count();
@@ -69,8 +67,10 @@
$Tickets->FromSQL($new_q);
my $new = $Tickets->Count();
Can anyone point out to me if there other "prohibited" characters that I should
be aware of?
Server specs;
Linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i686 unknown
Slackware 8.1
Apache/1.3.33 (Unix) mod_perl/1.29 mod_ssl/2.8.22 OpenSSL/0.9.6d configured
Perl 5.8.6
DBIx::SearchBuilder 1.31
PostgreSQL 8.0.3
Much appreciated,
--
Marc Tisseur
Manager, Desktop Support Group and Helpline - IITS
Concordia University
Montreal, Canada
More information about the rt-users
mailing list