Rules, JS, SQL

Form rules for attachments in WEBCON BPS allow you to receive information about attachments added to the workflow instances, without the need to know the WFDataAttachments table structure and to use SQL queries. Form rules operating on attachments increase the wide range of form rules available for use in WEBCON BPS and allow for easier retrieval of information about attachments from the form level, without the need to know the WFDataAttachmets table, which stores information about attachments. Rules will be presented using the “Change value of single field” action which has been configured for each rule separately.

WEBCON BPS 2021 introduces the new SELECT VALUES function that allows you to retrieve data from a selected item list column. This function enables saving data from all rows of a given column in a form field indicated in the configuration. Data are saved as a collection separated by semicolons. The function ignores empty values. In this article, we will copy values from the item list to the “Approvers to notify” form field. In this field, we select people who will receive a notification about an instance to be approved.

In the 2021 WEBCON BPS version, business rules were added that make it easier to work with item lists and allow you to color and dynamic style modification of the selected cells. The coloring of the item lists is shown on the example of a process for handling orders in a restaurant. The process has two form fields – Total number of orders and Orders – delivered, and one item list – Orders (that contains all orders). For each order, the Status field is set that informs the employee about the current status of the order.

In WEBCON BPS 2021, the form rules have been enhanced with new functions operating on text such as: CONCAT - combines two or more text strings into one text, SPLIT - splits the provided text into parts, according to a specified separator. The function returns strings separated by the semicolons ‘;’ (default separator). If no separator is found in the provided text, the function will result in one line of text, and INDEX OF – searches the provided text and returns the position where the specified string first occurs. Searching will start from the indicated position; the position of the first character is 1.
This article presents the configuration and operation of the above-mentioned functions on the form created for this purpose.

Nesting business rules in the form rules allow you to refer to data contained in Active Directory or external data sources. This extends the functionality of form rules and allows you to use data outside the form when defining the process logic. By using the business rules, you can create a condition that defines a certain group of users for which the form rule should be executed. By using the function in the “Users” section, you can enter a list of users or groups from Active Directory or defined BPS groups.