WEBCON BPS local groups management using simple process. Adding and removal of multiple group users by group owner at once. WEBCON BPS local groups In the WEBCON BPS Standalone installation, in which there is no SharePoint, and thus no SharePoint user groups, using WEBCON BPS local groups has become a key functionality. On the WEBCON…
Using the FOR EACH ROW form rule in practice
The article describes how to use the FOR EACH ROW form rule in practice on the WEBCON BPS 2021 platform. E.g how mark all rows of item list. What is FOR EACH form rule? From the version 2021 of WEBCON BPS it is possible to use the form rule named FOR EACH ROW. Previously, to…
Create your own WEBCON BPS Express laboratory from scratch.
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….
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…
Upgrade WEBCON BPS Express from 2020 to 2021
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…
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…
Attachments export from the WEBCON BPS database
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…
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….