Deploy MPM Manual Activties |
Scroll Previous Topic Top Next Topic More |
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;