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…
Tag: SQL
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….
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…
Multilanguage app – one WORD template
In this post, I will show how to make a single simple WORD template for a multilanguage application. Thanks to this you will be able to save a lot of time when creating and maintaining templates. Multilingualism in BPS: A step forward WEBCON BPS has recently implemented many functions and mechanisms related to the usage…
How configure form field with advanced SQL query
Problem with advenced queries WEBCON BPS Designer Studio always had problem with testing and resolving advanced SQL queries, which may be a bit frustrating when there is a need to use form fields like Data table or Data row. On query testing or form field configuration given query is encapsulated and runned on choosed data…