search results

for sql table

About Us
article

WEBCON: Business Process Automation and Management as its best WEBCON develops the Low-Code Business Process Automation Platform, WEBCON BPS (Business Process Suite). This enterprise-grade system allows organizations to embrace digital transformation by digitalizing their workflows and building comprehensive, scalable, process-centric and future-proof applications applying t

Applies to version: 2020.3.x and above; author: Franciszek Sakławski   Introduction When creating the configurable e-mail templates there is the option to add fields from the form. This article describes how to add an item list and SQL data table fields.   Fig. 1. A list of fields available in the system   To enter these types of fields in the template is n

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 WFElementDetails table.   Relations in the table The WFE

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 – WFElements.   Relatio

Applies to version 2020.1.x, author: Dawid Golonka   Introduction When creating support for business processes in WEBCON BPS, it is important to remember that even the simplest workflow with a minimum number of steps and form fields will be reflected in the database – all of its instances and settings are represented in the content database – which is the main place

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

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 in BPS. WE

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 insight into each instance. WEBCON

Applies to version 2019.1; author: Dawid Golonka   Introduction While working on WEBCON BPS Portal, you can see the error messages displayed by the system in the upper right corner – they are displayed when the system encounters a problem and the execution of any action fails. From version 2020.1.3.277 there is the ability of previewing error logs from the administration too

(...) d configuring process – so that these limits are not reached. All of the following limitations result directly from the WFElements (for form fields) and WFElementsDetails (for the item list) sql table structures.   Limit tables   Global form fields The limit of global form fields applies to the entire system configuration. Regardless of the number of processes, workflows a (...)

(...) not allow you to register an instance with the same number (e.g. 00000001). If you need to search instances in the database  - e.g. to display information from another instance in the “sql table” form field, you should use the instance ID (WFD_ID) instead of the instance number.

(...) to the form rules or JavaScript consisting of the available editor functions while maintaining the logic of the Modern form Switch data sources and SharePoint libraries to dictionary processes or sql tables Change SOAP WebService to REST WebService. It also applies to integration with WEBCON BPS - if SOAP was invoked, it should be changed to REST Changes in SDK All information about WE (...)

(...)   Fig.21 . Generated employee card in English - page 1.   Fig.22 . Generated employee card in English - page 2.   Values from checkbox, items list and sql table are translated correctly.   Summary By implementing the Webcon BPS software to support business processes in companies operating on the markets of several multilingual countries, it is (...)

(...) the use of other methods, e.g., in the form of Web service. Sometimes, it occurs that due to a large amount of data, resources, the dictionary data is delivered from the Microsoft Dynamics system via sql tables which are completed and updated cyclically (e.g. once per 24h, at night). Such solution has got its weaknesses – that being data introduced into Microsoft Dynamics is displayed with a del (...)

(...) hanges in the source system. Data can be also transferred with the use of other methods, e.g., in the form of Web service. The dictionary data is delivered from the SAP system via a web service or sql tables according to some predefined cycle (e.g. once per 24h, at night). This solution has some weaknesses, but sometimes the priority is to ease the load on system resources. In the case of a query f (...)

(...) ource Provide only for choice fields and data tables. Can contain descriptions of the values available for selection. If possible, give the name of the data source (other BPS workflow instances, sql table, web service) Data table Provide only for data tables. Give the list of columns to be displayed in the table. Indicate the column that should be displayed in the form of links. To sa (...)