This article will describe the configuration needs to be done in DB tables for event Initial Visit as soon as we create new workflow in DSW .
As soon as we create the workflow we need to copy the id of workflow eg the code of KCSkoda_WalkIn_V3.1 is xx0AQWTFUUeLtD7ysu9iRw.
- We navigate to DB KCSNLPROD1 and the table [@IDMS_EVNTTYPEREPORT]
- We need to create a new record with the next data for each column
Code | Name | U_IDMS_Event Type Code | U_IDMS_Workflow Code | U_IDMS_State Attribute Code | U_IDMS_State Attribute Code Op | U_IDMS_Transition Attribute Code | U_IDMS_Transition Attribute Code Op | U_IDMS_Inquiry Source Code | U_IDMS_Inquiry Source Code Op |
Put a new GUID | Put a new GUID | CurrentWeekSpontaneousCustomers1 | new workflow code | 8D5A0747BBBEF14 | in | EMPTY | EMPTY | AuthorizedDealer | in |
- We navigate to the table @IDMS_WF_WORKFLOW and we search with the code of the workflow . When we find the record we update the column U_IDMS_WorkflowTemplateName with the value of the code.
Code | Name | U_IDMS_Ext Function Code | U_IDMS_Use First Free Time Slot | U_IDMS_Workflow Type Code | U_IDMS_Workflow Template Name |
xx0AQWTFUUeLtD7ysu9iRw | KCSkoda_WalkIn_V3.1 | 1 | SalesType | new workflow code |
- As soon as we finish the store procedure should be excecuted so to get the new records of Initial Visit for the new workflow
Add Comment