search results

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

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

(...) ldquo;_Update” technical path which moves the workflow.   Fig. 11. The configuration of the "Moe a workflow (SQL)" action   In the “Data” tab, an sql query is created that adds a new value from the “Transaction” field to the current value in the “Balance” field. The employee’s account balance is increased or decreased by th (...)

(...) Fig. 4. The configuration of the data table field   The data table belongs to the “Data presentation” group of fields – so must be supplied with a data set. We use a sql query that refers to the previously defined item list:   Fig. 5. A SQL query   In the “Data source” field, select the “” option, and then create a que (...)

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

(...) ns to the fields indicated on the form. The limitation of this solution is the ability of transferring only the exact data that is in the source. If you want to modify data to be transferred, use the sql query which is defined in the business rule (Fig. 6).   Fig. 6. The business rule that returns date a year later that the "Start date" of the last contract   Data return (...)

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

(...) itor. 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 the WHERE clause we find a dictionary workflow instance which relates to the selected value from the & (...)

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

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

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

(...) parameter in WEBCON BPS Designer Studio: Fig. 8. Location of the parameter   This parameter is used in the rule definition SQL command: Fig. 9. The parameter used in the sql query   TableName: WFActionBusinessRules, OBjectIDColumnName: ABR_ID, ColumnName: ABR_BRDID Entries refer to the WFActionBusinessRules table are about the business rules used in the act (...)

(...) configuration window   On the „Execution condition” field you can see a nested SQL Command. You can configurate them by clicking the icon of three dots.   Fig. 6 sql query configuration   As the sql query is an execution condition, it has to return a Boolean type of data (1 – true – action is executed, 0 – false – action execution is (...)

(...) e – this entry also exists on the instance history card:   Fig. 6. The history of the instance   To verify the correctness of the displaying the history, the following sql query was created:   Fig. 7. The sql query to the WFHistoryElements table   The WFH_LeaveCurrentStepPath and WFH_LeaveCurrentStepDate tables have the NULL values in the 2 and 3 ro (...)

(...) te presenting the names of the selected columns along with one, empty row. Now, you can set the table style by using built-in Word options.   Downloading data from other systems by using a sql query . In the same way as the item lists, you can add the data tables based on the sql query which refers to the WEBCON BPS database or an external system. In the Word file you can put not only the data (...)

(...) displays this information on the form. After approving the request, the number of days is subtracted from the employee pool.   Fig. 4. The configuration of the action   The sql query used in this action:   Fig. 5. The sql query uses to calculate the working days   This query uses the Calendar table. From this table in the third row, you can limit the ext (...)

(...) uses from several types of forms, you can grant the privileges for each type separately.   Fig. 4. Granting the privileges at the form level in the workflow   The following sql query allows you to download data from the WFSecurities table that relates to the form type for which users have been granted the privileges in the given workflow (ASS_DTYPEID – ID formularza). &n (...)

Applies to version: 2020.1.x and above; author: Piotr Poniedziałek   Introduction WEBCON BPS introduces a lot of new functionalities which allow for creating more complicated processes. In some cases, developing the process is related to an increase in the number of form fields used, although this is not always necessary. For more information see: WEBCON BPS  – l

(...) s” option   In the window which appears on the screen, select the “View logs” tab.   Fig. 2. The “Administration tools” window   The sql query template is automatically substituted in the “Query” section. Such a query should be implemented with an action ID. You can also add the additional filter in the “Additional filter& (...)

(...) r the start and end date of the substitution. The date can be selected from the calendar or can be entered manually. Advanced options – the configuration of the action can be written via sql query . The query should return the following information: Substituted person Substitute person Start and end date of the substitution Process ID (optionally) Business entity (optionall (...)