(...) 50 Choice field 90 in total Survey fields - Choice list Date and time 50 Yes/No choice 20 Person or Group 15 SQL row No limit SQL grid No limit Google map 3 Gant chart 2 Absence chart 1 Vacation summary 1 Custom cont (...)
(...) 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 (...)
(...) o the euro currency. The method of handling the return of currency exchange rates for weekend days was also presented. Using the tools built into the WEBCON BPS system, as well as the benefits of the SQL language, we can freely configure the data sources used in workflows.
(...) The preview window can be closed with the cross in the upper right corner or by clicking outside the screen. Other files such as .PDF, .WORD, .XLSX, .XLS, .ODS, .TXT, .SQL , .MP4 video files, and e-mails - the attachment preview window is different from the previous one. Similarly, you can smoothly move between attachments using dedicated buttons. &nb (...)
(...) thanks to which the created solutions will be more understandable, less sensitive to change and, consequently, more reliable. Use of Tags Tags are elements used to create expressions (SQL , CAML, JavaScript) as well as Business Rules and Form Rules. The tag represents a specific value of a specific object in the system, e.g. the value of an attribute. Tags in the case of SQL and CAM (...)
(...) 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 displaye (...)
(...) ser ID PLN_From <Int32> - Date od (in YYYYMMDD format, e.g. 20200123) PLN_To <Int32> - Data do (in YYYYMMDD format, e.g. 20200125) PLN_WFDID <Int32> - Absence plan ID The SQL query contains data from the WFElements table (such as employee's id) connected by JOIN with the WFElementDetails table with values from item lists. The DET_WFCONID constraint allows you to selec (...)
(...) 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 (...)