search results

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

(...) rsonal data” action in the background. Associated module: “Personal data removal”.   Updating active task counters – updating active task counters available in the sql reports. Associated module: “Tasks info calculation”.   Importing process and application configurations – the import of a process or an application taking place between (...)

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

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

(...) a table Like the item list, the “Data table” form field has a header, row, and footer. Header: The HTML code in the header section should contain column names. Code: {sql GRIDHEADERTEMPLATE:GUID} {/sql GRIDHEADERTEMPLATE} Row The code of the row section must include tags referring to values of individual columns. The tags for particular columns are to be foun (...)

(...) vice.   The example uses Docker Desktop. All basic components of WEBCON BPS can be installed there. Only the system's databases must be created on an existing instance of Microsoft sql Server accessible from the computer running WEBCON BPS in containers. Installation steps: Creating the WEBCON BPS Search Server container and initializing Solr search indexes. Creating sql (...)

(...) edicated account for reading data from the database already existed in earlier versions of the system, but now it is created by default. Thus, bps_user is the standard account in the context of which sql COMMAND rules and all queries using the Default connection are executed, e.g. when configuring selected form fields or actions, executing or testing sql queries with the use of <Current BPS databa (...)