search results

WEBCON: Business Process Automation and Management as its best WEBCON develops the Low-Code Business Process Automation Platform, WEBCON BPS (Business Process Suite). This enterprise-grade system allows organizations to embrace digital transformation by digitalizing their workflows and building comprehensive, scalable, process-centric and future-proof applications applying t

(...) quo; option allows you to modify the selected columns for the selected rows, The last “Replace values” option is used to clear the entire list and add those that you want to select with a query . The best option will be “Add new values”. Each department adds people from their item list (Personnel – development) to the main “Personnel” list.   F (...)

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

(...) o;_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 (...)

(...) for an employee. If so, the task is assigned to one of the employees of this group (the “Assign” path), if not, the task goes to the “Queue” step.   Fig. 7. The query that returns the number of tasks assigned to all employees from the group   The limitation in the query above selects only those elements that are: TASK type (narrowed down to the&nb (...)

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

(...) o then went through the path to the last step. The WEBCON BPS is a system embedded in the database that stores information about tasks in the appropriate database table – WFElementTasks. By query ing this table and narrowing it down to the instance ID (from the example), you get the following result (selected columns were downloaded in the query ):   Fig. 9. The table contains i (...)

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

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

(...) a transport coding method, any picture can be encoded in this way. The base64 value can be found in the database by referring to the column in which the picture is stored:   Fig. 6. A query calling picture in base64 format   In the way described below, two instances of the dictionary workflow have been added – each of which stores the company logo. One logo with a black (...)

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

(...) the database, it is used only to define the order of the rows. This column is displayed after selecting the “Show ID 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 visit (...)

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

(...) ata 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 next fie (...)

(...) ; 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  &n (...)

(...) e business entity Information about the created and modification date Information about form field values (the column names are the same as the form field names on the form)   In the query to the view you can use conditions and results filtering e.g. searching information about instances of a given author etc. The additional uses and features of the process view: Allows you to qu (...)

(...) es and enabling empty values in the data source. The second field, when checked, will allow the use of variables that return an empty value. When the option is deselected and the variable used in the query returns an empty value, the records will not be displayed. Fig. 6. The configuration of the “Data row” form field   Survey fields – rating scale The configurati (...)

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

(...) lue of invoices they have not paid. This value will appear in the “Value of unpaid invoices” field. You can do this by using the “Data row” form field and by creating a simple query to the BPS database – this query narrows only to results in which the “Payment date” field is empty. An example of such a query is below:   Fig. 6. A query in the dat (...)