search results

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

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

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

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

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

(...) the query.   Mode: for whole row This mode lets you color the entire row of an item list with a given color. You can decide that a row's value will determine its color because the SQL / CAML query is performed for each row. The query must return a hexadecimal color. When you write a query, you can use the tags from the form field search window in the expression editor. &nbs (...)

(...) author: Michał Kastelik   Calculated columns enable you to display additional information in WEBCON BPS reports. They are created by adding a new column in the report and then inserting a SQL   formula. They allow the report to be supplemented with additional fields that are not present in an application. A calculated column only works within a given report.   Creating calc (...)

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

(...) iagnostic mode is running, all form, report, and other WEBCON BPS Portal elements' invocations are registered. The following are recorded:  business rule invocations (with SQL content, if the rule contains this type of invocation),  form's rules invocations (including all invocations of functions that modify the form),   invocations (...)

(...) e attachment from the form. In our example, we have configured the action to place the user picture in a category named "User photo."  However, you can also use a regular expression or SQL query to indicate where it should be placed. The photos created must be saved in an appropriate format (JPG, BMP, PNG, GIF), have a size not larger than 10 KB, and their resolution cannot exceed 96x9 (...)