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 <[email protected]>
To: [email protected]
Cc: [email protected]
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 - [email protected]
.......................................................................
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012
