Blog about WEBCON and beyond
How to use the OPENJSON tabular function to handle a data import to WEBCON BPS with REST nested data collections. The problem – nested data collections In the previous post I described the possibility of integration with WEBCON REST API data connection using WEBCON BPS authentication. While retrieving data, I encountered a problem where the…
How to configure and use REST Web Service connections using WEBCON BPS Authentication. Examples of using WEBCON BPS REST Web Service. This article was written based on 2021.1.1.56 Express version. Behavior may be different in other versions. Before we start Before we will configure a REST Web Service connection, it will be necessary to create…
How to upgrade standalone version of WEBCON BPS 2020 to 2021. The article describes the Express edition, however the same should be done for Standard and Enterprise editions. Before Installation During installation always something can go wrong. Before upgrade make sure that: You have valid license for version of WEBCON BPS you are updating to. You…
Several ready-to-use examples of global business rules that you can create once and use in everyday work with WEBCON BPS when creating and developing business processes. Count attachments The rule returns number of attachments of given category (all category if ‘ALL’ parameter is passed). SELECT Count(1) FROM wfdataattachmets WHERE att_wfdid = {WFD_ID} AND att_isdeleted =…
Advanced configuration of the wait for sub-workflows step using SQL query. Advanced subworkflows settings. The wait for sub-workflows steps allows for easy and quick configuration of processes in which we deal with dependent sub-workflows. Thanks to this, we can quickly determine how the main workflow should behave depending on the behavior of sub-workflows. However, in…
How to save attachments from the WEBCON BPS form to a hard drive or network share. This post was inspired by an article found on the web “Export Documents saved as Blob / Binary from SQL Server“. The article shows how to use the T-SQL language to save a file stored in the database on…
Using the standard hyperlink action on the transition path in WEBCON BPS 2020. Instant transition to a sub-workflow using the hyperlink action. So it is possible? Most of the examples on the web show the usage of the WEBCON BPS hyperlink action as a menu button. However not everyone knows that this action can be…
How to massively update multiple WEBCON BPS workflow instances. How to cancel all active WEBCON BPS sub-workflows? Every complex process has a sub-workflows Today’s post follows my post “Moving workflow elements en masse” from 5 years ago on the massive cancellation of all sub-workflows. Today I would like to present the simplest possible way of…
Configuration of connections in WEBCON BPS. Connection to the SQL Server database. WEBCON BPS allows integration with many different external systems. One of the most common needs among WEBCON BPS administrator users is the configuration of the connection and data sources for the Microsoft SQL Server database. In this post you will learn how to…
Configure WEBCON BPSAuth Service for WEBCON BPS 2020 Standalone installation. Add external users. How to add google authentication provider. BPSAuth for Standalone installation Since version 2017, WEBCON allows the use of external authentication providers. At WEBCON technical blog you may find an article how to configure BPSAuth Service for WEBCON installation for SharePoint installation. However,…