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

search results

for queries SQL queries

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: 2022.1.x and above; author: Jacek Język From WEBCON BPS 2022.1.1, the lowest supported SQL Server is 2014. In the case of WEBCON BPS installations using the higher versions of SQL Server, WEBCON BPS databases work with the compatibility level set to SQL Server 2014 by default. Changing the compatibility level from SQL Server 2014 to SQL Server 2019 is possible, but

Starting with WEBCON BPS 2022.1.1, the lowest supported MS SQL Server version is 2014. Due to this, when installing/updating WEBCON BPS, the Compatibility Level for databases is set to 120 – which corresponds to SQL Server 2014. This setting is also used when installing WEBCON BPS with newer versions of SQL Server (2016, 2019…). When installing BPS databases on SQL server highe

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

Applies to version: 2022.3.x and above; authors: Jacek Język, Krystyna Gawryał   Introduction WEBCON BPS version 2022 R3 comes with a dedicated database read account. During each new installation, a database account named bps_user is automatically created in all Content databases, which is used by BPS to read data from the database. In contrast, when upgrading the system that

Applies to version: 2021 R1 and above; author: Mike Fitzmaurice   Introduction WEBCON BPS offers several ways to handle parallel work. If the scenario involves a single task assigned to multiple people, a few task configuration settings are usually all that is needed. There are exceptions to this, though, especially when you have elaborate criteria to apply to the task results. &

Applies to version: 2023 R1 and above; author: Łukasz Maciaszkiewicz   Introduction Efficient database searching often plays a crucial role in determining the effective operation of the system, as well as the applications created within it. The problem becomes especially evident over time. Growing databases, when managed incorrectly, can considerably slow down system operation and n