RT tickets resolved and tickets unowned list problem

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

DSA,

We have RT 3.4.5 and have set or privileges to not allow just "any" 

privileged user to see tickets they have no relation to and do not have
this problem. The modification of your code seems a bit of over kill
when the result you seem to be looking for can be accomplished with more
specific allocation of rights. What do you have for your global and
queue rights for systems groups, roles, groups, and users? Perhaps we
can simplify this.

Kenn
LBNLOn 10/22/2007 1:53 AM, dsa sadf 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



The rt-users Archives

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

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

Hi,

Can anyone help me out with this query?

Thanks,

Rajdsa sadf indian_cricket_videos@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 _______________________________________________
The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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