Applies to version 2020.1.x, author: Marcin Pisarek
When designing processes and individual workflows in WEBCON BPS, it is good to know how data is stored in the tables, what are the relations between them and how the particular information is displayed on the form.
The article describes the WFElementDetails table.
Relations in the table
The WFElementDetails table contains all rows from the item list including user input and system data. Each row is uniquely identified by using the unique ID (DET_ID).
System data that are stored in the WFElementDetails table are e.g.:
- The date of inserting a row (DET_TSInsert)
- The date of updating a row (DET_TSUpdate)
- The instance version (DET_Version)
- The author (DET_CreatedBy)
- Modified by (DET_UpdatedBy)
Selected keys in the WFElementDetails table:
- DET_ID – a main key (row ID)
- DET_WFDID – an instance ID. The main key (WFD_ID) in the WFElements table
- DET_WFCONID – item list ID. The main key (WFCON_ID) in the WFConfigurations table
Fig. 1. The Item list – ID
Fig. 2. The Item list column – field in the table
Below, the selected types of form fields along with their equivalents in the WFElements table are described:
- Single line of text – AttText column, varchar(255) type
- Multiple lines of text – AttLong column, text type
Picker fields – Att column, varchar(1000)/nvarchar(1000) types
Numerical fields – Value column, decimal(21,6) type
For the purposes of this article, the instance described as part of the article on data storage in the WFElements table was used on the example of the “Car Management” workflow:
Fig. 3. The form
In the edit mode of the form rows in the “Report of service events” item list was filled out:
Fig. 4. The form – “Report of service events” item list
After following the “Make available” path to the next step in which the form is in read-only mode – data one the form is as follows:
Fig. 5. The form – filled out the “Report of service events” item list
The value displayed in the ID column is not saved in the database, it is used only to define the order of the rows. This column is displayed after selecting the “Show ID column” option in the item list form field configuration.
The above query returns all completed data from the “report of service events” item list.
Fig. 6. The SQL query
An example query that returns information about service visits along with information about given car – in the last 30 days.
Fig. 7. The SQL query – displaying all service visits in the last 30 days
The above example shows a possible way to receive both data from form fields and data from a list of items.