search results

(...) x maintenance (reorganize and rebuild). Statistics updating.   Indexes and statistics maintenance is crucial for system performance. Based on this data, the SQL Server engine generates query execution plans which results directly in query execution time.   Daily execution of the above operations in the service window is recommended. 7.2.Resources monitoring. Similarly to (...)

(...)   As the presentation workflow has already been configured in the above-mentioned article and an error has been "generated", in this article we will use the same example. By query ing to the table and narrowing it down to the message with GUID =  5dae0f48-5d70-4dd3-b5b3-f134f28c2342 (as in the above article), you get access to the same data:   Fig. 1. The re (...)

(...) is 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 item list (...)

(...) of creating a dedicated SDK plugin. For example, these can be dedicated plugins: Converting  PDF to jpg/jpeg/png format Merging several PDFs into one Generating Excel based on the SQL query Creating/deleting SharePoint groups based on the query Changing the form type Settlement of business trips   To upload a plugin package to Designer Studio: 1. Go to Plugin (...)

(...) . It has a single step and will have only one instance of a given form type. Add the template (as an attachment) to this instance.     To select the template, use the SQL query :     Where ATT_WFDID is the ID of the dictionary process instance. Then configure the “Result” tab – in the File name enter the form field from the form. (...)

(...) g. 21. Send file - Request body tab   There are three business rules that can be seen in the screenshot above. The “Att: ID” rule is the basis for the others. It contains a SQL query that returns the ID of the last added attachment added to the current instance.   Fig. 22. The “Att: ID” rule   The “Att: Name” and “Att: (...)

(...) from which values indicated by action will be downloaded. The data source can be defined as any data source available to the current WEBCON BPS system. Remember that in SQL source you must use a SQL query and in the case of other sources – a properly prepared filter. If you define data source but do not set SQL query or filter, the system will return all columns available in the data source. (...)

(...) – the “Based on instance ID” mode Adding attachments from other workflows from the external WEBCON BPS content database or external attachment databases selected based on the SQL query – the “Based on SQL query ” mode   The workflow The simple Invoice workflow has been created on the “Copy PO to attachments” path, the action of adding at (...)

(...) ield:   Fig. 6. The “Is Poland” field default value   Business rule On the form, you can also create business rules that can use integration tools such as SQL query or Data Source Value. Let’s create a rule and implement it in the “Style and behavior” tab. To present the abilities of business rules, take the “Name” value of the &ldq (...)

(...) that the impact of browser and portal settings on the format of the displayed data applies only to the actual date fields. When the field is only text completed e.g. by a business rule using the SQL query – the format will be transferred through the configuration of this rule. During configuration of the text field, the formatted value of the date field can be set as a default value. &nb (...)

(...) rsion 2020.1.3; author: Konrad Wojtycza   Introduction In WEBCON BPS data stored e.g. in the external database can be retrieved and displayed by: Defining data connection and SQL query Creating a data source and using filters This article describes both approaches to use data in WEBCON BPS, differences between them, and problems of their configuration.   Example (...)

(...) you want to export them to an Excel file, see how to easily convert the data to match the template. The #Users tab has been created that stores user’s data:   Fig. 5. The SQL query   Data returned by the query does not match the formula specified in the Excel file template, so you have to transform this query to get the columns used in the import.   F (...)

(...) of the item list. In the example below, after selecting a manager, the list should be initialized by their subordinates.     In the item list configuration, enter the following query :     By clicking the created “Initialize employees” button, the Employees list will be filled out with the appropriate employees’ data.     (...)

(...) aching process, e.g. If you want to  teach based on  2 document types or only documents from the verification step – you can change the attachments selection criteria by using the SQL query .   Fig. 4. The example criteria of attachments selection   Remember to include the distinguisher (if the dedicated network mechanisms are used) and document type in the que (...)

(...) sistant to the failure of one ZooKeeper node is 3.  In the case of Solr – operation of at least one node is required. Number of nodes = N+1. Loadbalancer is responsible for directing query traffic from WEBCON BPS  to Solr nodes. Solr and ZooKeeper can be installed in any environment – directly on Windows or Linux machines, or in a container environment. WEBCON BPS refers (...)

(...) ersons to whom the task should be assigned. The predefined task assignment is described in the Predefined task assignment article. In the “Business rule” option, you can create an SQL query that defines people to whom the task is to be assigned. In the example below, people to whom the task is to be assigned are selected from the item list filled in at the initial step by the registerin (...)

(...) of sending an attachment, auxiliary business rules have been created that will return the attachment type, name, and content.   Using the “CONTENT TYPE” built-in action in the SQL query allows you to return all attachment IDs added to the “Share” category on the form.   Fig. 2. The business rule that returns the attachment content using the “Content (...)

(...) d values of other form fields.   Fig. 8. The configuration of the validation action for checking the date and time fields   The validation condition may also contain an SQL query that can, for example compare values returned from the database with values entered on the form. The appropriate SQL query syntax also allows the expression itself to be a validation condition. & (...)

(...) options for coloring rows under the Color mode. Fig.2 Choosing the color mode You can choose from three color modes: for the entire row, for selected columns, defined in the query .   Mode: for whole row This mode lets you color the entire row of an item list with a given color. You can decide that a row's value will determine its color because the SQL / CAM (...)

(...) choose how to add elements: Static - in this mode, fields from the workflow form should be assigned to the columns in the SharePoint list, Dynamically - in this mode, you should define a SQL query . It will return columns with the same name as the SharePoint list column.   Fig.6 Configuration for the action “Add a new list element” The "Save ID in:" (...)