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

(...) Applies to version 2017.1   WEBCON BPS gives a wide range of possibilities when it comes to assigning tasks. Tasks for users can be created based on the value of a form field, SQL /CAML query, directly indicating the users/groups or by selecting one of the predefined options. This article describes the predefined options of task assignment, which does a lot of workflow a (...)

(...) with different styles are added. The CurrentField and CurrentRawValue column names are used when referring to data from the cell and when referring to content from the other columns, the names from MSSQL (without “WFD_”) are used.     The report view:     If after saving the basic configuration you want to change the coloring mode to advanced, (...)

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

(...) BPS allows creating reports based on the SearchIndex (SORL) data source. This article below will show you how we can configure such a report and explain how it differs from existing reports based on SQL databases.   What are and when to use reports based on the SearchIndex source? Reports based on SearchIndex data source provide acceleration of system response time and simultaneously w (...)

(...) dd a parameter with categories to the attachments section. To easily refer to the newly created repository, create a data source that will return the attachment ID (WFDataAttachmets.ATT_ID). The MSSQL database source is the best choice here. This type of source (like the source referring to the SharePoint list), can be used in the choice field to give users the ability to choose the right template (...)

(...) onfiguration.   Depending on the chosen type of WEBCON BPS installation: with SharePoint, StandAlone   and following methods of authentication: integrated login, SQL login,   The following article is split into four parts – one for each combination of installation and authentication method. Links to specific subsections are found in table 1. (...)

(...) m)   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.Hardware   1.2.1.Architecture There are 3 basic scenarios  (...)

(...) n). In this case, the “Approver” column stores the approvers’ data, so the picker value should be set to ‘login’. It is also possible to return approver logins using the SQL /CAML query (logins). When you select the “Data source” option, you can define a data source that contains approver’s logins.   Fig. 5. The approval settings on the i (...)

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

(...) not allow you to register an instance with the same number (e.g. 00000001). If you need to search instances in the database  - e.g. to display information from another instance in the “SQL table” form field, you should use the instance ID (WFD_ID) instead of the instance number.

(...) zard. It has a single step and will have only one instance of a given form type. Add the template (as an attachment) to this instance.     To select the template, use the SQL query:     Where ATT_WFDID is the ID of the dictionary process instance. Then configure the “Result” tab – in the File name enter the form field from the f (...)

(...) Fig. 21. Send file - Request body tab   There are three business rules that can be seen in the screenshot above. The “Att: ID” rule is the basis for the others. It contains a SQL query that returns the ID of the last added attachment added to the current instance.   Fig. 22. The “Att: ID” rule   The “Att: Name” and &ldqu (...)

(...) ance. Value – this field defines the value set after execution of the action. In this field you can use all functions and form fields available for business rules e.g. arithmetic operations, SQL expressions and form fields available on the form. Error message – this field defines the error message displayed when there is a missing value error. It is recommended to set a custom erro (...)

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

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

(...) mber that the impact of browser and portal settings on the format of the displayed data applies only to the actual date fields. When the field is only text completed e.g. by a business rule using the SQL query – the format will be transferred through the configuration of this rule. During configuration of the text field, the formatted value of the date field can be set as a default value. (...)

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

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

(...) to the form rules or JavaScript consisting of the available editor functions while maintaining the logic of the Modern form Switch data sources and SharePoint libraries to dictionary processes or SQL tables Change SOAP WebService to REST WebService. It also applies to integration with WEBCON BPS - if SOAP was invoked, it should be changed to REST Changes in SDK All information ab (...)