[rt-users] setting up approvals on RT 4.0.1

[Asanka Gunasekera]

Hi All, can any one give me a reason why there are no scripts belonging to _Approvals queue

Thanks and Regards



________________________________
 From: Asanka Gunasekera <asanka_gunasekera at yahoo.co.uk>
To: Daniel Garcia Mejia <dgarcia at cesca.cat> 
Cc: "rt-users at lists.bestpractical.com" <rt-users at lists.bestpractical.com> 
Sent: Friday, 30 December 2011, 9:35
Subject: Re: [rt-users] setting up approvals on RT 4.0.1
 

Hi Daniel, thanks for the reply

I am using Oracle as the database and under scrips I am unable to find any entry relating to the queue 2 (_approvals)

Thanks and Regards



________________________________
 From: Daniel Garcia Mejia <dgarcia at cesca.cat>
To: asanka_gunasekera at yahoo.co.uk 
Cc: rt-users at lists.bestpractical.com 
Sent: Thursday, 29 December 2011, 18:43
Subject: Re: [rt-users] setting up approvals on RT 4.0.1
 
Hi,

Scripts in '__Approval' queue are not visible, but you can't copy these scripts for another new approval queue that you create with MYSQL. Insert as 'root' user these following code:

insert into Scrips (Queue, Description, ScripCondition, ScripAction, ConditionRules, ActionRules, CustomIsApplicableCode,
CustomPrepareCode, CustomCommitCode, Stage, Template, Creator, Created, LastUpdatedBy, LastUpdated) select NEWQUEUENUM,
Description, ScripCondition, ScripAction, ConditionRules, ActionRules, CustomIsApplicableCode, CustomPrepareCode,
CustomCommitCode, Stage, Template, Creator, Created, LastUpdatedBy, LastUpdated from Scrips where Queue=2;

Where NEWQUEUENUM is the 'id' of the new Queue that you create.


Also, you can copy Templates
 of queue '__Approval'.

insert into Templates (Queue, Name, Description, Type, Language, TranslationOf, Content, LastUpdated, LastUpdatedBy, Creator,
Created) select NEWQUEUENUM, Name, Description, Type, Language, TranslationOf, Content, LastUpdated, LastUpdatedBy, Creator,
Created from Templates where Queue=2;


Where NEWQUEUENUM is the 'id' of the new Queue that you create.



With this, you can get a exact copy of '__Approval' queue.


Best regards,


Daniel



-- .......................................................................
        __
       / /       Daniel García Mejía
C E / S / C A   Portals i Repositoris
     /_/         Centre de Serveis Científics i Acadèmics de Catalunya

Gran Capità, 2-4 (Edifici Nexus) - 08034 Barcelona
T. (NULL) - F.  93 205 6979 - dgarcia at cesca.cat
.......................................................................




--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston — March 5 & 6, 2012
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120103/45d2d341/attachment.htm>