search results

(...) 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.   GET ATTACHMENTS - returns identifiers of attachments related to the current instance, it can be a component rule for other rules operating on attachments. ATTACHMENTS COUNT - (...)

(...) 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 - d (...)

(...) omponent is an exception. Assumptions The existing WEBCON BPS environment consists of the following servers: application server working as BPS Portal, BPS Service, BPS Search Server SQL Server dedicated to WEBCON BPS applications - to ensure high availability, the instance should support this functionality. The configuration of HA for SQL Server is not be presented in this article. (...)

(...) Center tab. After clicking the link, the file will be downloaded.    Fig. 2. Translation Tool    Translation Tool should be used from a machine on which a Microsoft SQL Management Server instance is available and a database connection is configured with information about the process that you want to translate. Launch the “WEBCON.BPS.TranslationImportExport&rdq (...)

(...) The maximum time for completing the scenario by a single user has been established at 3.5 minutes.   Configuration equipment tested Configuration 1 (WEB single server + dedicated SQL server + dedicated search server) Description vCPU RAM Azure VM class Max. number of concurrent users - Scenario 1 Max. number of concurrent users - Scenario 2 (...)

(...) on and transfer to Microsoft Dynamics. Downloading data from Microsoft Dynamics Dictionary data from Microsoft Dynamics, e.g., dictionary of Customers is usually introduced into the workflow as SQL views originated from the Microsoft Dynamics database. Such solution allows for constant updating, regular refreshing the workflow dictionary data after changes made in Microsoft Dynamics. Data ca (...)

(...) on the data collection and transfer between the systems.   Downloading data from SAP  Dictionary data from SAP, e.g., dictionary of Customers can be introduced into the workflow as SQL views. Such solution allows for constant updating, regular refreshing the workflow dictionary data after changes in the source system. Data can be also transferred with the use of other methods, e (...)

(...) ource Provide only for choice fields and data tables. Can contain descriptions of the values available for selection. If possible, give the name of the data source (other BPS workflow instances, SQL table, web service) Data table Provide only for data tables. Give the list of columns to be displayed in the table. Indicate the column that should be displayed in the form of links. (...)

(...) ash; if something went wrong when executing a large stack of actions, rolling back the effects inside the WEBCON BPS system was never a problem, since everything related to the system is found in the SQL database on which the system is installed. Problems started when actions in a transaction affected external systems, rolling back those changes required creative solutions. In each automation, ther (...)

(...) 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: &nb (...)

(...) ations and requirements taking into account various integration types. Requirements towards the Customer/Integrator 1. Views WEBCON expects delivery of a view/table (dictionaries based on SQL procedure are not enhanced). The view/table should be responsive (the request “Select top 1000 * from table_name” should provide results within less than a second) The account deliver (...)

(...) ding or saving) can be transferred to an action, operation, or automation.  Data source – the ability to select all sources or connections currently associated with the application (only SQL and Oracle connections). After clicking the edit button, it is possible to define a filter that narrows down the given source. Attachment – after clicking the edit button, it is possible to d (...)

(...) Starting with WEBCON BPS 2022.1.1, the lowest supported MS SQL Server version is 2014. Due to this, when installing/updating WEBCON BPS, the Compatibility Level for databases is set to 120 – which corresponds to SQL Server 2014. This setting is also used when installing WEBCON BPS with newer versions of SQL Server (2016, 2019…). When installing BPS databases on SQL server higher t (...)

(...) 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 &l (...)

(...)   Applies to version: 2021.x.x.xxx and above; author: Mateusz Syrek Introduction This article describes 3 variants for transferring WEBCON BPS databases to a different SQL server: new server has the same name as the old one, new server has a different name – applying SQL aliases, new server has a different name – no SQL aliases applied, changing configuration. (...)

(...) ation where database name (except ID and acronym) appears, changing service configuration, changing portal configuration, changing queries in: data sources, actions, business rules (SQL COMMAND), in locations where it is not possible to choose the <current database> option or where the query contains direct reference to the database.   If the problem applies to (...)

(...) dquo; tab.     Check the “Use advanced appearance settings” field. Leave the colour mode field with “For whole row” value. It is now possible to type in the SQL code in the text field “SQL /CAML query that returns color”, but in the discussed case we will use the expression editor that facilitates edition. Click the ellipsis button next to the tex (...)

(...) navigating with the up/down arrows and confirming the selection with the Enter key.   Fig. 2. The dialog box list after inserting a few characters   Some information in the SQL database is stored as ID#Name. This format is used for some complex items, such as choice fields, person fields, form types. If the field you have selected is stored in that format, you can choose wh (...)

(...) tab. The calculated column in the present case will be the time unit – year. After selecting the Add calculated column button, a window will appear in which you should enter the appropriate SQL formula that returns the values of the years.     WFD_AttDateTime1 is the name of the field automatically defined when the Date and time form field is added in the application (...)

(...) 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 opti (...)