Query Builder page modification

Hi,
We have RT 3.8.1 running on opensuse11; mysql 5.0.51a; perl
5.10.0

When I go to QueryBuilder page (it takes over 5 minutes to
load), it shows me thousands of users for a box where it
says: “Owner”

But, when I go to mysql query browser, and search table
"ACL" for all users with RightName of “OwnTickets”, I get
very few users (about 100), which is correct.
Here is the query I run:
SELECT * FROM rt3.ACL where RightName = ‘OwnTicket’;

So, how do I correct the code for QueryBuilder page?

Is there any documentation for this, if so please guide me
there, or if anyone knows how to fix this issue, please
advice…
I also tried to upgrade to RT 3.8.2 on my test machine, but
I got same results.

Thanks for your help.

Hi Daksh,
read my actual mails (sent to Kem Cho), it regarding slow BulkUpdate, but also the same situation at Qb before:

same problem here, the querybuilder page was also slow until i got a hint from jesse:

Make first a local copy of /rthome/share/html/Search/Elements/PickBasics to /rthome/local/html/Search/Elements/PickBasics

Replace here:

<& /Elements/SelectOwner, Name => “ValueOfActor”, ValueAttribute => ‘Name’ &>

With:

From now QueryBuilder Page is much, much faster!

This was taken from RT 3.6.5 but i think you only have to replace this part:

    Value => {
        Type => 'component',
        Path => '/Elements/SelectOwner',
        Arguments => { ValueAttribute => 'Name' },
    },

I’m not sure for 3.8.x but Emmanuel mentioned a change to SelectOwner…

Torsten

Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne

-----Urspruengliche Nachricht-----Von: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Im Auftrag von daksh
Gesendet: Donnerstag, 22. Januar 2009 00:03
An: RT-Users@lists.bestpractical.com
Betreff: [rt-users] Query Builder page modification

Hi,
We have RT 3.8.1 running on opensuse11; mysql 5.0.51a; perl 5.10.0

When I go to QueryBuilder page (it takes over 5 minutes to load), it shows me thousands of users for a box where it
says: “Owner”

But, when I go to mysql query browser, and search table “ACL” for all users with RightName of “OwnTickets”, I get very few users (about 100), which is correct.
Here is the query I run:
SELECT * FROM rt3.ACL where RightName = ‘OwnTicket’;

So, how do I correct the code for QueryBuilder page?

Is there any documentation for this, if so please guide me there, or if anyone knows how to fix this issue, please advice…
I also tried to upgrade to RT 3.8.2 on my test machine, but I got same results.

Thanks for your help.

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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