search results

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

(...) ser – the notification will be sent in the default language configuration. The language currently assigned to each of the BPS users can be checked in the database by performing the following query : select USRLAN_UserLogin ,LAN_Name from TranslateUserLangs join TranslateLanguages on LAN_ID = USRLAN_LANID   Entering translations of the e-mail notification templates In W (...)

(...) reen@webcon.pl”   To create such a list, we will first pass our data through a technical form field – multiple lines of text.     The action uses the SQL query to merge all records into a list, with entries separated by commas. The final result is in a format that can be used for calling the Microsoft Graph method. Our technical form field prepared in such (...)

(...) e   The workflow was changed only once. In the WFHistoryElements table two entries were made – to check this go to the SSMS (“SQL Server Managements Studio”) and create a query about this particular table. Check also the WFElements table – they should be one entry with the current data.   Fig. 3. The query to the tables   If you query the WFH (...)

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

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

(...) employee’s vacation request at the “Acceptance” path.   Fig. 2. The workflow used to register a vacation request   Below there is the result of an example query which returns the data from the WFMails table. The query returned the results for a specified – given ID of the instance in the workflow.   Fig. 3. The query to the WFMails table (...)

(...) list on the left and go to the “Privileges” tab.   Fig. 2. Granting the process privileges   Examples of authorized users and one group have been introduced. By query ing the WFSecurities table in the database you can obtain information about the privileges granted in the process (the process ID can be read from the “General” tab).   Fig. (...)

(...) ve any limitations, using them in excess can increase the time it takes to load the form and performance reduction. Especially if the item list has many rows and the data table calls up a complicated query . The group of form fields and panels with tabs do not have to affect the on restrictions of form fields. The operation mode choice field sub-type does not affect the limit.   Summary (...)

(...) Fig.5. The configuration of the Teach OCR AI action   Attachments selection criteria – you can select the attachments which will be included during teaching by using the SQL query By using the “OCR AI Learn” path you can teach the program. In this way the system learns how to analyze vendor invoices based on the NIP distinguisher.   Summary This (...)

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

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

(...) “Data” tab, and in that it is not possible to save and store the IDs of started workflow instances in form fields. Data needed to start the workflow should be provided by using the SQL query – this allows to start many new instances of the workflow. The following example shows how to start several subworkflows for several people based on the item list by using this action. &n (...)

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

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

(...) ny instances have gone through a given path – this function allows you to check which paths in the workflow are most often chosen. They should be particularly closely monitored in terms of query optimization and execution time of procedures. How many instances have ever been found in a specified step – seeing how many instances and how often have gone through a specified step, w (...)

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

(...) , we can then use it in the attachment generation action. This time in the action configuration it should be indicated that the template comes from the attachment whose ID we will indicate in the SQL query .   Fig.15. The action of adding an attachment that has already been attached to another instance   This type of document library allows you to completely cut off from ShareP (...)