Activities

An Activity in Konekti is "something that happens to an object" (a lifecycle change), such as creation, modification, approval, or confirmation

An activity has four key inputs:

1. A name

   This is the reference label for the activity, used consistently throughout Konekti and in any connected downstream systems.

2. A source table

   The table supplying the data from which the activity is constructed. Each row—after any applied filters—must represent a single instance of the activity. It is possible to have multiple timestamps on a single row, leading to multiple activities.

3. The timestamp

   A column that indicates the time the activity took place. This can be a single column, or a combination.

4. Filters

   Conditions that narrow down the source table to include only the rows relevant to the specific activity being defined.

Activity Types

Activities can be stored in various types of tables. This section contains the main types, and the fastest way to add them to your event store.

tip

Follow the Tutorials for a detailed explanation of how to add each activity type.

1. Object Source

In this type, the activity is a column in the object table - where each row represents an object instance. To add them to the model, create the Object first. Open the Object, hover over the column in the preview that contains the activity timestamp, and click Add activity.

Example - Purchase Order Line Table

PO_ID	Line_ID	Product	Quantity	Price_usd	Created_date_time	Latest_GR_Date
001	001	Wire, black, 2.5m	100	100.00	01/11/2023 16:01:00	01/12/2023
001	002	Wire blue, 2.5m	825	825.00	01/11/2023 16:01:00	01/12/2023
001	003	Reel ABC	75	750.00	20/11/2023 12:14:00	01/12/2023
002	001	Wire, yellow, 10m	5000	5820.25	21/11/2023 11:18:23	01/02/2024

Activities:

• Create Purchase Order Line (Created_date_time)
• Latest Goods Receival Date on PO Line (Latest_GR_Date)

2. Workflow Log

In this type, each row describes an activity in a workflow. Use the Add activity button to easily add activities from the 'Workflow log' type. Next, use the filter to select lines of a unique type to add to an activity. If you want to add (almost) all acitivities at once, use the batch activity.

Example - Workflow Log of the Purchase Order Approval Flow

PO_ID	Step_ID	Step_text	Date_time	User_Id
001	001	Start approval flow	05/11/2023 17:05:05	XXX-912
001	002	Find approver	05/11/2023 17:05:05	XXX-912
001	003	Approve PO	06/11/2023 09:01:00	LOVU
001	002	Find approver	06/11/2023 17:05:06	XXX-912

3. Change Log

In this type, each row explains a field change in the object table. Use the Add activity button to easily add activities from the 'Changelog' type. Next, use the filter to select lines of a unique type to add to an activity. If you want to add (almost) all acitivities at once, use the batch activity.

Example - Changelog of Purchase Order Line Table

PO_ID	Line_ID	Field	Old_value	New_value	Change_date_time
001	001	Business_unit	Lockman	Upton	01/11/2023 17:03:45
001	001	Amount_usd	120.00	100.00	01/11/2023 17:03:45
003	001	Business_unit	West Amanda	Upton	05/11/2023 12:08:00
003	002	Business_unit	West Amanda	Upton	05/11/2023 12:08:00

Activities (distinguished by filtering the Field column):

• Change PO Line Business Unit
• Change PO Line Amount