<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Hi Daniel, thanks for the reply</span></div><div><br><span></span></div><div><span>I am using Oracle as the database and under scrips I am unable to find any entry relating to the queue 2 (_approvals)</span></div><div><br><span></span></div><div><span>Thanks and Regards<br></span></div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Daniel Garcia Mejia <dgarcia@cesca.cat><br> <b><span style="font-weight: bold;">To:</span></b> asanka_gunasekera@yahoo.co.uk <br><b><span style="font-weight: bold;">Cc:</span></b> rt-users@lists.bestpractical.com <br> <b><span style="font-weight:
bold;">Sent:</span></b> Thursday, 29 December 2011, 18:43<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [rt-users] setting up approvals on RT 4.0.1<br> </font> <br>Hi,<br><br>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:<br><br>insert into Scrips (Queue, Description, ScripCondition, ScripAction, ConditionRules, ActionRules, CustomIsApplicableCode,<br>CustomPrepareCode, CustomCommitCode, Stage, Template, Creator, Created, LastUpdatedBy, LastUpdated) select NEWQUEUENUM,<br>Description, ScripCondition, ScripAction, ConditionRules, ActionRules, CustomIsApplicableCode, CustomPrepareCode,<br>CustomCommitCode, Stage, Template, Creator, Created, LastUpdatedBy, LastUpdated from Scrips where Queue=2;<br><br>Where NEWQUEUENUM is the 'id' of the new Queue that you create.<br><br><br>Also, you can copy Templates
of queue '__Approval'.<br><br>insert into Templates (Queue, Name, Description, Type, Language, TranslationOf, Content, LastUpdated, LastUpdatedBy, Creator,<br>Created) select NEWQUEUENUM, Name, Description, Type, Language, TranslationOf, Content, LastUpdated, LastUpdatedBy, Creator,<br>Created from Templates where Queue=2;<br><br><br>Where NEWQUEUENUM is the 'id' of the new Queue that you create.<br><br><br><br>With this, you can get a exact copy of '__Approval' queue.<br><br><br>Best regards,<br><br><br>Daniel<br><br><br><br>-- .......................................................................<br> __<br> / / Daniel García Mejía<br> C E / S / C A Portals i Repositoris<br> /_/ Centre de Serveis Científics i Acadèmics de Catalunya<br><br> Gran Capità, 2-4 (Edifici Nexus) - 08034 Barcelona<br> T. (NULL) - F. 93 205 6979 - <a
ymailto="mailto:dgarcia@cesca.cat" href="mailto:dgarcia@cesca.cat">dgarcia@cesca.cat</a><br>.......................................................................<br><br><br><br> </div> </div> </div></body></html>