Applies to version: 2021.1.x and above; author: Martyna Krzyżak WEBCON BPS applications frequently require integration with external systems. Microsoft Dynamics is one of the popular systems that requires integration with WEBCON BPS workflows. Business scenarios Below you can find some examples of areas shared by Microsoft Dynamics and WEBCON BPS. Cost invoice
Applies to version: 2021.1.x and above; author: Adrian Baszak WEBCON BPS applications frequently require integration with external systems. SAP is one of the popular systems that requires integration with WEBCON BPS workflows. Business scenarios Below you can find some examples of areas shared by Microsoft Dynamics system and WEBCON BPS. Cost invoice Frequently SAP
(...) default value will be inserted into the field whenever it is empty – it can be a rigid value or calculated with a business rule. Data source 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 Provi (...)
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: 2023 R1 and above; author: Łukasz Maciaszkiewicz Introduction With the introduction of the 2023 R1 version, the WEBCON BPS offers a simple and convenient functionality for assigning tasks to a group of users. The system uses it to dynamically react to personal changes within the group. The functionality addresses a number of issues which staff turnover poses to
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: 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
It would be great if there would be a "Usages" options for BPS groups like it exists for the most other objects like Rules, Fields, Action Template, Data sources and so on. I'm already using two workaround 1) I created a constant for each bps group so that I can use this constant wherever possible. Unfortunately there are some cases where this is not possible. For example in a "Person or group"
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
Hello, I have the following scenario: - Webconapps - Data Sources > Connections > MSSQL Database > Azure_SQL: I have server name, database, user and password filled. When I click Test, I get "OK" so Webcon can connect to the database. However, when I try to create a MSSQL database Data Source and chose the above connection, I get the following error: "Unknown error: The SELECT permission
Hello. Has anybody an idea if and how it is possible to create a data source from two different data connections? I.e. I have a database (MS SQL) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS SQL, too). Now I want to create a datasource for a Choice field, where I could query for names in both tables. It is purely for reading data. Kind regards
Hello, I' m new in webcon and i try to fix issue connected with attachments. I don't know much about attachments database but as i saw there are two places where i can find data : [BPS_Content].dbo.WFDataAttachmets and [BPS_Content_Att].dbo.WFAttachmentFiles When im trying to add attachment like always going step by step in my workflow everything is ok - attachment is being added in bot
(...) used the Aspose library which supports a template syntax. This allows to write code inside the word document to generate more sophisticated documents. Examples: - Instead of rendering item list/ data tables as tables in word we could generate "chapters" - Chapters could contain other chapters - Displaying multi line fields with rich text - Displaying pictures from attachments inside the document - (...)
Currently, if a company has several content databases, for example 5, and users need to be synchronized across each database, the data is stored in 5 tables * 5 databases, resulting in the same data being present in 25 tables. CacheOrganizationStructure CacheOrganizationStructureExtendedTokens CacheOrganizationStructureGroupRelations CacheOrganizationStructurePictures CacheOrganizationStruc
Hi, I have configured an On start (cyclical) action that is basically starting at 12:00AM and stops at 6:00AM, and is doing so every 2 minutes. What it does is to create an instance for the same process (parent process - where is also the global action configured). Parent process is running a loop on a data source that contains 10 entries and starts 10 other instances on a second process (chil