Database

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 WFElements table contains data about all instances (forms) in the system. They store both system data and form field values defined in the processes. Each workflow instance is identified by a unique ID (WFD_ID).

When designing processes and individual workflows in WEBCON BPS is it good to know how data is stored in the table, what relationships are and how particular information is displayed on the form. The following article describes the WFHistoryElements and WFHistoryElementDetails tables. The tables store data o the edition of the instances and changes of the values when going through the path. The WFHistoryElements table stores information about the instance and form fields value and the WFHistoryElementDetails table – information about values from the “Item list” form field.

WEBCON BPS can be extensively integrated with Microsoft SharePoint Online. This article describes how to start a workflow by using a standard SharePoint list with advanced column formatting.

In the presented scenario, the SharePoint list will be used to start the workflow of inviting people to the conference – after entering the name and surname, a marketing workflow will be started. The current status of the task can be checked in the SharePoint list column.

When designing the processes and individual workflows in WEBCON BPS, it is good to know how the data is stored in the tables, what are the relations between them and how individual information is displayed on the form. This article describes the Calendars table. The Calendars table allows you to operate the non-working and working days by defining them in WEBCON BPS Designer Studio. A properly configured calendar can bring many benefits. The chosen business example is only one of the many possibilities of using the table.

The processes designed in WEBCON BPS use the e-mail sending actions in their workflows – e.g. e-mails about active tasks waiting for the user or e-mails contain various reports. WEBCON BPS allows you to set a way of sending e-mails in which the outgoing notifications can be queued by the system and then, are sent according to the priority assigned to them. The queue can be stored in the WFMails table in the database. To enable the message queueing, go to the configuration of the “Send a custom e-mail” action and in the “Settings” tab select the “Add to sending queue” option.

Each of the individual stages of the business process requires the involvement of specific employees or groups. The degree of involvement can vary from person to person – from one action and access to some resources to participate in the entire process cycle and insight into each instance. WEBCON BPS allows you to map these conditions by using the privileges mechanism. The WEBCON BPS system operates based on a SQL database, one of the places where the information the privileges is stored is the WFSecurities table.