<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Hi All, can any one give me a reason why there are no scripts belonging to _Approvals queue</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> Asanka Gunasekera <asanka_gunasekera@yahoo.co.uk><br> <b><span style="font-weight: bold;">To:</span></b> Daniel Garcia Mejia <dgarcia@cesca.cat> <br><b><span style="font-weight: bold;">Cc:</span></b> "rt-users@lists.bestpractical.com" <rt-users@lists.bestpractical.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, 30 December
2011, 9:35<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [rt-users] setting up approvals on RT 4.0.1<br> </font> <br><div id="yiv853260107"><div><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
rel="nofollow" ymailto="mailto:dgarcia@cesca.cat" target="_blank" href="mailto:dgarcia@cesca.cat">dgarcia@cesca.cat</a><br>.......................................................................<br><br><br><br> </div> </div> </div></div></div><br>--------<br>RT Training Sessions (<a href="http://bestpractical.com/services/training.html" target="_blank">http://bestpractical.com/services/training.html</a>)<br>* Boston — March 5 & 6, 2012<br><br> </div> </div> </div></body></html>