Hi
RT-4.2 , Mysql 5 apache2 with mod_perl
I would like to add a file from “Upload one file” custom field as an attachment
within Update.html
Ie , when a user update a ticket (reply or comment), under certain conditions I
would like the file stored in an “Upload one file” ticket CF to be added
Hi
RT version 4.0.13
I am having problems creating ticket from REST interface
[root@myrt RestClient]# RTDEBUG=3 ./rt create -t ticket set id='ticket/new'
Queue='Testing' subject='new ticket'
POST http://myrturl/REST/1.0/show
Content-Length: 264
Content-Type: multipart/form-data; boundary=xYzZY
...@lists.bestpractical.com] On Behalf Of Raed El-Hames
Sent: 31 January 2013 18:05
To: Thomas Sibley; RT Users
Subject: Re: [rt-users] How to customize in local/lib
Need to remember reply all.
Attached is my Tickets_Local.pm, please note my changes are commented by
Added by Daisy
UserQueues is a table that populates
...@lists.bestpractical.com] On Behalf Of Raed El-Hames
Sent: 31 January 2013 11:11
To: Thomas Sibley; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Passwords not working after upgrade to rt-4.0.8
Hi Thomas,
Thanks for your response.
There is nothing in my local/lib (no local changes applied yet):
[root@rt
Hi,
Sorry if this have been asked before, but I could n’t see anything in the
archives or via web search.
I just started the process of upgrading my rt-3.8.7 to rt-4
With rt-4 the Overlay files have been removed, and I am wondering what is the
proper way to add or modify existing functions
Hi,
First of all apologies for the length of signature (I really can't do anything
about it).
I am in the process of upgrading my rt-3.8.7 to rt-4.0.8 , I followed all the
README and Upgrade docs.
I am installing into a clean rt4 directory, and only put in cosmetic
customisation .
Ran
make
Mario,
Have a look at Ticket/Elements/ShowRequestor to help you.
Basically get the Requestors list, these are members of a group that define the
requestors of the ticket:
my $people = $Ticket-Requestors-UserMembersObj;
then go through the members to display the properties you want:
while ( my
Adrian,
You have 2 options,
1- Get the 2 organisation to use 1 RT , use groups/queues rights and
permissions to do the separations, then tickets crossing organisations will be
simply moving queue.
2- Option 2 is have a queue for org B on RT-A B , and set up on Queue
change/Correspondence and
Hi,
I am on rt-3.8.7
We have 2 custom fields related via Category, where selecting one determines
the content of the second field dropdown, and we had few values for the second
custom field with the category was left at 'no value', so these are displayed
as generic options for any value of the
John,
The spell checking will need to be client side because I guess will need your
users to do the checking before submit? (or have I missed something??)
As Thomas previously suggested most browsers these days include spell check
plugins , but if you wish you can look into some of the
Richard,
Is there a recommended way to record the 'first contact/response' time
without analyzing the transactions?
You can going forward , I've done something similar a while back , my
requirement were to calculate the first response time to the customer from the
ticket created time,
Chris,
I would guess client == Requestor?
I would disable the scrip On Create notify AdminCC and create a new one with
Action Notify Admin but with User defined condition.
Your condition code will depend how you can distinguish that the requestor is
not a member of the admincc group, for
How did you set up your RT mail, exim , fetchmail ??
Have a look at http://requesttracker.wikia.com/wiki/ItsFinallyInstalledNowWhat
for more information.
Regards;
Roy
[cid:image6ea795.GIF@1c454eed.4b9fc82e]
Visit our website today www.daisygroupplc.comhttp://www.daisygroupplc.com
Bart,
Can you keep us (me anyway) informed how the below solution works out for you,
I am wondering how it will work if you need to link tickets cross different
sites??
At the moment with mod_perl2 I am running 1 rt database one rt code tree for 2
different sites (urls) but with 2 different
John,
You need to edit Elements/QuickCreate and change
option value=%$session{'CurrentUser'}-id%
selected=selected%$session{'CurrentUser'}-Name %/option
option value=%$RT::Nobody-id%%loc('Nobody')%/option
TO
option value=%$RT::Nobody-id %
selected=selected%loc('Nobody')%/option
option
Josh,
As far as I know your only fix is through the database directly.
Login in to your RT database and
select id from Users where Name = 'root'; #on my system the id of root == 12
select id from Groups where Name = 'User 12'; #on my system this id = 13
select id from Principals where
Dave,
Your scrip is telling RT on Create ( Condition: On Create) = resolve the
ticket.
You can either change your condition to User defined and add a bit of logic to
your Custom condition: to identify ticket creation. Or keep your condition to
On Create and move your:
my $match = Order
-
boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: 12 July 2011 23:07
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Can't call method ContentAsMIME on an undefined
value
On Tue, Jul 12, 2011 at 04:47:41PM +, Raed El-Hames wrote:
Kevin,
Apologies Kevin
Kevin,
Apologies Kevin but I put your name because through the archive I noticed you
looked into similar problem.
When trying to forward an update with an attachment and no text update I get
the error Can't call method ...
I noticed back in December another list user had the same issue (Ticket
Fabian,
The Creator of a ticket is in most cases the requestor unless they decided to
change that by entering a different email address in the requestor field when a
ticket is first created. I think the scenario you describing below will most
likely be the creator == requestor.
Customers
Jeff,
If you are in a position to do it via sql , then I would suggest you take this
route.
By via sql I mean you are able to do statements like (insert into
development_db.Users (select * from production_db.Users) etc ..
If you ignoring Tickets and Attachments I would also ignore the
.
Regards;
Roy
From: pleh.i...@gmail.com [mailto:pleh.i...@gmail.com] On Behalf Of Bart
Sent: 15 June 2011 20:36
To: Raed El-Hames
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Need some help with suppliers
Hi Roy,
That sounds like a very clean solution :-)
We were already looking
...@gmail.com [mailto:pleh.i...@gmail.com] On Behalf Of Bart
Sent: 16 June 2011 10:40
To: Raed El-Hames
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Need some help with suppliers
Hi,
Was this the sample script you used on the wiki?
http://requesttracker.wikia.com/wiki
Giuseppe,
I will not give the Everyone group rights other than Create Ticket and
ReplyToTicket (and this is only to get the email side of things working
properly).I also would not give any rights to the Unprivileged group.
For your purposes I would suggest you give the Requestor Role rights to
12:06, Raed El-Hames wrote:
Giuseppe,
I will not give the Everyone group rights other than Create Ticket and
ReplyToTicket (and this is only to get the email side of things working
properly).I also would not give any rights to the Unprivileged group.
For your purposes I would suggest
($MyUserId);
if ($id) {
$u-SetPrivileged(0);
}
}
Regards;
Roy
-Original Message-
From: Giuseppe Sollazzo [mailto:gsoll...@sgul.ac.uk]
Sent: 10 June 2011 15:33
To: Raed El-Hames
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] limit ticket list display on requestor login
Rithy:
Create a script that run via cron , which looks for tickets in a particular
status and if the last update was over 5 days , then get the scripts to resolve
the ticket.
Over here we added a new status 'completed', once we think the issue is fixed
we ask the customer to confirm if they
Bart:
The offline tool will help you create the tickets as Ken suggested , however if
you are looking to include any of your old tickets history (correspondence /
updates), then I would recommend you look into using perl script and the rt api.
Roy
From:
...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: 16 May 2011 18:43
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Load Saved charts
On Mon, May 16, 2011 at 04:18:21PM +, Raed El-Hames wrote:
Rt-3.8.8
Mysql5 and apache2 with mod_perl2
Loading saved charts seems
-
boun...@lists.bestpractical.com] On Behalf Of Raed El-Hames
Sent: 17 May 2011 17:57
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Load Saved charts
Kevin:
Thanks for the reply.
Can you tell me where I can find the rt bug tracker, I could not find any
links from the mail
Hi:
Rt-3.8.8
Mysql5 and apache2 with mod_perl2
Loading saved charts seems not to be working,
Created a search, charted it , saved the chart , ran a second search , charted
it, but when trying to load the first saved chart, all I get is the second
chart refreshed??
I am not sure if the Saved
Mike:
You need to explain what you mean by a specific type of ticket??
If its only dependant on the queue, then there is a couple of ways to do this,
If the same text for a selected number of queues , then in Create.html define
$ARGS{Content} with the text you wish presented if ($QueueObj-Name)
I gather each work group are admin cc on their queue,
If this is the case then try
AdminCc.id = '__CurrentUser__'
Regards;
Roy
-Original Message-
From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
boun...@lists.bestpractical.com] On Behalf Of Yan Seiner
Sent: 05 May
Lars:
we stored a saved search (Tickets) in RT System's saved searches with
the intention to make the search visible to all users.
RT System Saved Searches are only available to SuperUsers, these are the
searches you include as default in home page etc etc.
I think for your purposes and if
Nathan:
There are different ways of dealing with the scenario you have.
What I do in here in a set up very similar to yours, is create a ticket with
the customer contact as a requestor,
When 3rd party supplier needed I create a linked/child ticket in queue that
does not send a standard
Garry:
Try:
Created 'now' AND Created '2 week ago' AND Queue = 'FOO'
Roy
-Original Message-
From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
boun...@lists.bestpractical.com] On Behalf Of Garry Booth
Sent: 05 April 2011 16:05
To: RT Users
Subject: [rt-users]
a
theological thought, ;-).
Kenn
LBNL
On Tue, Apr 5, 2011 at 8:28 AM, Raed El-Hames
raed.el-ha...@daisygroupplc.commailto:raed.el-ha...@daisygroupplc.com wrote:
Garry:
Try:
Created 'now' AND Created '2 week ago' AND Queue = 'FOO'
Roy
-Original Message-
From:
rt-users-boun
Mark:
Have a look at rt-crontool , I think it may help you.
Roy
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Roedel, Mark
Sent: 31 March 2011 21:45
To: rt-us...@bestpractical.com
Subject: [rt-users] recurring requests
Obviously
Adrian:
You can modify the templates associated with the emails you want to send (ie
Correspondence template, Admin Comment templates etc) to include the Priority
Eg:
Subject: [Comment] [{$Ticket-QueueObj-Name}] [$Ticket-Subject] Priority
[{$Ticket-Priority}]
I would suggest you put the
Walid:
I've done something similar but my approach was slightly different.
My customers in most cases have more than one contact, so for every customer I
created a group, and added their contacts as members of their group, the group
name is the customer name, and I added a couple of group
;
Roy
From: Walid Haider [mailto:walid.hai...@movensis.com]
Sent: 24 March 2011 14:53
To: Raed El-Hames; rt-users@lists.bestpractical.com
Subject: RE: Support Contract Client Check
Hi Roy,
Thanks for your response, any chance you can send me an example of the global
scrip you are using?
Regards
Yes its possible, but the cf fields will be visible (with empty values) to all
tickets in the queue where the cfs apply to.
You should be able to auto populate the cf fields via a scrip, you can do that
under any conditions you define (create/update/or change of any field that have
a
1- I have my RT talking to another RT bidirectional using REST
2- It also talks to a windows based ticketing system via web services (soap on
my RT end and .net service at the destination) -- The soap interface is
something I've done here and very customised to our needs
3- It also talks to
Yan:
One way of doing this is to put the hack in Elements/SelectStatus
Something like :
if
($session{'CurrentUser'}{'can_resolve_ticket_or_whatever_you_want_to_call_it'})
{
@status = $queue-StatusArray();
} else {
@status = RT-Config-Get('ActiveStatus') ;
}
The above will hide the non
Search users for her email address .. Then edit the entry found for her details
giving her the appropriate rights, privilege etc. You will be able to change
the user name if you wish.
Roy
-Original Message-
From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
On Thu, Mar 3, 2011 at 1:27 AM, Kevin Falcone falc...@bestpractical.com
wrote:
On Wed, Mar 02, 2011 at 12:10:41PM +, Raed El-Hames wrote:
Hi:
RT-3.8.7
Mysql,Apache2, mod_perl v2.04; HTML::Mason v1.39;
When updating 2 tickets (tickets 1,2 as an example) at the same time
Hi:
RT-3.8.7
Mysql,Apache2, mod_perl v2.04; HTML::Mason v1.39;
When updating 2 tickets (tickets 1,2 as an example) at the same time, using 1
browser and 2 tabs:
If I upload files A and B into ticket 1, and while waiting for the file upload
to complete I decide to update ticket 2, the
Yan:
I do get this when I have changed the organisation name (re branding etc),
where every user that have saved his search options will get the old url in
their searches and the new one.
Have you had this system installed/set up under a difference url?
Do the users who get this , have had
Lars
I might be wrong but I don’t think the cli cater for rights (groups or users),
I find the clicky clicky web interface annoying in particular when adding few
users or few groups etc etc .. and to avoid that I ‘ve written scripts using
the rt api (so its database/rt conformed) ….
My scripts
Alberto:
Based on your questions and requirements below, I would suggest you set up a
new RT instance altogether.
Read a bit more about request tracker. You cannot have a url for each queue,
you are able to assign an email address for it (if this is what you want), but
the GUI/URL is the same
oldOwner ?
I think you grab that from the TransactionObj-OldValue, and find the user
object and its email address from there.
Sorry I cannot remember the exact syntax, I am no where near my RT.
Roy
-Original Message-
From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
-Load({$Transaction-OldValue) ;
$user_email = $userObj-EmailAddress ;
Etc etc
Roy
-Original Message-
From: Björn Schulz [mailto:bjoern.sch...@desy.de]
Sent: 24 February 2011 15:33
To: Raed El-Hames
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] owner change - old owner
You can stop certain emails from receiving updates on particular tickets by
using the This message will be sent to form available in the update page.
Just tick the right boxes to remove them from the cc list.
An alternative would be to remove the main group as watcher/cc on that queue
and
Jon:
Another way to achieve what you want and eliminate having to set owner then
revoke it via the script is by modifying
/Elements/SelectOwner
Just get it to return the owner name as a string if the $session{'CurrentUser'}
is not a member of the IT Admin group.
Else If CurrentUser IT Admin
: Thierry Thelliez [mailto:thierry.thelliez.t...@gmail.com]
Sent: 03 February 2011 18:31
To: Raed El-Hames
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Load balancer and RT
Roy,
Thanks for your answer. Could you please tell me more about your
proxy settings?
We have a virtual
Bryan:
I think you can do that via a configuration variable in your
rt3/etc/RT_Config.pm
Have a look there.
Regards;
Roy
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Bryan Thoren
Sent: 04 February 2011 10:37
To:
Thierry:
If you are storing the sessions data in the database you should n't have any
problems.
We 've been running our RT on 2 boxes behind LVS for the past few years without
any major issues.
The occasional keep alive hiccups which tend to be fixed pretty quickly without
any major impact.
Pierre:
my $queues = new RT::Queues(RT::SystemUser);
is fine but you need to limit
Just add
$queues-UnLimit;
my $queues = new RT::Queues(RT::SystemUser);
$queues-UnLimit;
foreach my $queue ($queues-Next) {
}
By the way , a comment on your next bit, I am just curious why you build a hash
,
Todd,
Another approach is to dissect DeleteWatcher into its row sql and re-write your
script to talk sql directly instead of going through the api ... (Its highly
not recommended) but with 20 million rows its an option.
The advantages you gain is not having to do as many selects.
You may still
Hi Jeff:
Stupid question by where did you put your callback call??
I added
% $m-callback(CallbackName = 'BeforeDisplay',TicketObj = \$TicketObj,Tickets
= \$Tickets,Actions = \...@actions,ARGSRef = \%ARGS);
Just above :
% $m-callback(CallbackName = 'BeforeActionList', %ARGS, Actions =
Hi Ken its me again:
Have a look at share/html/Elements/ColumnMap
# This is scary and should totally be refactored -- jesse
my $COLUMN_MAP = {
id = {
attribute = 'id',
title= 'id', # loc
align = 'right',
value = sub { return $_[0]-id }
},
You
quotes around a CF name. Did I miss that or did you come by that
info via trail error?
Now, again, I owe you MORE beer. ;-).
Thanks.
Kenn
LBNL
On Fri, Oct 15, 2010 at 9:44 AM, Raed El-Hames
raed.el-ha...@vialtus.commailto:raed.el-ha...@vialtus.com wrote:
Ken:
Can't see much wrong , the only
Hi Ken:
It usually throw you into the Advanced tab when the sql generated is not
properly formatted into FromSQL ..
Can you share what you get in the advanced Query ? it may also be a problem in
the displayed fields listed in Format.
Regards;
Roy
From:
, Raed El-Hames
raed.el-ha...@vialtus.commailto:raed.el-ha...@vialtus.com wrote:
Hi Ken:
It usually throw you into the Advanced tab when the sql generated is not
properly formatted into FromSQL ..
Can you share what you get in the advanced Query ? it may also be a problem in
the displayed fields
-AddCustomFieldValue( Field=$cf_obj, Value=$cf_value,
RecordTransaction=0 );
return 1;
Thanks for your help.
Kenn
LBNL
On Mon, Oct 11, 2010 at 2:36 AM, Raed El-Hames
raed.el-ha...@vialtus.commailto:raed.el-ha...@vialtus.com wrote:
Ken:
Can you post the code that you cut and pasted to get a better idea
Hi:
RT-3.8.7
Apache2
Mysql
perl5 (revision 5 version 8 subversion 8)
mod_perl2 v2.04;
DBIx::SearchBuilder v1.56;
DBD::mysql v4.005;
DBI v1.605;
When a user run a search that returns 5 tickets , the search runs fine
and results back fairly quickly ( 10 seconds).
However if a user
] On Behalf Of
Ruslan Zakirov
Sent: 12 October 2010 14:50
To: Kenneth Marshall
Cc: rt-users@lists.bestpractical.com; Raed El-Hames
Subject: Re: [rt-users] memory leak after search
Hi.
Quiet right and that has been fixed in 3.8.8.
Regards, Ruslan. From phone.
2010 10 12 17:05 пользователь Kenneth
2010 16:30
To: Raed El-Hames
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] memory leak after search
You must be running one of the biggest RT setups in the world:-)
You have clearly answered me and cleared my mind.
Thanks
On Tue, Oct 12, 2010 at 6:20 PM, Raed El-Hames
raed.el-ha
To: Raed El-Hames; Odhiambo Washington
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] memory leak after search
You also said you have 5,000,000 users.
Are you running a trouble ticket system for the nation of Switzerland, perhaps,
and each living adult gets an account?
I'm filing
Ken:
Can you post the code that you cut and pasted to get a better idea of the
problem.
Also something that I always fall into , is writing my action code in Custom
action cleanup code: and forgetting about and leaving
Custom action preparation code: completely empty, you will need
return
Have you tried:
Created = 'today'
You can build this in the search interface by selecting:
Created on today
Regards;
Roy
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Sysadmin
Sent: 18 September 2010 00:34
To:
, at 11:51, Raed El-Hames wrote:
Justin,
Do you use Transaction custom fields, if you do n?t ; try and
comment out lines 70,71,72 from html/Ticket/Elements/ShowTransaction
% if ( $Transaction-CustomFieldValues-Count ) {
/Elements/ShowCustomFields, Object = $Transaction
% }
See
Peter,
I have seen the RT-Extension-MandatorySubject plugin and this is great for
opening tickets via the web interface. However, my company opens at least
90% of its tickets via email. Is there anything out that can enforce
mandatory subjects on tickets opened via email?
How would
Hi;
Its probably easier to install the ConciseSpreadsheet extension:
http://search.cpan.org/~jesse/RT-View-ConciseSpreadsheet-0.002/
It allows you to export your search results (whatever fields selected for the
search display columns) into a spreadsheet
Roy
-Original Message-
From:
Hi Rahul;
Ø Does creation of custom fields in RT will bring any performance issue.
No ; Obviously if you add 100 cf to a ticket it will take a lot longer to
display because it will need to look up these CF values
Ø Do RT maintains a different table to stores these custom tables.
Yes 4 of
Hi David;
What version of RT are you using, if its 3.8.8 then you should be able to
change the user name format from
lib/RT/Config.pm
With regard to owner script, I am not quite sure what do you mean by does not
allow me to use owner change as it was intended
What does n't not do ??
Roy
Hi;
RT-3.8.7
Can some one give me a brief explanation of how custom field validation works
through the code.
I tracked back as far as lib/Record.pm :: _AddCustomFieldValue;
However I am not sure how/where the following happens:
unless ( $cf-ValidateValue( $args{'Value'} ) ) {
return (
that makes a little more sense.
Thanks,
David
System Admin
RNS
On 8/6/2010 3:47 AM, Raed El-Hames wrote:
Hi David;
What version of RT are you using, if its 3.8.8 then you should be
able to change the user name format from
lib/RT/Config.pm
With regard to owner script, I am
Hi;
rt-3.8.8
apache2
Using Internet explorer 8
I have a custom field where the Categories are based on another , using
Internet explorer when users are selecting the values for both fields and
clicking on Save Changes the dropdown for the dependant CF is reverting to (no
value), however the
Hi Chris;
The value of the information you want to hide is only appreciated when
you need it.
But its possible to remove them from the ticket history by editing:
Ticket/Elements/ShowHistory
In the %INIT section change:
} else {
$Transactions = $Ticket-Transactions;
}
to
} else {
Download the src from bestpractical, then read the README and UPGRADING docs
Is there anything in particular you are concerned with??
If its a busy production system I always recommend having a development
version , upgrade that one first , test then test again , if everything
ok then upgrade
I really do not understand why you would need nagios for this?
We have very much similar kpis which we monitor with a simple perl
script utilising the RT api.
Our script run every hour , update the tickets with a warning comment
if the warning threshold is reached (Admin Ccs receive an email
Hi;
rt-3.8
modperl 2
apache 2
I had few reports from my rt users with the following error:
Can't call method id on unblessed reference at
/opt/rt3/bin/../lib/RT/Interface/Web.pm line 235
They get this when ever a session have expired , and the only cure is to
kill the browser (all tabs)
Jeff;
Does your CLI user have permissions on the queue that ticket 39 is in??
login to the web interface with the same cli user and see if you can
view the ticket.
Regards;
Roy
Jeff Blaine wrote:
On 4/26/2010 11:50 AM, Kenneth Marshall wrote:
Hi Jeff,
There is nothing here that
Max:
*
*
Edit Create.html change
td class=value colspan=5
/Elements/EmailInput, Name = 'Requestors', Size = '40', Default =
$ARGS{Requestors} || $session{CurrentUser}-EmailAddress
/td
to
td class=value colspan=5
% if ($QueueObj-Name eq 'Quick Ticket') {
/Elements/EmailInput, Name =
Hi Evan;
I think Gene answered 1;
For 2 I have something similar, but what I do on failure is to submit a
comment to the ticket with an explanation why the queue move have failed.
As far as I know the text in the Results section @results is
generated/built while processing the actions , and
Ian;
Depends what this un that means
You can easily give the Super User right to the Everyone group :¬) --
I am sure you don't want to do that
Rights can be simple it all depends on what you are planning to do. --
and for the same reason its difficult for some one to have a generic
rights
Kristian;
What happens if you move your action code to the condition and then make
you rAction : Notify Requestors with the Template you need ; ie your
condition will be something like:
Custom Condition:
my $Transaction = $self-TransactionObj;
my $CreatorId = $Transaction-CreatorObj-Id;
if
Hi;
rt-3.8.7
mysql 5.1
The following query :
SELECT DISTINCT main.* FROM Tickets main CROSS JOIN Users Users_3 JOIN
Groups Groups_1 ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND (
Groups_1.Type = 'Requestor' ) AND ( Groups_1.Instance = main.id ) LEFT
JOIN CachedGroupMembers
Ronald;
I don't think you stated what version of mysql you are using?
If its less than version 5 then I would recommend upgrading , as far as
I know more recent versions of mysql have better query optimisers.
Once you are on version 5.x have a look at table partitioning, in our
system the only
?
Torsten
2010/4/19 Raed El-Hames r...@vialtus.com mailto:r...@vialtus.com
Ronald;
I don't think you stated what version of mysql you are using?
If its less than version 5 then I would recommend upgrading , as
far as I know more recent versions of mysql have better query
Sergio Charpinel Jr. wrote:
Thanks for your answers.
Actually, I wanna change a custom field based in a change of another
one. So, trying what Raed said, I wrote a Custom Condition to verify
if it is a custom condition change.
But I had the same problem.. When I update via Web interface, the
to do this?
2010/4/19 Raed El-Hames r...@vialtus.com mailto:r...@vialtus.com
Sergio Charpinel Jr. wrote:
Thanks for your answers.
Actually, I wanna change a custom field based in a change of
another one. So, trying what Raed said, I wrote a Custom
Condition
Steven;
As far as I know there is n't ; what I did is create a global custom
field , and a global scrip that populates its values with condition on
Status change from new to open, and the action is user defined
subtracting the unix time now - the unix created time; then populating
the field
Are you creating the ticket from the web interface and that custom field
exist in the form;
Most likely the script is changing it to the value you want, then its
changing again to the value given in the form while processing the form ??
Is that what is happening??
If its , I would suggest you
] On Behalf Of Raed El-Hames
Sent: Friday, April 16, 2010 6:02 AM
To: Steven Platt
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] find time span between dates
Steven;
As far as I know there is n't ; what I did is create a global custom
field , and a global scrip that populates its
Hi;
rt-3.8.7
mysql 5.1
Is the index DisGrouMem (GroupId,MemberId,Disabled) required for 3.8
When I did:
select * from CachedGroupMembers where Disabled = 1;
I got back 232 rows out of 5594612
Which in my opinion makes that index useless ?
Ist required , can I drop it??
Regards;
Roy
at 02:17:10PM +0100, Raed El-Hames wrote:
Hi;
rt-3.8.7
mysql 5.1
Is the index DisGrouMem (GroupId,MemberId,Disabled) required for 3.8
When I did:
select * from CachedGroupMembers where Disabled = 1;
I got back 232 rows out of 5594612
Which in my opinion makes that index useless ?
My
Thanks to everyone reply ..
I should have done a bit more research first , I had another index
combining (GroupId,MemberId) that must have been added by me/some one in
my organisation,
and I wrongly assumed that RT created both indexes making the DisGrouMem
(GroupId,MemberId,Disabled) useless.
Hi;
You can include something like:
{my $subq = $Ticket-FirstCustomFieldValue('sub queues')}
In the body of the template; any where you wish 2 lines below the header
lines
Regards;
Roy
psminusaxl wrote:
Hi guys,
I got a template that sends out an email everytime a ticket is
created.
1 - 100 of 193 matches
Mail list logo