search results

(...) ld will become active. You must enter a variable which refers the form field that contains the instances ID. The instance to be updated is selected based on the value (ID) found in this form field. sql query – the instance to be updated is selected based on the sql query . The query should return one column containing instances ID to be updated. The query can return several rows. You must indicate t (...)

(...) t.     C. Create a task action The business rules can also be used during the configuration of the “Create a task” action. The “Always to” and “sql query ” sections were replaced by the “Business rules” section. Due to the introduced changes in the functionality – during the migration process, the existing configuration of se (...)

(...) ield, we can then use it in the attachment generation action. This time in the action configuration it should be indicated that the template comes from the attachment whose ID we will indicate in the sql query .   Fig.15. The action of adding an attachment that has already been attached to another instance   This type of document library allows you to completely cut off from ShareP (...)

 PDF version   1. Prerequisites (SharePoint platform)   1.1.Software   Windows Server 2012 R2, Windows Server 2016, Windows Server 2019 Microsoft SharePoint Foundation 2013 or Microsoft SharePoint Server 2013/2016/2019 MS SQL Server 2012 or higher (full text search mode required) Active Directory (or Azure Active Directory) environment 1.2

(...) all people from the list at the same time/one person from the list If all people at the same time or one person from the list should approve the instance, it is necessary to assign a task using an sql query on the path following the approval step (the “Purchase order approval” step). In the task configuration, if you select the “Completion – Any” in the “Paralleli (...)

(...) lity of creating a dedicated SDK plugin. For example, these can be dedicated plugins: Converting  PDF to jpg/jpeg/png format Merging several PDFs into one Generating Excel based on the sql query Creating/deleting SharePoint groups based on the query Changing the form type Settlement of business trips   To upload a plugin package to Designer Studio: 1. Go to Plugin (...)

(...) tion from which values indicated by action will be downloaded. The data source can be defined as any data source available to the current WEBCON BPS system. Remember that in SQL source you must use a sql query and in the case of other sources – a properly prepared filter. If you define data source but do not set sql query or filter, the system will return all columns available in the data source. (...)

(...) w ID – the “Based on instance ID” mode Adding attachments from other workflows from the external WEBCON BPS content database or external attachment databases selected based on the sql query – the “Based on sql query ” mode   The workflow The simple Invoice workflow has been created on the “Copy PO to attachments” path, the action of adding at (...)

(...) o; field:   Fig. 6. The “Is Poland” field default value   Business rule On the form, you can also create business rules that can use integration tools such as sql query or Data Source Value. Let’s create a rule and implement it in the “Style and behavior” tab. To present the abilities of business rules, take the “Name” value of the &ldq (...)

(...) o version 2020.1.3; author: Konrad Wojtycza   Introduction In WEBCON BPS data stored e.g. in the external database can be retrieved and displayed by: Defining data connection and sql query Creating a data source and using filters This article describes both approaches to use data in WEBCON BPS, differences between them, and problems of their configuration.   Example (...)

(...) and you want to export them to an Excel file, see how to easily convert the data to match the template. The #Users tab has been created that stores user’s data:   Fig. 5. The sql query   Data returned by the query does not match the formula specified in the Excel file template, so you have to transform this query to get the columns used in the import.   F (...)

(...) e teaching process, e.g. If you want to  teach based on  2 document types or only documents from the verification step – you can change the attachments selection criteria by using the sql query .   Fig. 4. The example criteria of attachments selection   Remember to include the distinguisher (if the dedicated network mechanisms are used) and document type in the que (...)

(...) on/persons to whom the task should be assigned. The predefined task assignment is described in the Predefined task assignment article. In the “Business rule” option, you can create an sql query that defines people to whom the task is to be assigned. In the example below, people to whom the task is to be assigned are selected from the item list filled in at the initial step by the registerin (...)

(...) ion of sending an attachment, auxiliary business rules have been created that will return the attachment type, name, and content.   Using the “CONTENT TYPE” built-in action in the sql query allows you to return all attachment IDs added to the “Share” category on the form.   Fig. 2. The business rule that returns the attachment content using the “Content (...)

(...) s and values of other form fields.   Fig. 8. The configuration of the validation action for checking the date and time fields   The validation condition may also contain an sql query that can, for example compare values returned from the database with values entered on the form. The appropriate sql query syntax also allows the expression itself to be a validation condition. & (...)

Applies to version 2020.1.3; author: Michał Kastelik With WEBCON BPS, you can color the background of the item list form field. This functionality can facilitate data interpretation and increase transparency when presenting a lot of data.  This article will present the available options for coloring the background of the item list. Go to the coloring settings, open the item list

(...) and choose how to add elements: Static - in this mode, fields from the workflow form should be assigned to the columns in the SharePoint list, Dynamically - in this mode, you should define a sql query . It will return columns with the same name as the SharePoint list column.   Fig.6 Configuration for the action “Add a new list element” The "Save ID in:" (...)

Applies to version 2021.1.1; author: Kinga Bożęcka WEBCON BPS 2021 introduces the mechanism of diagnostics and recording the behavior of the form and other elements of WEBCON BPS Portal. This mode is a successor to the old Debug mode which was used to track all modifications that impact the visual layer.  This functionality toggles a diag

(...) the link will not be visible. If you need a hyperlink creating a new instance instead, add a new data row “Create tags.” As the data source, indicate the current database and fill in the sql query as shown in figure 14: Fig.14 - Create tags field’s configuration   In the advanced configuration, select Show column and Instance hyperlink and click on the 3 dots. As sh (...)

(...) edure action allows you to invoke SQL procedures from the WEBCON BPS form level, and to prepare the universal SQL queries with variables. This functionality is limited only by the capabilities of the sql query language. It is possible to invoke SQL procedures using data in the WEBCON BPS form and enter/update data in the database. Test workflows This article uses two workflows to showcase running SQ (...)