search results

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

(...)   Fig. 2. The history of the instance   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 (...)

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

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

(...) . WEBCON BPS allows you to map these conditions by using the privileges mechanism. For more information about privileges, see Tasks vs privileges. The WEBCON BPS system operates based on a sql database, one of the places where the information the privileges is stored is the WFSecurities table.   Description The WFSecurities table contains information about current privileges (...)

(...) d configuring process – so that these limits are not reached. All of the following limitations result directly from the WFElements (for form fields) and WFElementsDetails (for the item list) sql table structures.   Limit tables   Global form fields The limit of global form fields applies to the entire system configuration. Regardless of the number of processes, workf (...)

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

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

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

(...) rm fields can be inserted by using various variables, e.g. values from the parent workflow instance :   Or business rules:     The “Start a subworkflow (sql )” action This action allows you to start a workflow instance(s) within the same BPS application and differs from the previous with its “Data” tab, and in that it is not possible (...)

(...) , Instance number, and Status. The workflow was correctly started, you can verify the result on the form in Portal:     Call API also started the “Run subworkflow (sql )” action which has been configured in the first example of starting workflow methods. A detailed description of REST API and WEBCON BPS SDK can be found at https://developer.webcon.com/ (...)

(...) ld will 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 indi (...)

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

(...) with different styles are added. The CurrentField and CurrentRawValue column names are used when referring to data from the cell and when referring to content from the other columns, the names from MSsql (without “WFD_”) are used.     The report view:     If after saving the basic configuration you want to change the coloring mode to advanced, (...)

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

(...) BPS allows creating reports based on the SearchIndex (SORL) data source. This article below will show you how we can configure such a report and explain how it differs from existing reports based on sql databases.   What are and when to use reports based on the SearchIndex source? Reports based on SearchIndex data source provide acceleration of system response time and simultaneously w (...)

(...) dd a parameter with categories to the attachments section. To easily refer to the newly created repository, create a data source that will return the attachment ID (WFDataAttachmets.ATT_ID). The MSsql database source is the best choice here. This type of source (like the source referring to the SharePoint list), can be used in the choice field to give users the ability to choose the right template (...)

(...) onfiguration.   Depending on the chosen type of WEBCON BPS installation: with SharePoint, StandAlone   and following methods of authentication: integrated login, sql login,   The following article is split into four parts – one for each combination of installation and authentication method. Links to specific subsections are found in table 1. (...)

(...) m)   1.1.Software   Windows Server 2012 R2, Windows Server 2016, Windows Server 2019 Microsoft SharePoint Foundation 2013 or Microsoft SharePoint Server 2013/2016/2019 MS sql Server 2012 or higher (full text search mode required) Active Directory (or Azure Active Directory) environment 1.2.Hardware   1.2.1.Architecture There are 3 basic scenarios  (...)

(...) n). In this case, the “Approver” column stores the approvers’ data, so the picker value should be set to ‘login’. It is also possible to return approver logins using the sql /CAML query (logins). When you select the “Data source” option, you can define a data source that contains approver’s logins.   Fig. 5. The approval settings on the i (...)