[rt-users] setting up approvals on RT 4.0.1

Daniel Garcia Mejia dgarcia at cesca.cat
Thu Dec 29 08:13:50 EST 2011


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
.......................................................................




More information about the rt-users mailing list