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

search results

for SQL table

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: 2020.1.x and above; author: Piotr Dąbrowski Introduction   WEBCON BPS handles digital signatures through dedicated actions (SDK – Software Development Kit). There are 4 plugins available to integrate with external digital signature providers: AdobeSign Autenti DocuSign Skribble This article describes the process of signing document wit

Applies to version: 2022.1.3 and above; author: Maciej Kieblesz   Introduction This article describes a method of maintaining databases to ensure the highest possible performance of the SQL engine, and thus the BPS application itself. In practice, this will mean a reduction in the number of 'timeout' errors, for example, when loading a report. This mechanism is tailored to

Applies to version: 2022.1.3 and above; author: Konrad Wojtycza   Introduction Configuration of processes in WEBCON BPS indispensably involves the creation of rules, be it a business rule or a form rule. To optimize the work, it is a good idea to use the keyboard shortcuts available in WEBCON BPS and the keys provided by the operating system. This article describes how t

Applies to version: 2022.1.x and above; author: Łukasz Maciaszkiewicz   Introduction Increasing data volumes combined with shrinking disk space and decreased performance pose a challenge to every IT system. WEBCON BPS faces it with an extensive archiving mechanism that automatically removes data from process databases. The resulting better arrangement of disk space translates into e

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: 2021.1.x and above; author: Konrad Wojtycza   Introduction WEBCON BPS Designer Studio allows users to configure global business and form rules. As global rules, they are available for all applications created in a given environment and thanks to parameters they are universal and may be used in multiple processes.   Global business and form rules can be

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 2017.1.3.x; Author: Bartłomiej Spyrka SDK configuration for an ‘Administration process’ used to find and manage personal data This article presents methods of utilizing features available in WEBCON BPS to prepare a process for GDPR-related data management. In this article you will learn: How to approach the Administrative process which is used to tra

Applies to version: 2023 R1 and above; author: Łukasz Maciaszkiewicz   Introduction In the present-day dynamic and distributed application environments data monitoring and analysis are key to ensure high efficiency, reliability, and optimization of an application. To address those challenges, the 2023 R1 WEBCON BPS version has introduced support for OpenTelemetry – a powerful

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

Applies to version: 2023.1.x and above; author: Marcin Smarzewski   Deactivating Licenses on Test and Developer environments Before mirroring the environment, it is recommended to deactivate the test or development license service (depending on which environment will receive the production mirror), Doing so will make it possible to activate the license service without assistance. If

Hi all, i hope you are well. We have moved our PROD-Environments Databases to a different SQL Server last night. Except from some annoying trouble with Sharepoint and the Webcon solutions we managed to get everything running smoothly again. We uninstalled everything except from SOLR, and installed it again. The old databases are offline. Currently there is still an alias configured, that rout

We are implementing a solution of Master Data Management and are trying to use Webcon as a User interface with all the logic behind forms. The database is prepared in MS SQL with different tables. The challenge we are having is to update entries with foreing keys. Scenario: Table 1: Country has one column (apart from ID) – 'Country' Table 2: City has two columns 'Country ID' (Choice column from t

Dear all, what would be the best practice to update/change the Business Entity of an instance? Background: I would like to create an application containing people related to a company respective business entity. Over the time it is possible they would change the company and so also the business entity. I found a dirty way by using an SQL Update directly on the WFElements table, but I am struggl

Hi there, I have a data source of MSSQL type, that populates a data table. The SQL query is quite complicated but it works. However it currently takes about 33 seconds to complete. Thus when executed in SQL Studio, I get the output table. When I try to execute it in a bps process, it fails. When testing in Designer Studio, I get an error of execution timeout. Is there a way to tell Webcon to allo

Based on Daniel post https://daniels-notes.de/posts/2021/retrieve-ps-variable-value I figure, it is posible to retrive output value from SQL Procedure? How force "Run sql procedure" action to log ouptut to [dbo].[WFLogs] table? Write-Output in PowerShell is logged to LOG_Description column. How log ouput from sql procedure?

Hello, after playing around with the answers in the former thread I think it may be helpful for others to present my approach here. If anybody wants to reply to improve it, I will be grateful to learn. 1) Requirement Within a process a group of users is requested to deliver an approval by two different members from within the group. Also it shall be possible to change the process to two per