Unowned Tickets Table on Homepage not updating correctly

Hi
i am running an RT system setup so that our support team monitors 5 queues
and our multiple resellers also have a queue each to run there support
services

One of the support users has reported an issue with the “10 newest unowned
tickets” table on the homepage not displaying the full list of tickets that
they have permissions to see

We know that there are 4 unowned tickets in the General queue and the user
has full access too and multiple tickets in queues that the user doesnt have
access too.

On the homepage the “10 newest unowned tickets” table stats there are only 2
unowned tickets in the general queue (i.e 2 tickets are missed),however if i
open up the table it will display all 4 unowned ticket they are allowed to
see.

i have created my own “unowned tickets” search and it suffers from the same
bug, However, it has also been noted that this bug only effects the table on
the homepage. Tables runs fine in a dashboard.

has anyone else experiancd this and if so were they able to resolve it

thank you in advanced

View this message in context: http://requesttracker.8502.n7.nabble.com/Unowned-Tickets-Table-on-Homepage-not-updating-correctly-tp54986.html

Dnia 2013-08-12, pon o godzinie 03:42 -0700, scott.dalzell pisze:

Hi
i am running an RT system setup so that our support team monitors 5 queues
and our multiple resellers also have a queue each to run there support
services

One of the support users has reported an issue with the “10 newest unowned
tickets” table on the homepage not displaying the full list of tickets that
they have permissions to see

We know that there are 4 unowned tickets in the General queue and the user
has full access too and multiple tickets in queues that the user doesnt have
access too.

On the homepage the “10 newest unowned tickets” table stats there are only 2
unowned tickets in the general queue (i.e 2 tickets are missed),however if i
open up the table it will display all 4 unowned ticket they are allowed to
see.

i have created my own “unowned tickets” search and it suffers from the same
bug, However, it has also been noted that this bug only effects the table on
the homepage. Tables runs fine in a dashboard.

has anyone else experiancd this and if so were they able to resolve it

It’s not a bug, it’s a feature.
Check “Rows per page” setting on “RT at a glace” edit page (
https://your_rt/Prefs/MyRT.html)

Regards,
Robert Wysocki
administrator systemów linuksowych
administrator baz danych
Grupa Unity | ul. Przedmiejska 6-10, 54-201 Wrocław
ul. Conrada 55B, 31-357 Kraków | ul. Złota 59, 00-120 Warszawa

Thank you for the quick response

The Rows per box was set to 10 so i have increased it to 100 and it revieled
the 2 missing tickets.

I take it RT counts tickets that the user doesnt have permission to view in
this Rows per box count as well ye

thank you again

View this message in context: http://requesttracker.8502.n7.nabble.com/Unowned-Tickets-Table-on-Homepage-not-updating-correctly-tp54986p54988.html

Thank you for the quick response

The Rows per box was set to 10 so i have increased it to 100 and it revieled
the 2 missing tickets.

I take it RT counts tickets that the user doesnt have permission to view in
this Rows per box count as well ye

thank you again

Even more of a feature, enable this (defaulted on in the branch that
will become 4.2) and let us know of any regressions you encounter.

http://bestpractical.com/docs/rt/latest/RT_Config.html#UseSQLForACLChecks

-kevin

This setting nailed the issue on the head.
ill post here again if i notice any issues from setting
Set($UseSQLForACLChecks,1) in the RT_SiteConfig file but all appears well

thank you everyone for your help

Scott

View this message in context: http://requesttracker.8502.n7.nabble.com/Unowned-Tickets-Table-on-Homepage-not-updating-correctly-tp54986p54991.html