[rt-users] RT tickets resolved and tickets unowned list problem

[dsa sadf]

Hi everyone,

I am using RT 3.4.5, running on a CentOS box. I was trying to restrict some privileged users from seeing tickets on queues they weren't allowed to. I managed to do that but in the process caused the 'Top 10 Resolved tickets' and 'Top 10 Unowned tickets' lists to display inaccurate tickets. For example, the 'Top 10 Resolved tickets' list shows some unowned and new tickets and the 'Top 10 Unowned tickets' list shows some resolved tickets. 

I had added the following code to my 'MyRequests' file in order to restrict queue access for that user:

my $Queues = RT::Queues->new($session{'CurrentUser'});
$Queues->UnLimit();
my $myQueues = "";
while (my $queue = $Queues->Next) {
       next unless ($queue->CurrentUserHasRight('ShowTicket'));
       $myQueues .= " OR Queue = '" . $queue->Name . "'";
}
$myQueues =~ s/^ OR //g;


my $Query = "Owner = 'Nobody' AND $myQueues AND ( Status = 'new' OR Status = 'open')"; 

and for the 'MyResolved' file, the same code except for the last line which reads:

my $Query = "Owner = 'Nobody' AND $myQueues AND ( Status = 'resolved)"; 


Could anyone help me identify what the problem could be?


Regards,

Raj

 
 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20071022/4adac711/attachment.htm>