Applies to version 2020.1.x, author: Marcin Pisarek Introduction 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 table that stores header data […]
Tag: database
Attachments database
Applies to version: 2020.1.x and above; author: Dawid Golonka Introduction In the workflows designed in WEBCON BPS, you can enable users to add the attachments – e.g. .pdf, .docx, .xlsx, tiif and zip. Their storage location is a particularly important aspect of the system configuration. One of the methods to store the attachments is […]
WFHistoryElements and WFHistoryElementDetails tables description
Applies to version: 2020.1.x and above; author: Franciszek Sakławski Introduction 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. Table description […]
Calendars table description
Applies to version: 2020.1.x and above; author: Franciszek Sakławski Introduction 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. […]
WFMails table description
Applies to version: 2020.1.x and above; author: Dawid Golonka Introduction 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. The configuration of sending e-mails was described on the technical blog -> E-mails and templates […]
WFSecurities table description
Applies to version: 2020.1.x and above; author: Dawid Golonka Introduction 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 […]
WFActionExecutions table description
Applies to version 2020.1.x, author: Dawid Golonka Introduction Actions are commonly used in WEBCON BPS to design the processes and individual workflows. They are performed without any user interaction and defined on the transition paths or steps. An example actions perform such activities as calculating the field value, making an entry to AD, sending […]
Disaster recovery in WEBCON BPS
Applies to version 8.3 and higher; Author: Tomasz Mierzwa One of the phrases that any company employing an IT infrastructure should have written somewhere in their security policy is ‘Disaster Recovery’ – i.e. the ability to recover data in the event of a major data center failure. The WEBCON BPS system engine operates based on multiple […]
Improving MSSQL performance – the forgotten TEMPDB database
Applies to all versions; Author: Paweł Jawień The performance of WEBCON BPS is closely related to the performance of MS SQL on which the BPS database operates. Once we’ve overcome RAM shortages, optimized storage space for the process database, relieved overburdened processors and implemented a suitable database maintenance schedule, we may think that we’ve got […]
Implementation handbook – The dangers of deleting workflow instances
Applies to version 8.3.x; Author: Kamil Nędza Foreword Humans make mistakes. What is the correct response if someone accidentally creates an erroneous workflow element or duplicates an invoice? It is possible to delete workflow elements in WEBCON BPS from the form interface in SharePoint. The button to do so is always visible in administrator mode, and […]