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….
Category: Designer Studio
JSON nested collection handling in WEBCON BPS
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…
REST Web Service Connections – WEBCON BPS Authentication
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…
Global business rules – ready-to-use examples
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 =…
Wait for sub-workflows step – advanced configuration
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…
A quick way to extract process form field column names
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….
Quick tip #3: Using hyperlink action on transition path
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…
Massive update of sub-workflows in WEBCON BPS
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…
Starting a large number of WEBCON BPS sub-workflows
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…
WEBCON Basics: SQL Server connection
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…