search results

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

(...) flow graphic schema.   Fig. 10. The diagram before rescaling   Fig. 11. The diagram after changing the scale    A similar effect can be obtained in the sql queries /formulas window.   Fig. 12. The formula syntax before zooming   Fig. 13. The formula syntax after zooming   Directional arrows – when the rule i (...)

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.3; author: Konrad Wojtycza   Introduction In WEBCON BPS data stored e.g. in the external database can be retrieved and displayed by: Defining data connection and SQL query Creating a data source and using filters This article describes both approaches to use data in WEBCON BPS, differences between them, and problems of their configuration.

Applies to version 2021.1.1; author: Kinga Bożęcka WEBCON BPS 2021 introduces the mechanism of diagnostics and recording the behavior of the form and other elements of WEBCON BPS Portal. This mode is a successor to the old Debug mode which was used to track all modifications that impact the visual layer.  This functionality toggles a diag

(...) sion: 2021.1.x and above; author: Konrad Wojtycza Introduction The Run an SQL procedure action allows you to invoke SQL procedures from the WEBCON BPS form level, and to prepare the universal sql queries with variables. This functionality is limited only by the capabilities of the SQL query language. It is possible to invoke SQL procedures using data in the WEBCON BPS form and enter/update data in th (...)

Applies to version: 2021.1.x and above; author: Dawid Golonka The article is an update of the already existing article, it shows the configuration in version 2021.1.x. For the original see: Import-Export – Good process design.   Introduction WEBCON BPS has a mechanism that allows you to transfer process definitions between several independent environments. The DEV-TEST

Applies to version: 2021.1.x and above; author: Adrian Baszak Introduction This article presents a workflow for checking user’s and group’s privileges in one place. It can become useful when having many deployed applications and roles with different privileges. This workflow may be used as a part of a larger group management application based on WEBCON BPS.  In the workf

(...) umns from the table - passed as input parameters. “Inline” of such functions in WEBCON BPS databases does not improve query performance. However, because they are used in large numbers in sql queries generated, for example, by application reports, the size of such a query increases significantly during "inline", which leads to a deterioration in the performance of these queries, and eve (...)

(...) ple columns of the table passed as entry parameters. “Inlining” such functions in WEBCON BPS databases does not improve performance. On the contrary, due to them being used extensively by sql queries generated from e.g. application reports, “inlining” will increase the size of these queries to the point where the performance will drop – and in some cases, prevent them from being (...)

(...) ase Archive database content.GlobalParameters, parametr "ArchiveDefaultDB" content.ArchivingDatabases.ARD_Databases content.WFDefinitions.DEF_ArchivingDatabase   sql queries for checking database list   1 | -- CONFIG 2 | select CD_ID, CD_Name, CD_Type from ContentDatabases 3 | 4 | -- CONTENT 5 | select ARD_ID, ARD_Name from ArchivingDatabases 6 | (...)

Applies to version: 2022.1.x and above; author: Łukasz Maciaszkiewicz Introduction WEBCON BPS uses services to run special operations that generally do not require user interaction. Unlike Portal, which acts as a host for a website, the service can have multiple roles performing calculations and executing long operations defined previously by a user. This article describes the roles the

(...) s the standard account in the context of which SQL COMMAND rules and all queries using the Default connection are executed, e.g. when configuring selected form fields or actions, executing or testing sql queries with the use of <Current BPS database>.   If the system is upgraded to the latest version, all queries executed so far in the context of the dedicated Database read account will (...)

Applies to version: 2023 R1 and above; author: Łukasz Maciaszkiewicz   Introduction The logic behind the execution of tasks by service is a multi-faceted and complex issue. When planning tasks, application designers are often unaware of the mechanisms and rules used by the service. To fill this gap, this article describes the elements affecting the sequence in which the service exec

(...) rsquo;s name Remarks ASP .NET Core Instrumentation   SqlClient For Portal and Service it is possible to view sql queries . HttpClient   WCF Client Integration with Service * For traces WEBCON BPS supports data export by the OTL (...)

(...) hich said it could be followed if two tasks had been completed.   The Solution   It is quite possible to get the desired voting-style behavior from WEBCON BPS using one or two sql queries together with a Workflow Control step. Moreover, the sql queries can be encapsulated onto global business rules that can be reused repeatedly. At a high level, it looks like this:   (...)

(...) e “ID” serves as an identifier and “Name” represents the displayed name. The first part, “ID”, represents a unique value. It is the element most frequently used in sql queries designed to filter results displayed in picker fields populated with values from a specific data source. Such filtering is often employed to exclude irrelevant information, presenting only what is of (...)

(...) along with a business case for its use.   Basic definitions and functional assumptions LIKE and CONCAT are functions that can be used in WEBCON BPS to create business rules, form rules, sql queries , and to retrieve values from data sources. CONCAT combines text values into a single string and is available among the functions dedicated to text. With CONCAT you can retrieve global constants, p (...)

(...) ng infrastructure. The article does not cover limits that may affect the behavior of WEBCON BPS but originate from external infrastructure components (e.g., proxy servers).   Actions sql queries sql queries are the foundation of the vast majority of operations performed within the WEBCON BPS platform. In addition to non-modifiable system queries—such as retrieving the current user&r (...)

(...) ie). Starting with version 2019, this configuration method is no longer supported, and the following requirements now apply: Values in the ID and ParentID columns must be of the integer type. sql queries using the WITH clause are no longer supported, as they are blocked and may lead to errors in some environments. It is now possible to select intermediate nodes (e.g., teams), even when using path-b (...)