(...) ata is to be downloaded. Fig. 5. Configuration of the SQL query returning the attachment Mapping tab – in this section a user assigns sheet cells (Excel address column ) to the corresponding form fields (Form field column ). The cell address must be configured according to the SheetName!CellAddress rule – e.g. Sheet1!A1. A dynamic selection of cells and sheets (...)
(...) has a source configured to support multilingualism: Fig.8 . Translation of values in the "Fixed values list" data source. The permission’s item list column s have also been translated, as well as the column headings of the "Assigned Equipment" data table. Configuration of document templates in different languages Two templates f (...)
(...) result it is possible to switch between Pop-up and Autocomplete behavior modes freely. In the field configuration, you can define what information is visible about each selectable value, and by which column s the data source can be searched. column s returned by the specified data source can be added and rearranged in the Source column section of the configuration table. (...)
(...) oved?" is a workflow control step. It returns workflow instances to the approval step until all required persons have approved the invoice. The invoice approvers visible in the Approver (Fig. 9) column are assigned to individual accounts of the analytical breakdown. Fig. 10 Configuration of the "Accounting" workflow Workflow control configuration on the " (...)
(...) nbsp;Dashboards – system dashboards 4. DashboardWidgets – widgets on the dashboard 5. Reports – application reports 6. Reportcolumn s – the report column s 7. BpsChartViewConfiguration – report views 8. Processes – processes 9. WorkFlows – workflows 1 (...)
(...) source, most often in a table of an appropriate form (Fig. 1) Defining additional settings in the advanced configuration window The basic table for the Chart form field must have at least one column that acts as a numeric data series. Fig. 1. “E-commerce revenue Poland” data source The advanced configuration Data - the table displays all the col (...)
(...) hat can be included in the dictionary of Customers and their bank account numbers (the values from these dictionaries will be narrowed down). Dictionary of Customers column Type of data Comments ID int column with unique values Name string (...)
(...) on configuration in WEBCON BPS Designer Studio Input data Output data Example of the data in SQL view with procurement status column Type of data Comments ID int column with unique values Procurement ID string (...)
(...) st, choice field with a search option (a.k.a. Search window), and autocomplete. This article discusses the operating mode of the choice field type, types of choice fields in item lists (a.k.a. choice column s), the person type or group field type as well as the differences between the form fields presented above. Tab.1 Comparison table with choice field types Mode (...)
(...) vailable 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 column s to be displayed in the table. Indicate the column that should be displayed in the form of links. To save space on the form, you can divide the table into pages by specifying how many rows are to be (...)
(...) (and in the case of the described application, all types of activities displayed on the Gantt chart). Fig. 6. A query returning absebce types The names of the returned column s are as in the query above: VACType_ID --> ID of the absence/activity (must be unique) *required VACType_ColorID --> specifies the color of the bar on the Gantt chart *required VACTyp (...)
(...) e indexed ID MS SQL, Oracle technologies as standard The views delivered by the customer should be outside the contents of WEBCON BPS databases. 2. Examples of views View of Customers column : ERP_ID - unique ID applied to the entire data set, required NAME - required NIP [TAX IDENTIFICATION NUMBER] - required COUNTRY - optional, two-digit country code CITY - optional AD (...)
(...) of fields on the form. They allow you to configure the form in terms of dynamic setting required fields to be completed. Business case The ability to set the required form fields (or item list column s) on the form depending on the value change of other form fields is one of the most frequently used system functions. Until now, to achieve this effect, it was necessary to change several configurati (...)
(...) nce, and any collection defined as a business rule. Fig. 2. Collection type Item list – the ability to select all available item lists in the process. All column s of the item list, excluding column s of local attachments (these column s are not available for reading or saving) can be transferred to an action, operation, or automation. Data source &ndash (...)
(...) on the operation of WEBCON BPS Scalar functions defined in WEBCON BPS mostly perform conversion or formatting operations on single values. There are no subqueries or arithmetic operations on a few column s from the table - passed as input parameters. “Inline” of such functions in WEBCON BPS databases does not improve query performance. However, because they are used in large numbers in SQL (...)
(...) udf-inlining Scalar functions defined in WEBCON BPS databases mostly perform conversion operations or format data on individual values. There are no subqueries or arithmetic operations on multiple column s of the table passed as entry parameters. “Inlining” such functions in WEBCON BPS databases does not improve performance. On the contrary, due to them being used extensively by SQL querie (...)
(...) s created. The workflow includes a configured form for submitting purchase order requests. Among the form fields there is an item list field named “Purchase order list” consisting of four column s, three of which include numerical values. The form field presents items requested by the submitter. The request must be accepted by the superior and subsequently by the accountant with access to the (...)
(...) ws the total budget planned for each month of that year will cause the chart to automatically draw a series for the entire year. Breakdown into year-subgroups is possible after adding a calculated column as part of the chart view configuration on the Report column s tab. The calculated column in the present case will be the time unit – year. After selecting the Add calculated column button, a (...)
(...) th the “PortalCertificate” value. All certificates are stored in a configurable database – the service certificates in the binary form in the “Services” table respective column , while the Portal certificate converted to the base64 format in the global parameters. Note the host addresses, including ports, used for communication. It is not p (...)
(...) ntry point and click the plus button in the right, upper corner of the “Computer terminals” field. A line is added to enter document entry point parameters. Its column s are discussed in detail below. Computer code: user-defined code of computer facilitating workstation identification. Computer name: optional column . If computer works in a network (...)