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

dsa sadf indian_cricket_videos at yahoo.com
Mon Oct 29 07:25:06 EDT 2007


Hi,

Can anyone help me out with this query?

Thanks,

Raj

dsa sadf <indian_cricket_videos at yahoo.com> wrote: 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 _______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


 __________________________________________________
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/20071029/254663b2/attachment.htm>


More information about the rt-users mailing list