WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for sql table

Hi! I have a process which generates subprocess (list is from sql query). The subprocesses generates correctly but there is one thing that I need to change - the author of the subprocess document should be change for the employee from field. I tried to change the login by update the WFD_CreatedBy column in WFElements table but it's not possible. I've received an error: "One or more errors o

Applies to version: 2020.3.x and above; author: Józef Cyran   Introduction The item list is frequently used to store any number of data rows as opposed to other form fields. This functionality makes the actions executed on the item list differ from the standard form field configuration.   Business case: Personnel planning for a project This article describes the

Applies to version: 2020.3.x and above; author: Agnieszka Burda   Introduction The following article is an extension of the Lunchtime article – see Lunchtime application The “Lunchtime” application has been enhanced with dictionary processes that allow you to pay for meals with money previously paid into your personal account. [LT Account] – a d

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.3.x and above; author: Józef Cyran   The idea of the application For this article we will implement a simple system for dividing up tasks between a group of users, based on the following principles: The task will go to the user with the least amount of tasks If multiple users are tied for the fewest number of tasks, one of them is randomly a

Applies to version: 2020.3.x and above; author: Konrad Wojtycza   Introduction Nesting business rules in the form rules allow you to refer to data contained in Active Directory or external data sources. This extends the functionality of form rules and allows you to use data outside the form when defining the process logic.   Execution of a form rule for a specific group

Applies to version: 2020.1.x and above; author: Dawid Golonka   Introduction Some processes in WEBCON BPS require data from some other source to operate correctly. This data can be provided from external data sources such as SQL databases or SharePoint lists. Internal sources can also be created in the system such as Fixed value lists or references to data contained in WEBCON BPS

Applies to version: 2020.1.x and above; author: Franciszek Sakławski   Introduction In WEBCON BPS version 2020, the support for digital signatures has been enhanced by preparing plugins (SDK – Software development kit) that enable digital signing of documents. Four plugins have been prepared that allow for integration with external digital signature providers: Adobe

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 You can automate your existing company's processes using workflow class systems. WEBCON BPS Portal gives you many tools for handling digital process automation. One of them is generating certificates for employees who successfully ended a given training course. This art

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: Grzegorz Szlachta   Introduction WEBCON BPS allows you to generate the Word files that can include data entered on the form. This functionality is useful in various processes such as contracts, vacations, and orders, where it is necessary to submit the document for signature. The following article describes the method of WEBCON BPS

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.   Table descr

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

(...) 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 (...)

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 an e-mail. While wor

Applies to version: 2020.1.x and above; author: Dawid Golonka     Introduction In WEBCON BPS you can create simple workflows consisting of several steps and form fields, but you can also use the subworkflows mechanism. The following article describes the action connected to subworkflows – “Update related workflow instance”. This action allows you to cha

Applies to version 2019.1.4.x; Author: Paweł Drab   WEBCON BPS Designer Studio can be launched from a local machine but in order to connect smoothly to both Portal and the database, it requires an environment configuration.   Depending on the chosen type of WEBCON BPS installation: with SharePoint, StandAlone   and following methods of authentication:

 PDF version   1. Prerequisites (SharePoint platform)   1.1.Software   Windows Server 2012 R2, Windows Server 2016, Windows Server 2019 Microsoft SharePoint Foundation 2013 or Microsoft SharePoint Server 2013/2016/2019 MS SQL Server 2012 or higher (full text search mode required) Active Directory (or Azure Active Directory) environment 1.2

Applies to version 2019.1; author: Konrad Wojtycza   Introduction The article describes the use of “Change value single field” and “Change values of multiple fields” actions on the example of the business scenario of the settlement of business trips. These actions allow you to update the value of the single form field or many form fields at the same tim