search results

How to access values of the 'datasources'? -> The query only returns the ID of the datasource.

(...) Hi there, Is it possible to use one datatable to show different tables from a SQL server? Right its possible to filter the SQL results based on a value in a certain column. I also want to make it possible to show the content of a different table, however account to the infobox to the right side of the textbox where i write the SQL statment, its not possible. So i was wondering if there is an alterna (...)

(...) able in the template. The good option is to create the dictionary processes – for more information, see Dictionary processes.   Fig. 10. Attachement section   The SQL query returns the attachment ID because the attachment versions are stored in the database. You must select the current one –for this, add TOP 1 and ORDER BY ATT_TSUUpdate DESC. ATT_WFDID is th (...)

(...) eld is set by the “Set Nett Amount in PLN” form rule which uses the “Nett amount in PLN” business rule. The business rule returns a floating-point number calculated with an SQL query. The SQL query returns the result of multiplying the value from the “Nett amount” field and the average rate of the selected currency, where the invoice date is the effective date o (...)

(...) sitive value for each type of transaction.   Fig. 10. The configuration of the "Change value of a single field" action   The last action is “Move a workflow (SQL )” that moves the “Account” workflow to update the amount in the “Balance” field. In the configuration window in the “Parameters” tab enter the “_Update (...)

(...) : Franciszek Sakławski   Introduction When creating the configurable e-mail templates there is the option to add fields from the form. This article describes how to add an item list and SQL data table fields.   Fig. 1. A list of fields available in the system   To enter these types of fields in the template is needed: Basic knowledge of HTML language (spe (...)

(...) dquo; field to whom the task is assigned in the next step. Below there is a query used to select a person:   Fig. 10. The "Responsible" field is the person or group type. The SQL query returns an employee's login to whom the task is delegated and sets them as a field value   The query returns the user’s login (PersonLogin) – the ID of employee (...)

(...) n of the form rule with using the business rule   Execution of a form rule depending on data in other instances/workflows In the business rules, there is the ability of referring to the SQL database and returning the specified data based on the process configuration or documents registered in the system. In the example, the SQL COMMAND function was used and it was checked whether contra (...)

(...) author: Dawid Golonka   Introduction Some processes in WEBCON BPS require data from some other source to operate correctly. This data can be provided from external data sources such as SQL databases or SharePoint lists. Internal sources can also be created in the system such as Fixed value lists or references to data contained in WEBCON BPS workflows. Any WEBCON BPS process can be used (...)

(...) tion of the action for sending documents   In the first field define how to select the attachment to sign – there are two options: Based on the document category Based on the SQL query If you select the first option, you can define which category is to be selected. Additionally, a RegEx expression can be used – to limit the search by attachment name. If you select (...)

(...) e via up/down arrow keys, and then entering them – either by pressing the Enter key or using the mouse. By clicking the “Show more result” option, the user will be redirected to the SQL R search engine. There is also the option to enter search content in the search field. The entered phrase is also searched in the form fields. The search is carried out in real time and with an wit (...)

(...) in, so it is a good idea to define it as a constant in the process. Attachment selection – indicate: The method of attachment selection -> based on the attachment’s category or SQL query The technical form fields to which the attachments’ identifiers will be saved Message content – enter the title and content of the message sent with the attachment Recipien (...)

(...) n of the “Picture” field   Using the icon of three dots, you open the editor. In the editor go to the function tab and from the “Integration” list select the “SQL COMMAND” option. Then place the following query in it:   Fig. 13. The SQL query editor   In the SELECT clause select the field that stores the picture code, while in t (...)

(...) used to send documents to the Skribble platform for signing.   b) Attachment selection SelectionMode – attachments can be selected based on the category (the Category value) or SQL query (the SQL value) CategoryMode – attachments can be selected from a specific category (the ID value), not related to any category (the None value) or all (the All value) Category ID &nd (...)

(...) D column” option in the item list form field configuration. The above query returns all completed data from the “report of service events” item list.   Fig. 6. The SQL query   An example query that returns information about service visits along with information about given car – in the last 30 days.   Fig. 7. The SQL query – di (...)

(...) lds (dates, numerical fields, choice fields…) are stored in the WFElements table in a different format from the one in which they are displayed on the form of the given instance. The following SQL query returns all the completed fields on the form for the above instance (Fig. 4) – Infiniti registered car.   Fig. 6. The SQL query – storing data about the instance & (...)

(...) is data is necessary for all SDK actions so you can enter them as constants in the process. In the “Attachment section”, define  the method of attachment selection (by Category or SQL query) and technical form fields to which the ID of the signed document and envelope created in DocuSign will be saved.   Fig. 6. The configuration of the action   In the ne (...)

(...) dash; zooming/reducing. In some parts of the system you can use with the ability of zooming and reducing the entered text/rules to improve their readability. These places are e.g. a window to enter a SQL query, window to enter rules/formulas, window of workflow graphic schema.   Fig. 10. The diagram before rescaling   Fig. 11. The diagram after changing the scale  (...)

(...) are represented in the content database – which is the main place of the system’s operation. There are also “virtual tables” automatically created by the system – called SQL views – that contain data from the linked tables. This article describes some of the most important views that users can refer directly to the WEBCON BPS Designer Studio level or from the da (...)

(...) istered” step. In order to configurate it, we need to double click it, then go to the “Actions” tab. As it is presented on Figure 5 type of the action is “Start a subworkflow (SQL )”.   Fig. 5 Action configuration window   On the „Execution condition” field you can see a nested SQL Command. You can configurate them by clicking the ico (...)