Re: [rt-users] Resolve ticket and include message body in ticket

2009-07-07 Thread Khusro Jaleel
Ken Crocker wrote:
 Resolution comment:
 {
  my $Resolution_Comment;
  my $Transactions;
  my $CommentObj;
 
  $Transactions = $Ticket-Transactions;
  $Transactions-Limit( FIELD = 'Type', VALUE = 'Comment' );
  $Transactions-OrderByCols(
  { FIELD = 'Created',  ORDER = 'DESC' },
  { FIELD = 'id', ORDER = 'DESC' },
  );
 
  $CommentObj = $Transactions-First;
 
  if  ($CommentObj  $CommentObj-id)
  {
   $Resolution_Comment = $CommentObj-Content;
  }
  else
  {
   $Resolution_Comment = No comment.
  }
 
  return $Resolution_Comment;
 }

I tried entering just the above into a new Template and then created a 
Scrip that would run On Resolve. I told the scrip to use this new 
template, however, all I got in the end was

-
Resolution Comment:
No comment
-

I definitely entered a few words into the body of the resolved email 
message. So clearly I've missed something off? I have a feeling it 
should not be $Transactions-First? Wouldn't that give you just the 
first Transaction when we are looking for the last one?

The scrip I'm using is set as On Resolve, Notify AdminCCs as Comment, 
Template MyNewResolvedTemplate, Stage TransactionCreate.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] Resolve ticket and include message body in ticket

2009-07-07 Thread Ken Crocker
Khusro,

The Notify AdminCcs as Comment won't send out an email. At least that 
is my understanding. So, if I'm right, some other scrip is sending out 
the email and therefore your new template is probably NOT being used. Of 
course, if I'm wrong about the as Comment, then ignore my response.

Kenn
LBNL


On 7/7/2009 9:58 AM, Khusro Jaleel wrote:
 Ken Crocker wrote:
 Resolution comment:
 {
  my $Resolution_Comment;
  my $Transactions;
  my $CommentObj;

  $Transactions = $Ticket-Transactions;
  $Transactions-Limit( FIELD = 'Type', VALUE = 'Comment' );
  $Transactions-OrderByCols(
  { FIELD = 'Created',  ORDER = 'DESC' },
  { FIELD = 'id', ORDER = 'DESC' },
  );

  $CommentObj = $Transactions-First;

  if  ($CommentObj  $CommentObj-id)
  {
   $Resolution_Comment = $CommentObj-Content;
  }
  else
  {
   $Resolution_Comment = No comment.
  }

  return $Resolution_Comment;
 }

 I tried entering just the above into a new Template and then created a 
 Scrip that would run On Resolve. I told the scrip to use this new 
 template, however, all I got in the end was

 -
 Resolution Comment:
 No comment
 -

 I definitely entered a few words into the body of the resolved email 
 message. So clearly I've missed something off? I have a feeling it 
 should not be $Transactions-First? Wouldn't that give you just the 
 first Transaction when we are looking for the last one?

 The scrip I'm using is set as On Resolve, Notify AdminCCs as Comment, 
 Template MyNewResolvedTemplate, Stage TransactionCreate.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] Resolve ticket and include message body in ticket

2009-07-07 Thread Ken Crocker
Khusro,

You do not need a Custom Field to do this. The transaction content is 
available at Resolve time via a code in your template. We do this. We 
created our own Resolve template and deleted the delivered one. This 
is our code:
==
Subject: Request Titled: {$Ticket-Subject} has been Resolved!

This ticket has been resolved. DO NOT REPLY to this message!
-
TICKET INFORMATION:
Queue  : {$Ticket-QueueObj-Name}
Number : {$Ticket-Id}
Subject: {$Ticket-Subject}
Priority is: {$Ticket-Priority}
Requestor  : {$Ticket-Requestors-UserMembersObj-First-Name}
Created  by: {$Ticket-CreatorObj-Name}
Created  on: {substr($Ticket-Created, 0, 10)}
Ownedby: {$Ticket-OwnerObj-Name}
Development Started on: {substr($Ticket-Started, 0, 10)}
-
Description of Issue:
 {$Ticket-FirstCustomFieldValue('Description')}

-
Resolution comment:
 {
  my $Resolution_Comment;
  my $Transactions;
  my $CommentObj;

  $Transactions = $Ticket-Transactions;
  $Transactions-Limit( FIELD = 'Type', VALUE = 'Comment' );
  $Transactions-OrderByCols(
  { FIELD = 'Created',  ORDER = 'DESC' },
  { FIELD = 'id', ORDER = 'DESC' },
  );

  $CommentObj = $Transactions-First;

  if  ($CommentObj  $CommentObj-id)
  {
   $Resolution_Comment = $CommentObj-Content;
  }
  else
  {
   $Resolution_Comment = No comment.
  }

  return $Resolution_Comment;
 }
-
To view ticket information, enter URL:

{$RT::WebURL}Ticket/Display.html?id={$Ticket-id}


Hope this helps.

Kenn
LBNL



On 7/7/2009 2:13 AM, Khusro Jaleel wrote:
 Hi,

 I'm quite new to RT and wondering how to do the following.

 I need to resolve a ticket when an email is sent to the queue resolve 
 address, for example, myqueue-reso...@domain.com. This is fine, and I 
 have managed to do this by adding a new 'rt-mailgate' command with an 
 action of 'resolve' to my /etc/aliases file.

 However, the person sending this email will include some text describing 
 the reason for resolving the ticket, among other things, and I would 
 like this text to be added to the ticket when it is resolved and I can't 
 find a way to do this.

 I tried creating a custom scrip with a custom template of 
 ${Transaction-Content()} or something like that, but it didn't work.

 Any help appreciated.

 Thanks,
 Khusro
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 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: sa...@bestpractical.com


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


Re: [rt-users] Resolve ticket and include message body in ticket

2009-07-07 Thread Khusro Jaleel
Ken Crocker wrote:
 Khusro,
 
 The Notify AdminCcs as Comment won't send out an email. At least that 
 is my understanding. So, if I'm right, some other scrip is sending out 
 the email and therefore your new template is probably NOT being used. Of 

Thanks for the quick response, Ken. I have actually gone into the global 
settings and set 'Stage = Disabled' globally for the On Resolve script, 
and since we have other queues on this box, we know that usually on 
Resolve, nothing gets sent out.

However, I need to enable it on this one special queue, and I know that 
my template is actually working because I get the text:

Resolution Comment:
No Comment

I don't have any such text anywhere else in the system, only this queue. 
So I know the scrip and template are working, but just not seeing the 
response I typed in for some reason. The emails to the AdminCCs *are* 
being sent out, just with No comment in the body instead of my text.


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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] Resolve ticket and include message body in ticket

2009-07-07 Thread Ken Crocker

Khusro,

Must be your code. Can you send it?

Kenn
LBNL

On 7/7/2009 10:48 AM, Khusro Jaleel wrote:

Ken Crocker wrote:
  

Khusro,

The Notify AdminCcs as Comment won't send out an email. At least that 
is my understanding. So, if I'm right, some other scrip is sending out 
the email and therefore your new template is probably NOT being used. Of 



Thanks for the quick response, Ken. I have actually gone into the global 
settings and set 'Stage = Disabled' globally for the On Resolve script, 
and since we have other queues on this box, we know that usually on 
Resolve, nothing gets sent out.


However, I need to enable it on this one special queue, and I know that 
my template is actually working because I get the text:


Resolution Comment:
No Comment

I don't have any such text anywhere else in the system, only this queue. 
So I know the scrip and template are working, but just not seeing the 
response I typed in for some reason. The emails to the AdminCCs *are* 
being sent out, just with No comment in the body instead of my text.



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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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: sa...@bestpractical.com


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

Re: [rt-users] Resolve ticket and include message body in ticket

2009-07-07 Thread Khusro Jaleel
Ken Crocker wrote:
 Khusro,
 
 Must be your code. Can you send it?

It's just the following, in a new template:

===
According to our records, your request has been resolved. If you have 
any further questions, please respond to this message.
---
Resolution comment:
 {
  my $Resolution_Comment;
  my $Transactions;
  my $CommentObj;

  $Transactions = $Ticket-Transactions;
  $Transactions-Limit( FIELD = 'Type', VALUE = 'Comment' );
  $Transactions-OrderByCols(
  { FIELD = 'Created',  ORDER = 'DESC' },
  { FIELD = 'id', ORDER = 'DESC' },
  );

  $CommentObj = $Transactions-First;

  if  ($CommentObj  $CommentObj-id)
  {
   $Resolution_Comment = $CommentObj-Content;
  }
  else
  {
   $Resolution_Comment = No comment.
  }

  return $Resolution_Comment;
 }
---
===


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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] Resolve ticket and include message body in ticket

2009-07-07 Thread Khusro Jaleel
* Ken Crocker (kfcroc...@lbl.gov) wrote:
 Khusro,

 My mistake. I thought you had said you already had code similar to what  
 I sent you. What you just sent looks a lot like my code. At this point,  
 I have no idea why your not getting a comment as ours works quite well.  
 Unless, of course, we are missing the obvious, which is Is someone  
 actually entering a comment when they Resolve the ticket? Sorry I can't  
 help.

Many thanks for your help, Ken. I'll keep trying...
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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