search results

  PDF version   1. Prerequisites (SharePoint platform) 2. Prerequisites (no SharePoint platform) 3. High availability 4. WEBCON BPS databases 5. Disaster-recovery scenario (SharePoint platform) 6. Disaster-recovery scenario (no SharePoint platform) 7. Good practices in WEBCON BPS platform maintenance 8. WEBCON BPS Farm internat/external communication diagr

(...) ield other than the “Person or group” type, you must designate a column that contains a user login or group ID).   Fig. 4. The "Dynamic" option   SQL query – by entering the appropriate SQL query that will return user logins or group IDs (the login or ID should be in the first column returned by a query). In the presented example, the query (...)

Applies to version: 2021.1.x and above; author: Dawid Golonka The article is an update of the already existing article, it shows the configuration in version 2021.1.x. For the original see: Import-Export – Good process design.   Introduction WEBCON BPS has a mechanism that allows you to transfer process definitions between several independent environments. The DEV-TEST

(...) that point to a specific user or group.    Fig.1 Form for checking user's or group's privileges   For each example, we will show the user’s view and the SQL query that returns the appropriate data.  Choosing a user or a group Before any data is displayed, the user must select a person or group. Basic information about the user will be displayed next (...)

(...) According to the item list definition, it is the DET_ID column, it is also recommended to indicate such a column in this field. Data source – indicate a connection to the current database. SQL query – the query should contain the values that will be placed on the item list with indicating a column to which these values will be passed, in the form: Select ‘Value’ as [Column (...)

(...) For example – the ^Leave_request.* expression means to download a file whose name starts with “Leave_request”.   Fig. 4. Sample regular expression   SQL query – allows you to create a query that returns the ATT_ID of the attachment from which data is to be downloaded.   Fig. 5. Configuration of the SQL query returning the attachment (...)

(...) on the defined regular expression that filters names and extensions.   Fig. 4. Sample configuration of the second attachment selection mode in the Get Attachments rule   C) SQL query – the rule will return attachment’s IDs based on the defined SQL query . In the example, the rule will return the ID of attachments created by the currently logged in user.   (...)

(...) nates – Enter the latitude and longitude divided by a “#” sign. Address –  Enter the address of where you want the mark to be placed. Address (dynamic) – Use an SQL query , which will return an address, which will be marked on the map.   Fig. 1. An example of using coordinates   Fig. 2. An example of using an SQL query (Address - dynamic (...)

Applies to version: 2021.1.x and above; author: Adrian Baszak   WEBCON BPS applications frequently require integration with external systems. SAP is one of the popular systems that requires integration with WEBCON BPS workflows. Business scenarios Below you can find some examples of areas shared by Microsoft Dynamics system and WEBCON BPS. Cost invoice  Frequently SAP

(...) by a semicolon (;) For this purpose, the action of changing the field value (the semicolon is added to the ID of the line supervisor) and the Collection function (that returns the values from the SQL query separated by a semicolon) have been added.   Fig. 14. The rule selecting employees to display   The SQL query shown below selects the ID of the line employees:   (...)

Applies to version: 2022.1.x and above; author: Jacek Język From WEBCON BPS 2022.1.1, the lowest supported SQL Server is 2014. In the case of WEBCON BPS installations using the higher versions of SQL Server, WEBCON BPS databases work with the compatibility level set to SQL Server 2014 by default. Changing the compatibility level from SQL Server 2014 to SQL Server 2019 is possible, but

(...) n issues caused by changing the Compatibility Level of a WEBCON BPS database to higher than 120 Scalar function inline When switching Compatibility Level to SQL Server 2019 or newer (150+), the SQL query optimizer will start to activate scalar function “inlining” in each query to such a database. https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-u (...)

(...) ration of the send document action   Configuration of the subsequent action sections is presented below:   Figure 7. Attachment selection     Here, create SQL query to WFDataAttachmets table returning ID of the attachment sent for signature. In the respective case restrict searching to searching with the current instance ID, check if the file belongs to “T (...)

Author: Paweł Drab Introduction   Migration of databases to a different database environment or their recreation in such environment may require changing database name. If references to a database are present in several locations, external, logical change of database name is insufficient. The article describes the procedure of changing database name by modifying configuration.

(...) utton next to the text field “SQL/CAML query that returns color”.   Enabling colour mode and setting up preferred colour.     Enter the below conditional SQL query in the text field. In the presented example the item list row will be coloured in yellow if the value in the “Price” column exceeds the 1000 EUR threshold.   if (cast('{SFD (...)

Applies to version: 2022.1.3 and above; author: Maciej Kieblesz   Introduction This article describes a method of maintaining databases to ensure the highest possible performance of the SQL engine, and thus the BPS application itself. In practice, this will mean a reduction in the number of 'timeout' errors, for example, when loading a report. This mechanism is tailored to

(...) the drop-down list available in “Instances selection mode”, you can choose only the current instance to undergo archiving (“Archive only current workflow instance”) or use an SQL query to indicate the instances to be archived (“Select workflow instances using SQL”). The latter option requires inserting an SQL query in the “SQL query ” field. The options av (...)

Applies to version: 2022.1.x and above; author: Łukasz Maciaszkiewicz Introduction WEBCON BPS uses services to run special operations that generally do not require user interaction. Unlike Portal, which acts as a host for a website, the service can have multiple roles performing calculations and executing long operations defined previously by a user. This article describes the roles the

(...) Fig. 5. All attachments tab with collapsed branches of the folder tree   Additionally, in the Linked documents view configuration window, the user can define additional folders based on an SQL query . Fig. 6. below shows a sample SQL query based on which a folder with .xlsx files from all related workflows will be created.   Fig. 6. Sample SQL query defining a custom attachment fol (...)

(...) Global business rules The “AddAttachment_AtThisStep" rule This rule verifies whether an attachment is added on a particular step. The verification is executed by means of an SQL query that checks whether an attachment is added to an instance after defined time (date and time). A business rule with a conditional clause The rule is used to check an attachment is added on a (...)