[rt-users] setting up approvals on RT 4.0.1

[Asanka Gunasekera]

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
.......................................................................
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20111230/9dce5e75/attachment.htm>