Mailing List Archive: Request Tracker: Users

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 / Apache2.2.3 /FastCGI

Index | Next | Previous | View Threaded

elacour at easter-eggs

Jan 23, 2009, 5:50 AM

Post #1 of 18 (939 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 / Apache2.2.3 /FastCGI

On Fri, Jan 23, 2009 at 02:35:45PM +0100, Ham MI-ID, Torsten Brumm wrote:
> Hi Together,
> it's me again. Has anyone a idea why this query starts on each
> BulkUpdate Page? I have just fired up this query in query browser and
> the result is a big list of 1255 Users, mixed priviledged and
> unpriviledged users, not all user of our DB are listed and i also
> cross checked, also users are included which have NEVER created a
> ticket in the queue i started the bulk update (also have no rights
> here).
>
> I'm a little lost in space at this moment, any ideas?
>

Because somewhere in your ACLs they gain OwnTicket right?

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

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

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

torsten.brumm at Kuehne-Nagel

Jan 23, 2009, 5:55 AM

Post #2 of 18 (916 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI [In reply to]

Hi Emmanuel,
just for my understanding: If they have somewhere the right to own ticket and i do a bulk update only in one queue where only 5 people have own ticket rights, all the users will be queried?

How can i easily check if they (especially the unpriviledged users) have own ticket rights?

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 [at] lists [mailto:rt-users-bounces [at] lists] Im Auftrag von Emmanuel Lacour
Gesendet: Freitag, 23. Januar 2009 14:51
An: rt-users [at] lists
Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

On Fri, Jan 23, 2009 at 02:35:45PM +0100, Ham MI-ID, Torsten Brumm wrote:
> Hi Together,
> it's me again. Has anyone a idea why this query starts on each
> BulkUpdate Page? I have just fired up this query in query browser and
> the result is a big list of 1255 Users, mixed priviledged and
> unpriviledged users, not all user of our DB are listed and i also
> cross checked, also users are included which have NEVER created a
> ticket in the queue i started the bulk update (also have no rights
> here).
>
> I'm a little lost in space at this moment, any ideas?
>

Because somewhere in your ACLs they gain OwnTicket right?

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

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

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

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

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

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

elacour at easter-eggs

Jan 23, 2009, 6:24 AM

Post #3 of 18 (913 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI [In reply to]

On Fri, Jan 23, 2009 at 02:55:21PM +0100, Ham MI-ID, Torsten Brumm wrote:
> Hi Emmanuel,
> just for my understanding: If they have somewhere the right to own
> ticket and i do a bulk update only in one queue where only 5 people
> have own ticket rights, all the users will be queried?
>
> How can i easily check if they (especially the unpriviledged users) have own ticket rights?
>

you can use bulk update on a search result involving more than one
queue. And so in Search/Bulk.html, no queue is passed to
Elements/SelectOwner, and so all people that can own ticket are
displayed.

maybe we can try to get the list of queues from search result and pass
it to SelectOwner to reduce the list... but maybe gt of this list will
slow down Bulk.html to much ??? I need to try this.

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

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

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

elacour at easter-eggs

Jan 23, 2009, 6:37 AM

Post #4 of 18 (913 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI [In reply to]

On Fri, Jan 23, 2009 at 03:24:40PM +0100, Emmanuel Lacour wrote:
> On Fri, Jan 23, 2009 at 02:55:21PM +0100, Ham MI-ID, Torsten Brumm wrote:
> > Hi Emmanuel,
> > just for my understanding: If they have somewhere the right to own
> > ticket and i do a bulk update only in one queue where only 5 people
> > have own ticket rights, all the users will be queried?
> >
> > How can i easily check if they (especially the unpriviledged users) have own ticket rights?
> >
>
> you can use bulk update on a search result involving more than one
> queue. And so in Search/Bulk.html, no queue is passed to
> Elements/SelectOwner, and so all people that can own ticket are
> displayed.
>
>
> maybe we can try to get the list of queues from search result and pass
> it to SelectOwner to reduce the list... but maybe gt of this list will
> slow down Bulk.html to much ??? I need to try this.
>

There is already (in 3.8 at least) a $seen_queues in Bulk.html that
contains the list of QueuesObj of all the ticket results. But it's not
sent to SelectOwner. Maybe because it's possible to change tickets in
other queues and so it's better to show owners of all accessible queues,
not only those from the ticket result.

But ... we can probably reduce the list of owners to those corresponding
to the list of queues displayed in Elements/SelectQueues instead of all
Owners of the RT system.

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

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

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

elacour at easter-eggs

Jan 23, 2009, 6:44 AM

Post #5 of 18 (909 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI [In reply to]

On Fri, Jan 23, 2009 at 03:37:17PM +0100, Emmanuel Lacour wrote:
>
> But ... we can probably reduce the list of owners to those corresponding
> to the list of queues displayed in Elements/SelectQueues instead of all
> Owners of the RT system.
>

humm I'm a bit busy now, I open a bug for you to try to enhance this on
rt3.fsck.com.

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

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

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

torsten.brumm at googlemail

Jan 23, 2009, 7:01 AM

Post #6 of 18 (911 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI [In reply to]

Hi Emmanuel,
now back home and try on monday. so it is coming form the SelectOwner
Dropdown? I remember some years ago something similar at the querybuilder
page and i think jesse fixed this by replacing the dropdown with a normal
textbox...will try it out and keep you up2date.

Have a nice weekend

Torsten

2009/1/23 Emmanuel Lacour <elacour [at] easter-eggs>

> On Fri, Jan 23, 2009 at 03:37:17PM +0100, Emmanuel Lacour wrote:
> >
> > But ... we can probably reduce the list of owners to those corresponding
> > to the list of queues displayed in Elements/SelectQueues instead of all
> > Owners of the RT system.
> >
>
> humm I'm a bit busy now, I open a bug for you to try to enhance this on
> rt3.fsck.com.
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales [at] bestpractical
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>

--
MFG

Torsten Brumm

http://www.torsten-brumm.de

elacour at easter-eggs

Jan 23, 2009, 7:13 AM

Post #7 of 18 (915 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI [In reply to]

On Fri, Jan 23, 2009 at 04:01:13PM +0100, Torsten Brumm wrote:
> Hi Emmanuel,
> now back home and try on monday. so it is coming form the SelectOwner
> Dropdown? I remember some years ago something similar at the querybuilder
> page and i think jesse fixed this by replacing the dropdown with a normal
> textbox...will try it out and keep you up2date.
>

just for my information how many users have you in the dropdown owner
list on Bulk.html ?

> Have a nice weekend
>

You too :)

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

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

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

kemcho12345 at yahoo

Jan 23, 2009, 9:40 AM

Post #8 of 18 (912 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI [In reply to]

Do you know which file controls this drop down box? "...replacing the dropdown with a normal textbox..."

I am having exactly the same problem, but cannot find which file / code is controlling this.

Thanks for your help.

--- On Fri, 1/23/09, Torsten Brumm <torsten.brumm [at] googlemail> wrote:

From: Torsten Brumm <torsten.brumm [at] googlemail>
Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI
To: "Emmanuel Lacour" <elacour [at] easter-eggs>
Cc: rt-users [at] lists
Date: Friday, January 23, 2009, 9:01 AM

Hi Emmanuel,
now back home and try on monday. so it is coming form the SelectOwner Dropdown? I remember some years ago something similar at the querybuilder page and i think jesse fixed this by replacing the dropdown with a normal textbox...will try it out and keep you up2date.

Have a nice weekend

Torsten

2009/1/23 Emmanuel Lacour <elacour [at] easter-eggs>

On Fri, Jan 23, 2009 at 03:37:17PM +0100, Emmanuel Lacour wrote:
>
> But ... we can probably reduce the list of owners to those corresponding
> to the list of queues displayed in Elements/SelectQueues instead of all
> Owners of the RT system.
>

humm I'm a bit busy now, I open a bug for you to try to enhance this on
rt3.fsck.com.

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

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

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

--
MFG

Torsten Brumm

http://www.torsten-brumm.de
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

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

elacour at easter-eggs

Jan 23, 2009, 9:51 AM

Post #9 of 18 (912 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI [In reply to]

On Fri, Jan 23, 2009 at 09:40:34AM -0800, kem cho wrote:
> Do you know which file controls this drop down box? "...replacing the dropdown with a normal textbox..."
>
> I am having exactly the same problem, but cannot find which file / code is controlling this.
>

share/html/Search/Bulk.html, replace the line with /Elements/SelectOwner
with a text input field using the same name.

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

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

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

kemcho12345 at yahoo

Jan 23, 2009, 1:19 PM

Post #10 of 18 (906 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI [In reply to]

Emmanuel,
I also wanted to know if there is a way to edit the query that runs when QueryBuilder page loads? (Search/Build.html) I am unable to find this, as I am not quite a perl expert.

This is because we have an issue in RT where it displays many many users as "Owner" in QueryBuilder page, but when I run a query from mysql prompt, it only shows me handful of users with "OwnTicket" right. Based on this, to me it feels like my data is correct, but I could be wrong, as I have been working with RT software for only a month now.

Thanks for your help.

--- On Fri, 1/23/09, Emmanuel Lacour <elacour [at] easter-eggs> wrote:

From: Emmanuel Lacour <elacour [at] easter-eggs>
Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI
To: rt-users [at] lists
Date: Friday, January 23, 2009, 11:51 AM

On Fri, Jan 23, 2009 at 09:40:34AM -0800, kem cho wrote:
> Do you know which file controls this drop down box? "...replacing the
dropdown with a normal textbox..."
>
> I am having exactly the same problem, but cannot find which file / code
is controlling this.
>

share/html/Search/Bulk.html, replace the line with /Elements/SelectOwner
with a text input field using the same name.

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

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

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

torsten.brumm at Kuehne-Nagel

Jan 24, 2009, 12:03 AM

Post #11 of 18 (899 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI [In reply to]

Hi Emmanuel,
just for your information, the owner drop down is really long, i didn't count all, but i scrolled down several seconds, looks like all the People from the SQL Query!

I'm going now to replace first the SelectOwner Dropdown by a text box...

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 [at] lists [mailto:rt-users-bounces [at] lists] Im Auftrag von Emmanuel Lacour
Gesendet: Freitag, 23. Januar 2009 16:14
An: rt-users [at] lists
Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

On Fri, Jan 23, 2009 at 04:01:13PM +0100, Torsten Brumm wrote:
> Hi Emmanuel,
> now back home and try on monday. so it is coming form the SelectOwner
> Dropdown? I remember some years ago something similar at the
> querybuilder page and i think jesse fixed this by replacing the
> dropdown with a normal textbox...will try it out and keep you up2date.
>

just for my information how many users have you in the dropdown owner list on Bulk.html ?

> Have a nice weekend
>

You too :)

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

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

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

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

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

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

torsten.brumm at Kuehne-Nagel

Jan 24, 2009, 12:37 AM

Post #12 of 18 (882 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI [In reply to]

Hi Kem,
make first a local copy of /rthome/share/html/Search/Bulk.html to /rthome/local/html/Search/Bulk.html

Then open local Bulk.html and search for:

<tr><td class="label"> <&|/l&>Make Owner</&>: </td>

Then replace the Line:

<td class="value"> <& /Elements/SelectOwner, Name => "Owner" &> (<input type="checkbox" class="checkbox" name="ForceOwnerChange" /> <&|/l&>Force change</&>) </td></tr>

With:

<td class="value"> <input name="Owner" size="20" /> (<input type="checkbox" class="checkbox" name="ForceOwnerChange" /> <&|/l&>Force change</&>) </td></tr>

Torsten

And now. my bulk update page is from 200sec down to 0,5sec !!!

Thanks for any hints so far

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

________________________________

Von: rt-users-bounces [at] lists [mailto:rt-users-bounces [at] lists] Im Auftrag von kem cho
Gesendet: Freitag, 23. Januar 2009 18:41
An: torsten.brumm [at] googlemail
Cc: rt-users [at] lists
Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

Do you know which file controls this drop down box? "...replacing the dropdown with a normal textbox..."

I am having exactly the same problem, but cannot find which file / code is controlling this.

Thanks for your help.

--- On Fri, 1/23/09, Torsten Brumm <torsten.brumm [at] googlemail> wrote:

From: Torsten Brumm <torsten.brumm [at] googlemail>
Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI
To: "Emmanuel Lacour" <elacour [at] easter-eggs>
Cc: rt-users [at] lists
Date: Friday, January 23, 2009, 9:01 AM

Hi Emmanuel,
now back home and try on monday. so it is coming form the SelectOwner Dropdown? I remember some years ago something similar at the querybuilder page and i think jesse fixed this by replacing the dropdown with a normal textbox...will try it out and keep you up2date.

Have a nice weekend

Torsten

2009/1/23 Emmanuel Lacour <elacour [at] easter-eggs>

On Fri, Jan 23, 2009 at 03:37:17PM +0100, Emmanuel Lacour wrote:
>
> But ... we can probably reduce the list of owners to those corresponding
> to the list of queues displayed in Elements/SelectQueues instead of all
> Owners of the RT system.
>

humm I'm a bit busy now, I open a bug for you to try to enhance this on
rt3.fsck.com <http://rt3.fsck.com/> .

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

Community help: http://wiki.bestpractical.com <http://wiki.bestpractical.com/>
Commercial support: sales [at] bestpractical

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

--
MFG

Torsten Brumm

http://www.torsten-brumm.de <http://www.torsten-brumm.de/>

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

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

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

torsten.brumm at Kuehne-Nagel

Jan 24, 2009, 12:43 AM

Post #13 of 18 (888 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI [In reply to]

Hi Kem,

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:

<input name="ValueOfActor">

From now QueryBuilder Page is much, much faster!

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

________________________________

Von: rt-users-bounces [at] lists [mailto:rt-users-bounces [at] lists] Im Auftrag von kem cho
Gesendet: Freitag, 23. Januar 2009 22:19
An: Emmanuel Lacour
Cc: rt-users [at] lists
Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

Emmanuel,
I also wanted to know if there is a way to edit the query that runs when QueryBuilder page loads? (Search/Build.html) I am unable to find this, as I am not quite a perl expert.

This is because we have an issue in RT where it displays many many users as "Owner" in QueryBuilder page, but when I run a query from mysql prompt, it only shows me handful of users with "OwnTicket" right. Based on this, to me it feels like my data is correct, but I could be wrong, as I have been working with RT software for only a month now.

Thanks for your help.

--- On Fri, 1/23/09, Emmanuel Lacour <elacour [at] easter-eggs> wrote:

From: Emmanuel Lacour <elacour [at] easter-eggs>
Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI
To: rt-users [at] lists
Date: Friday, January 23, 2009, 11:51 AM

On Fri, Jan 23, 2009 at 09:40:34AM -0800, kem cho wrote:
> Do you know which file controls this drop down box? "...replacing the
dropdown with a normal textbox..."
>
> I am having exactly the same problem, but cannot find which file / code
is controlling this.
>

share/html/Search/Bulk.html, replace the line with /Elements/SelectOwner
with a text input field using the same name.

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

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

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

torsten.brumm at Kuehne-Nagel

Jan 24, 2009, 1:37 AM

Post #14 of 18 (882 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI [In reply to]

Hi Emmanuel,
just got also some information from our DBA's, they had a look (on Friday night! Wow!) to the query:

SELECT
DISTINCT main.*
FROM Users main
CROSS JOIN ACL ACL_4
JOIN Principals Principals_1 ON (Principals_1.id = main.id)
JOIN CachedGroupMembers CachedGroupMembers_2 ON (CachedGroupMembers_2.MemberId = Principals_1.id)
JOIN Groups Groups_3 ON (Groups_3.id = CachedGroupMembers_2.GroupId)
WHERE (Principals_1.Disabled = '0')
AND (ACL_4.PrincipalType = Groups_3.Type)
AND (Principals_1.id != '1')
AND (Principals_1.PrincipalType = 'User')
AND (ACL_4.RightName = 'OwnTicket')
AND ((ACL_4.ObjectType = 'RT::Queue')
OR (ACL_4.ObjectType = 'RT::System'))
AND ((Groups_3.Domain = 'RT::Queue-Role')
OR (Groups_3.Domain = 'RT::System-Role'))
ORDER BY main.Name ASC;

And they came back with a much more faster query doing the same:

SELECT STRAIGHT_JOIN DISTINCT main.* FROM
ACL ACL_4,
Groups Groups_3,
CachedGroupMembers CachedGroupMembers_2,
Principals Principals_1,
Users main
WHERE ((ACL_4.PrincipalType = Groups_3.Type))
AND ((ACL_4.RightName = 'OwnTicket'))
AND ((CachedGroupMembers_2.MemberId = Principals_1.id))
AND ((Groups_3.id = CachedGroupMembers_2.GroupId))
AND ((Principals_1.Disabled = '0'))
AND ((Principals_1.PrincipalType = 'User'))
AND ((Principals_1.id != '1'))
AND ((main.id = Principals_1.id))
AND ((ACL_4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType = 'RT::System'))
AND ((Groups_3.Domain = 'RT::Queue-Role') OR (Groups_3.Domain = 'RT::System-Role')) ORDER BY main.RealName ASC;

As you can see, less JOINS/CROSS JOINS. This Query is done in a few seconds compared to the one from SearchBuilder with 200sec and more.

Possibly a starting point for the RTDB Guys to review Searchbuilder...?!? But i'm not a DBA---

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 [at] lists [mailto:rt-users-bounces [at] lists] Im Auftrag von Emmanuel Lacour
Gesendet: Freitag, 23. Januar 2009 15:25
An: rt-users [at] lists
Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

On Fri, Jan 23, 2009 at 02:55:21PM +0100, Ham MI-ID, Torsten Brumm wrote:
> Hi Emmanuel,
> just for my understanding: If they have somewhere the right to own
> ticket and i do a bulk update only in one queue where only 5 people
> have own ticket rights, all the users will be queried?
>
> How can i easily check if they (especially the unpriviledged users) have own ticket rights?
>

you can use bulk update on a search result involving more than one queue. And so in Search/Bulk.html, no queue is passed to Elements/SelectOwner, and so all people that can own ticket are displayed.

maybe we can try to get the list of queues from search result and pass it to SelectOwner to reduce the list... but maybe gt of this list will slow down Bulk.html to much ??? I need to try this.

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

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

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

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

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

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

kemcho12345 at yahoo

Jan 25, 2009, 8:24 PM

Post #15 of 18 (871 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI [In reply to]

Hi Torsten,
I followed what you mention about Bulk update page and querybuilder page. It works great on old release of RT. I also have a test machine (running Fedora 9, perl 5.10, mysql 5.0), where I installed RT3.8.1

In RT 3.8.1, it looks like PickBasics program was modified, and it does not have the line you mention to modify. So, as a work around, I copied PickBasics file from older release of RT, and it seems to be working. Now, I do not have a drop down with the list of all RT users, it displays a text input box, which is fine (atleast the page loads in fraction of a second).

This week, I will work on installing RT 3.8.2 back on my test machine and see if my work around works with it.

I (and the users) really do appreciate your help with this...

--- On Sat, 1/24/09, Ham MI-ID, Torsten Brumm <torsten.brumm [at] Kuehne-Nagel> wrote:

From: Ham MI-ID, Torsten Brumm <torsten.brumm [at] Kuehne-Nagel>
Subject: AW: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI
To: kemcho12345 [at] yahoo, "Emmanuel Lacour" <elacour [at] easter-eggs>
Cc: rt-users [at] lists
Date: Saturday, January 24, 2009, 2:43 AM

Hi Kem,

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:

<input name="ValueOfActor">

From now QueryBuilder Page is much, much faster!

Torsten

Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Dirk Blesius (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg, Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne

Von: rt-users-bounces [at] lists [mailto:rt-users-bounces [at] lists] Im Auftrag von kem cho
Gesendet: Freitag, 23. Januar 2009 22:19
An: Emmanuel Lacour
Cc: rt-users [at] lists
Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

Emmanuel,
I also wanted to know if there is a way to edit the query that runs when QueryBuilder page loads? (Search/Build.html) I am unable to find this, as I am not quite a perl expert.

This is because we have an issue in RT where it displays many many users as "Owner" in QueryBuilder page, but when I run a query from mysql prompt, it only shows me handful of users with "OwnTicket" right. Based on this, to me it feels like my data is correct, but I could be wrong, as I have been working with RT software for only a month now.

Thanks for your help.

--- On Fri, 1/23/09, Emmanuel Lacour <elacour [at] easter-eggs> wrote:

From: Emmanuel Lacour <elacour [at] easter-eggs>
Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI
To: rt-users [at] lists
Date: Friday, January 23, 2009, 11:51 AM

On Fri, Jan 23, 2009 at 09:40:34AM -0800, kem cho wrote:
> Do you know which file controls this drop down box? "...replacing the
dropdown with a normal textbox..."
>
> I am having exactly the same problem, but cannot find which file / code
is controlling this.
>

share/html/Search/Bulk.html, replace the line with /Elements/SelectOwner
with a text input field using the same name.

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

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

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

kemcho12345 at yahoo

Jan 25, 2009, 8:28 PM

Post #16 of 18 (870 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI [In reply to]

Hi,
This works really well, even with RT 3.8.1. I will test this with 3.8.2 sometime this week, and post the results.
Thanks for your help...

--- On Sat, 1/24/09, Ham MI-ID, Torsten Brumm <torsten.brumm [at] Kuehne-Nagel> wrote:

From: Ham MI-ID, Torsten Brumm <torsten.brumm [at] Kuehne-Nagel>
Subject: AW: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI
To: kemcho12345 [at] yahoo, torsten.brumm [at] googlemail
Cc: rt-users [at] lists
Date: Saturday, January 24, 2009, 2:37 AM

Hi Kem,
make first a local copy of /rthome/share/html/Search/Bulk.html to /rthome/local/html/Search/Bulk.html

Then open local Bulk.html and search for:

<tr><td class="label"> <&|/l&>Make Owner</&>: </td>

Then replace the Line:

<td class="value"> <& /Elements/SelectOwner, Name => "Owner" &> (<input type="checkbox" class="checkbox" name="ForceOwnerChange" /> <&|/l&>Force change</&>) </td></tr>

With:

<td class="value"> <input name="Owner" size="20" /> (<input type="checkbox" class="checkbox" name="ForceOwnerChange" /> <&|/l&>Force change</&>) </td></tr>

Torsten

And now. my bulk update page is from 200sec down to 0,5sec !!!

Thanks for any hints so far

Torsten

Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Dirk Blesius (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg, Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne

Von: rt-users-bounces [at] lists [mailto:rt-users-bounces [at] lists] Im Auftrag von kem cho
Gesendet: Freitag, 23. Januar 2009 18:41
An: torsten.brumm [at] googlemail
Cc: rt-users [at] lists
Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

Do you know which file controls this drop down box? "...replacing the dropdown with a normal textbox..."

I am having exactly the same problem, but cannot find which file / code is controlling this.

Thanks for your help.

--- On Fri, 1/23/09, Torsten Brumm <torsten.brumm [at] googlemail> wrote:

From: Torsten Brumm <torsten.brumm [at] googlemail>
Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI
To: "Emmanuel Lacour" <elacour [at] easter-eggs>
Cc: rt-users [at] lists
Date: Friday, January 23, 2009, 9:01 AM

Hi Emmanuel,
now back home and try on monday. so it is coming form the SelectOwner Dropdown? I remember some years ago something similar at the querybuilder page and i think jesse fixed this by replacing the dropdown with a normal textbox...will try it out and keep you up2date.

Have a nice weekend

Torsten

2009/1/23 Emmanuel Lacour <elacour [at] easter-eggs>

On Fri, Jan 23, 2009 at 03:37:17PM +0100, Emmanuel Lacour wrote:
>
> But ... we can probably reduce the list of owners to those corresponding
> to the list of queues displayed in Elements/SelectQueues instead of all
> Owners of the RT system.
>

humm I'm a bit busy now, I open a bug for you to try to enhance this on
rt3.fsck.com.

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

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

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

--
MFG

Torsten Brumm

http://www.torsten-brumm.de
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

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

ruslan.zakirov at gmail

Jan 25, 2009, 11:28 PM

Post #17 of 18 (869 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI [In reply to]

1) CROSS JOIN is equal to ","
2) STRAIGHT JOIN is workaround for mysql bugs/problems.
3) Start by complaining into mysql's bug tracker
4) There is only one thing I can do, but that will need more testing
from users and only on 3.8.

On Sat, Jan 24, 2009 at 12:37 PM, Ham MI-ID, Torsten Brumm
<torsten.brumm [at] kuehne-nagel> wrote:
> Hi Emmanuel,
> just got also some information from our DBA's, they had a look (on Friday night! Wow!) to the query:
>
> SELECT
> DISTINCT main.*
> FROM Users main
> CROSS JOIN ACL ACL_4
> JOIN Principals Principals_1 ON (Principals_1.id = main.id)
> JOIN CachedGroupMembers CachedGroupMembers_2 ON (CachedGroupMembers_2.MemberId = Principals_1.id)
> JOIN Groups Groups_3 ON (Groups_3.id = CachedGroupMembers_2.GroupId)
> WHERE (Principals_1.Disabled = '0')
> AND (ACL_4.PrincipalType = Groups_3.Type)
> AND (Principals_1.id != '1')
> AND (Principals_1.PrincipalType = 'User')
> AND (ACL_4.RightName = 'OwnTicket')
> AND ((ACL_4.ObjectType = 'RT::Queue')
> OR (ACL_4.ObjectType = 'RT::System'))
> AND ((Groups_3.Domain = 'RT::Queue-Role')
> OR (Groups_3.Domain = 'RT::System-Role'))
> ORDER BY main.Name ASC;
>
> And they came back with a much more faster query doing the same:
>
> SELECT STRAIGHT_JOIN DISTINCT main.* FROM
> ACL ACL_4,
> Groups Groups_3,
> CachedGroupMembers CachedGroupMembers_2,
> Principals Principals_1,
> Users main
> WHERE ((ACL_4.PrincipalType = Groups_3.Type))
> AND ((ACL_4.RightName = 'OwnTicket'))
> AND ((CachedGroupMembers_2.MemberId = Principals_1.id))
> AND ((Groups_3.id = CachedGroupMembers_2.GroupId))
> AND ((Principals_1.Disabled = '0'))
> AND ((Principals_1.PrincipalType = 'User'))
> AND ((Principals_1.id != '1'))
> AND ((main.id = Principals_1.id))
> AND ((ACL_4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType = 'RT::System'))
> AND ((Groups_3.Domain = 'RT::Queue-Role') OR (Groups_3.Domain = 'RT::System-Role')) ORDER BY main.RealName ASC;
>
> As you can see, less JOINS/CROSS JOINS. This Query is done in a few seconds compared to the one from SearchBuilder with 200sec and more.
>
> Possibly a starting point for the RTDB Guys to review Searchbuilder...?!? But i'm not a DBA---
>
> 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 [at] lists [mailto:rt-users-bounces [at] lists] Im Auftrag von Emmanuel Lacour
> Gesendet: Freitag, 23. Januar 2009 15:25
> An: rt-users [at] lists
> Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI
>
> On Fri, Jan 23, 2009 at 02:55:21PM +0100, Ham MI-ID, Torsten Brumm wrote:
>> Hi Emmanuel,
>> just for my understanding: If they have somewhere the right to own
>> ticket and i do a bulk update only in one queue where only 5 people
>> have own ticket rights, all the users will be queried?
>>
>> How can i easily check if they (especially the unpriviledged users) have own ticket rights?
>>
>
> you can use bulk update on a search result involving more than one queue. And so in Search/Bulk.html, no queue is passed to Elements/SelectOwner, and so all people that can own ticket are displayed.
>
>
> maybe we can try to get the list of queues from search result and pass it to SelectOwner to reduce the list... but maybe gt of this list will slow down Bulk.html to much ??? I need to try this.
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com Commercial support: sales [at] bestpractical
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales [at] bestpractical
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>

--
Best regards, Ruslan.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

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

torsten.brumm at googlemail

Jan 25, 2009, 11:50 PM

Post #18 of 18 (870 views)
Permalink

Re: Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI [In reply to]

Hi Ruslan,
no problem, if i can check something, let me know, i have already portet our
installation to 3.8.2 in test environment.
Torsten

2009/1/26 Ruslan Zakirov <ruslan.zakirov [at] gmail>

> 1) CROSS JOIN is equal to ","
> 2) STRAIGHT JOIN is workaround for mysql bugs/problems.
> 3) Start by complaining into mysql's bug tracker
> 4) There is only one thing I can do, but that will need more testing
> from users and only on 3.8.
>
>
> On Sat, Jan 24, 2009 at 12:37 PM, Ham MI-ID, Torsten Brumm
> <torsten.brumm [at] kuehne-nagel> wrote:
> > Hi Emmanuel,
> > just got also some information from our DBA's, they had a look (on Friday
> night! Wow!) to the query:
> >
> > SELECT
> > DISTINCT main.*
> > FROM Users main
> > CROSS JOIN ACL ACL_4
> > JOIN Principals Principals_1 ON (Principals_1.id = main.id)
> > JOIN CachedGroupMembers CachedGroupMembers_2 ON
> (CachedGroupMembers_2.MemberId = Principals_1.id)
> > JOIN Groups Groups_3 ON (Groups_3.id = CachedGroupMembers_2.GroupId)
> > WHERE (Principals_1.Disabled = '0')
> > AND (ACL_4.PrincipalType = Groups_3.Type)
> > AND (Principals_1.id != '1')
> > AND (Principals_1.PrincipalType = 'User')
> > AND (ACL_4.RightName = 'OwnTicket')
> > AND ((ACL_4.ObjectType = 'RT::Queue')
> > OR (ACL_4.ObjectType = 'RT::System'))
> > AND ((Groups_3.Domain = 'RT::Queue-Role')
> > OR (Groups_3.Domain = 'RT::System-Role'))
> > ORDER BY main.Name ASC;
> >
> > And they came back with a much more faster query doing the same:
> >
> > SELECT STRAIGHT_JOIN DISTINCT main.* FROM
> > ACL ACL_4,
> > Groups Groups_3,
> > CachedGroupMembers CachedGroupMembers_2,
> > Principals Principals_1,
> > Users main
> > WHERE ((ACL_4.PrincipalType = Groups_3.Type))
> > AND ((ACL_4.RightName = 'OwnTicket'))
> > AND ((CachedGroupMembers_2.MemberId = Principals_1.id))
> > AND ((Groups_3.id = CachedGroupMembers_2.GroupId))
> > AND ((Principals_1.Disabled = '0'))
> > AND ((Principals_1.PrincipalType = 'User'))
> > AND ((Principals_1.id != '1'))
> > AND ((main.id = Principals_1.id))
> > AND ((ACL_4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType =
> 'RT::System'))
> > AND ((Groups_3.Domain = 'RT::Queue-Role') OR (Groups_3.Domain =
> 'RT::System-Role')) ORDER BY main.RealName ASC;
> >
> > As you can see, less JOINS/CROSS JOINS. This Query is done in a few
> seconds compared to the one from SearchBuilder with 200sec and more.
> >
> > Possibly a starting point for the RTDB Guys to review Searchbuilder...?!?
> But i'm not a DBA---
> >
> > 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 [at] lists [mailto:
> rt-users-bounces [at] lists] Im Auftrag von Emmanuel Lacour
> > Gesendet: Freitag, 23. Januar 2009 15:25
> > An: rt-users [at] lists
> > Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 /
> MySQL 5.0.67 /Apache2.2.3/FastCGI
> >
> > On Fri, Jan 23, 2009 at 02:55:21PM +0100, Ham MI-ID, Torsten Brumm wrote:
> >> Hi Emmanuel,
> >> just for my understanding: If they have somewhere the right to own
> >> ticket and i do a bulk update only in one queue where only 5 people
> >> have own ticket rights, all the users will be queried?
> >>
> >> How can i easily check if they (especially the unpriviledged users) have
> own ticket rights?
> >>
> >
> > you can use bulk update on a search result involving more than one queue.
> And so in Search/Bulk.html, no queue is passed to Elements/SelectOwner, and
> so all people that can own ticket are displayed.
> >
> >
> > maybe we can try to get the list of queues from search result and pass it
> to SelectOwner to reduce the list... but maybe gt of this list will slow
> down Bulk.html to much ??? I need to try this.
> >
> >
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com Commercial support:
> sales [at] bestpractical
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
> >
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com
> > Commercial support: sales [at] bestpractical
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
> >
>
>
>
> --
> Best regards, Ruslan.
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales [at] bestpractical
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>

--
MFG

Torsten Brumm

http://www.torsten-brumm.de

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads