Please enable JavaScript to view this site.

 

 

 

 

Before you can activate the MPM eXecution module, you need to deploy the MPM eXecution Template App with your data: Deploy the MPM eXecution Template App.

 

This has to be changed:

 

 

 

ManualActivityList:

noconcatenate

load * inline [

   ManualActivityTypeValue

   Pricing Negotiations

   Quality Control Passed

   Quality Control Failed

   QC Goods Released

   Matching Invoice to Order

   Purchase Order Release Escalated

];

 

ManualActivityDummyTable:

load

   null() as ManualActivityDummy,

   null() as ManualActivityUserDummy,

   null() as ManualActivityCommentDummy,

   null() as ManualActivityRegDateDummy,

   null() as ManualActivityDeleteDummy

autogenerate 1;

 

 

 

 

ManualActivityMap:

Mapping load * inline [

 ActivityType                                                ,ActivityTypeID

   Pricing Negotiations                                ,501        

   Quality Control Passed                                ,502

   Quality Control Failed                                ,503

   QC Goods Released                                        ,504

   Matching Invoice to Order                        ,505

   Purchase Order Release Escalated        ,506

];

 

 

 

define your unique activitykey: CaseID & '_' & ActivityIdentifier & '_' & RegistrationTimestamp & '_' & ActivityType2 as ActivityKey,

And change this key also on the tab 1B. Load Delta EventLog

 

 

 

 

 

einkommentieren auf load event log

 

 

im EventLog:

//         'Choose an activity' as ManualActivityTypeDummy,                        //  LOGIC TO ADD MANUAL ACTIVITIES        

 

 

Im Skript danach:

 

 

//     //:::::::::::::::::::::::::::::::: LOGIC TO ADD MANUAL ACTIVITIES ::::::::::::::::::::::::::::::::::::::://

 

//     concatenate(EventLog)

//     load * ,ManualActivityUpdatedAt as old_ManualActivityUpdatedAt

//     resident ManualActivityLog

//     where ManualActivityDeleted <> 1 and not match(ActivityType,'Choose an activity');

 

//     drop table ManualActivityLog;

//           drop field ManualActivityUpdatedAt from EventLog;

© by MEHRWERK GmbH