[rt-users] DB layout and getting the requestors for a ticket

2011-02-09 Thread Tobias Hieta
Hello, First of all I would like to say: I know this is not the best way to do it, I know the underlying database will probably change and my non-warranty is even more void. BUT, I would like to select requestors and owner etc from a ticket directly on the database (I am using MySQL), I have

[rt-users] Possible Bug in 'Scrips and Recipients' and TransactionBatch

2011-02-09 Thread Tobias Hieta
Hello, I have noticed that when we switched some of our Scripts to TransactionBatch from TransactionCreate the email addresses affected by those scrips where removed from the 'Scrips and Recipients' window in Update/Reply to ticket. Is this a known bug or am I doing something else wrong?

[rt-users] Default auto-refresh interval

2011-02-09 Thread Michael Brown
Hi, I had a customer request to set the default home page refresh interval to 2 minutes for all users. I found several suggestions that essentially involved modifying the code (e.g. by creating a local version of Elements/Login or Elements/Refresh), but wanted to avoid code customisations if

[rt-users] Creating a ticket whose content is foo

2011-02-09 Thread Wolfram Huettermann
Hello, I think this is a stupid question that I ask you old-timers in RT. I intend to create a ticket in the queue test and the content is foo in shell, not in MASON. Here is the code snippet: my $CurrentUser = GetCurrentUser(); use RT::Tickets; my $Ticket = RT::Ticket-new($CurrentUser); my

Re: [rt-users] DB layout and getting the requestors for a ticket

2011-02-09 Thread Gerard FENELON
Tobias Something similar to FROM Tickets AS Ticket JOIN Groups AS ReqGroup ON ReqGroup.instance = Ticket.id JOIN GroupMembersAS ReqGroupMember ON ReqGroupMember.GroupId = ReqGroup.id JOIN

Re: [rt-users] Possible Bug in 'Scrips and Recipients' and TransactionBatch

2011-02-09 Thread Kevin Falcone
On Wed, Feb 09, 2011 at 12:42:46PM +0100, Tobias Hieta wrote: I have noticed that when we switched some of our Scripts to TransactionBatch from TransactionCreate the email addresses affected by those scrips where removed from the 'Scrips and Recipients' window in Update/Reply to ticket. Is

Re: [rt-users] Question about Scripts

2011-02-09 Thread Kevin Falcone
On Tue, Feb 08, 2011 at 02:43:07PM -0800, Tim Gustafson wrote: Hi, I have an RT installation that is quite old now, and has been handed down to me by a person who is no longer with us. The configuration has been modified and modified over the years and I'm not sure how closely it resembles

Re: [rt-users] Default auto-refresh interval

2011-02-09 Thread Kevin Falcone
On Wed, Feb 09, 2011 at 01:37:17PM +, Michael Brown wrote: I had a customer request to set the default home page refresh interval to 2 minutes for all users. I found several suggestions that essentially involved modifying the code (e.g. by creating a local version of Elements/Login or

Re: [rt-users] DB layout and getting the requestors for a ticket

2011-02-09 Thread Tobias Hieta
Thanks Gerard, I will try that at once. -- Tobias - Original Message - Tobias Something similar to FROM Tickets AS Ticket JOIN Groups AS ReqGroup ON ReqGroup.instance = Ticket.id JOIN GroupMembers AS ReqGroupMember ON ReqGroupMember.GroupId = ReqGroup.id JOIN Users AS

Re: [rt-users] DB layout and getting the requestors for a ticket

2011-02-09 Thread Ruslan Zakirov
http://requesttracker.wikia.com/wiki/GetWatcherInfoByTicket On Wed, Feb 9, 2011 at 5:27 PM, Tobias Hieta tobias.hi...@purplescout.se wrote: Thanks Gerard, I will try that at once. -- Tobias - Original Message - Tobias Something similar to FROM Tickets AS Ticket JOIN Groups AS

[rt-users] getting a group of ticket numbers

2011-02-09 Thread Kenneth Marshall
Maybe I cannot see the forest for the trees, but how can you select a group of ticket ids? You can type a single ticket number in the search box and that works, but what if you want tickets numbered 235-331? Any ideas? Cheers, Ken

Re: [rt-users] getting a group of ticket numbers

2011-02-09 Thread Lander, Scott
ID is less than 332 and id is greater than 235? -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Marshall Sent: Wednesday, February 09, 2011 9:39 AM To: rt-users@lists.bestpractical.com Subject:

Re: [rt-users] getting a group of ticket numbers

2011-02-09 Thread Kenneth Marshall
Thank you. I could have sworn that I tried that and it did not work, but it worked now. Ken On Wed, Feb 09, 2011 at 09:50:48AM -0500, Lander, Scott wrote: ID is less than 332 and id is greater than 235? -Original Message- From: rt-users-boun...@lists.bestpractical.com

Re: [rt-users] CF appears after update even without SeeCustomField rights

2011-02-09 Thread Kevin Falcone
On Tue, Feb 08, 2011 at 10:31:25AM -0800, David Good wrote: I've found an issue in two separate 3.8.8 installations. Both have one or more CustomFields that are not supposed to be visible to most users. The CF is managed entirely by Scrips to contain extra information not needed by users.

Re: [rt-users] CF appears after update even without SeeCustomField rights

2011-02-09 Thread Gerard FENELON
Just a note to say that I am also seeing this issue on my 3.8.8 RT instance I have not got round to debugging it yet. Gerard On 2011-02-09 17:29, Kevin Falcone wrote: On Tue, Feb 08, 2011 at 10:31:25AM -0800, David Good wrote: I've found an issue in two separate 3.8.8 installations. Both have

Re: [rt-users] Queue-specific message box contents

2011-02-09 Thread Brian P. Bilbrey
On 02/09/2011 09:08 AM, Dominic Hargreaves wrote: On Wed, Feb 09, 2011 at 08:50:35AM -0500, Brian P. Bilbrey wrote: ... Does anyone have any guidance for me? We do exactly this, using a callback which I've attached to this message. You should install it in your local mason root as

Re: [rt-users] Queue-specific message box contents

2011-02-09 Thread Brian P. Bilbrey
On 02/09/2011 11:35 AM, Kenneth Crocker wrote: Brian, We do this as well, but we use individual Custom Fields with specific values to select from to get a more precise set of inputs. Thanks, Kenn. I also have a number of Custom Fields used for the purpose, but I wanted to provide some

[rt-users] unrecognized time zone name: GMT

2011-02-09 Thread Lee Hughes
Testing RT 3.8.8 with PostgreSQL 9.0.3, seeing these warnings in the Apache error log: [Wed Feb 9 18:46:38 2011] [warning]: DBD::Pg::st execute failed: ERROR: unrecognized time zone name: GMT (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509) [Wed Feb 9 18:46:38 2011]

[rt-users] How to Assign a value to a Custom Field using Requestor Real Name

2011-02-09 Thread Joe Kirby (gmail)
My users would like to have reports on their RT-at-a-Glance page which would parse out their tickets from several queues into a report grouped by the requestors initial of their last name. For example group 1 may be A-F, Group 2 G-K, etc. I was thinking of having a Custom Field associated

Re: [rt-users] unrecognized time zone name: GMT

2011-02-09 Thread Kevin Falcone
On Wed, Feb 09, 2011 at 11:02:05AM -0800, Lee Hughes wrote: Testing RT 3.8.8 with PostgreSQL 9.0.3, seeing these warnings in the Apache error log: That's unusual. What timezones does your Pg know about? http://www.postgresql.org/docs/9.0/static/view-pg-timezone-names.html -kevin [Wed Feb 9

[rt-users] RTFM new install question

2011-02-09 Thread Vance Walsh
When I attempt to grant permissions in RTFM I get the following Can't locate object method ACLEquivalenceObjects via package RT::FM::System at /opt/rt3/bin/../lib/RT/Principal_Overlay.pm line 327. I have 3.8.8 RT running well and just installed RTFM 2.4.1 and fresh installed it. Thoughts on

Re: [rt-users] Default auto-refresh interval

2011-02-09 Thread Michael Brown
On Wednesday 09 Feb 2011 14:23:23 Kevin Falcone wrote: On Wed, Feb 09, 2011 at 01:37:17PM +, Michael Brown wrote: I had a customer request to set the default home page refresh interval to 2 minutes for all users. I found several suggestions that essentially involved modifying the code

Re: [rt-users] RTFM new install question

2011-02-09 Thread Kevin Falcone
On Wed, Feb 09, 2011 at 03:29:02PM -0500, Vance Walsh wrote: When I attempt to grant permissions in RTFM I get the following Can't locate object method ACLEquivalenceObjects via package RT::FM::System at /opt/rt3/bin/../lib/RT/Principal_Overlay.pm line 327. I have 3.8.8 RT

Re: [rt-users] unrecognized time zone name: GMT

2011-02-09 Thread Lee Hughes
Great question Kevin, turns out the timezone files were not readable by postgres. This fix worked: chmod o+r /usr/local/pgsql/share/timezone/* Thanks again for your prompt and excellent help. Lee That's unusual. What timezones does your Pg know about?

Re: [rt-users] CF appears after update even without SeeCustomField rights

2011-02-09 Thread David Good
On 2/9/2011 8:29 AM, Kevin Falcone wrote: On Tue, Feb 08, 2011 at 10:31:25AM -0800, David Good wrote: I've found an issue in two separate 3.8.8 installations. Both have one or more CustomFields that are not supposed to be visible to most users. The CF is managed entirely by Scrips to contain

Re: [rt-users] Default auto-refresh interval

2011-02-09 Thread Michael Brown
On Wednesday 09 Feb 2011 21:24:17 Kevin Falcone wrote: Please obey the Reply-To, I subscribe to the list and don't need personal email. Of course, since you ask so nicely. Doesn't show up in any file my (pre-packaged) version of RT 3.8.1: 3.8.1 is 2.5 years old and vulnerable to multiple

Re: [rt-users] Overlay - local Problem

2011-02-09 Thread Violetta J. Wawryk
Hi, Thanks for the replys. Yes, sorry I forgot to write it is a debian system. Therefore /usr/local/share/request-tracker3.6/lib/RT/Interface/Email.pm worked. Regards, Violetta Am 05.02.2011 19:54, schrieb Dominic Hargreaves: On Fri, Feb 04, 2011 at 11:58:17PM +0100, Christian Loos

Re: [rt-users] Can't change logo

2011-02-09 Thread Jim
Jason A. Smith smithj4 at bnl.gov writes: On 09/10/2010 11:55 AM, John Alberts wrote: I'm trying to change the bp logo that is in the lower right corner of every page. I followed the instruction at: You should probably leave the logo at the bottom right of the page alone, as this