Hi All, can any one give me a reason why there are no scripts belonging to _Approvals queue
Thanks and RegardsFrom: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: Daniel Garcia Mejia dgarcia@cesca.cat
Cc: “rt-users@lists.bestpractical.com” rt-users@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@cesca.cat
To: asanka_gunasekera@yahoo.co.uk
Cc: rt-users@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@cesca.cat
…
RT Training Sessions (http://bestpractical.com/services/training.html)
- Boston — March 5 & 6, 2012