search results

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

(...) Applies to version: 2021.1.x and above; author: Wojciech Mleczko Information about instances registered in WEBCON BPS is stored in the MS SQL database, and in Apache Solr indexes (allows for a quick search). While the system is running, activities such as registering a new instance, following a path, or saving an instance generate entries in the queue of elements to be saved in Solr. The WebCon W (...)

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

(...)   Fig.21 . Generated employee card in English - page 1.   Fig.22 . Generated employee card in English - page 2.   Values from checkbox, items list and SQL table are translated correctly.   Summary By implementing the Webcon BPS software to support business processes in companies operating on the markets of several multilingual countries, (...)

(...) 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 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…). However, please note that when updating the WEBCON BPS platform (...)

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