Blog about WEBCON and beyond
A video tutorial on how to set up a WEBON BPS home laboratory from scratch using the free version of WEBCON BPS Express. YouTube video course Long story short: when I was preparing an WEBCON environment for testing purpose I recorded my work. Unfortunately video is in polish language but I added the English subtitles….
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…
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…
How to quickly export column names for a given process in WEBCON BPS 2020. WFElement table’s column names of the WEBCON BPS process. At work, I often encountered the need to provide information to other people in the team, in which columns of the WFElements table there are particular forms fields of a given process….
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…
How to run large number of sub-workflows? Start subworkflow (SQL) action configuration. How to run thousands of instances of WEBCON BPS workflow? Problem: large number of sub-workflows Using WEBCON BPS, you may need to register thousands of sub-workflows simultaneously. Unfortunately, start such a number of workflow instances without encountering errors is impossible. Below you will…
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…