[rt-users] RTx-WorkflowBuilder Workflow issues

[Matt Wells]

I was able to walk back some of the errors but not all.  At one point
I was able to get tickets created with the only issue being the
'Finance approval' as they would never have permissions or the ability
to view the tickets.  Any guidance would be great.


*** RT_SiteConfig.pm
  Set( $WorkflowBuilderStages,
       { 'Manager approval' =>
         { content => '.....',

           owner => q!{{
    Fire                => 'matt.wells',
    Marketing           => 'user1'}->{
$Approving->FirstCustomFieldValue('TechReview') }}! },
         'Finance approval' =>


{ content => '... ',
           owner => 'user2',
         },
         'CEO approval' =>


{ content => '..........',
           owner => 'matt.wells',
         }});

  Set( $WorkflowBuilderRules,
  { 'PO-Approval' => [ 'Manager approval' => 'Finance approval' =>
'CEO approval'],
    'Vacation-Approval' => [ 'Manager approval' => 'CEO approval']
 }
);




[root at server1 lib]# pwd
/opt/rt4/local/plugins/RTx-WorkflowBuilder/lib
[root at server1 lib]# PERL5LIB=/opt/rt4/local/lib:/opt/rt4/lib:$PERL5LIB
../bin/rt-workflow Wells-CCB PO-Approval --create
[15133] [Thu Apr  9 17:02:49 2015] [warning]: DBD::mysql::st execute
failed: Unknown column 'main.Queue' in 'where clause' at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[15133] [Thu Apr  9 17:02:49 2015] [warning]:
RT::Handle=HASH(0x11c2088) couldn't execute the query 'SELECT main.*
FROM Scrips main  WHERE (main.Disabled = '0') AND (main.Queue = '6') '
at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x11c2088),
"SELECT main.* FROM Scrips main  WHERE (main.Disabled = '0') A"...)
called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 239
DBIx::SearchBuilder::_DoSearch(RT::Scrips=HASH(0x3b5bfc8)) called at
/opt/rt4/lib/RT/SearchBuilder.pm line 985
RT::SearchBuilder::_DoSearch(RT::Scrips=HASH(0x3b5bfc8)) called at
/usr/local/share/perl5/DBIx/SearchBuilder.pm line 507
DBIx::SearchBuilder::Next(RT::Scrips=HASH(0x3b5bfc8)) called at
/opt/rt4/lib/RT/Scrips.pm line 253
RT::Scrips::Next(RT::Scrips=HASH(0x3b5bfc8)) called at
../bin/rt-workflow line 121 (/usr/share/perl5/Carp.pm:169)