search results

(...) link will not be visible. If you need a hyperlink creating a new instance instead, add a new data row “Create tags.” As the data source, indicate the current database and fill in the SQL query as shown in figure 14: Fig.14 - Create tags field’s configuration   In the advanced configuration, select Show column and Instance hyperlink and click on the 3 dots. As sh (...)

(...) ns “STP_ExpectedAvgStepDurationByHours” and “STP_ExpectedAvgEditDurationBySec”). The report, which is the subject of this article, is created through a properly prepared SQL query , operating mainly on the tables mentioned above. The report supports translations; the names of processes, workflows, and steps can be translated. The KPI report supports filtering, but it does n (...)

(...) ompetencies” item list, go to the “Layout” tab and check the “Use advanced appearance settings” option. Select the “For whole row” color mode and add the SQL query . Fig. 17 – The row coloring setting On the form, it will look like in Fig 18.   Fig. 18 - Coloring rows with incompatible answers b) Finally, the superior gives the (...)

(...) nd the processes for which the substitutions will be active can be defined based on the application/process ID or the rule. The entire action can also be configured on the basis of an appropriate SQL query . Fig. 8. Configuration window of the Add a substitution action   If necessary, the substitution added in the above way can be removed using another action – Remove a substitut (...)

(...) e action allows you to invoke SQL procedures from the WEBCON BPS form level, and to prepare the universal SQL queries with variables. This functionality is limited only by the capabilities of the SQL query language. It is possible to invoke SQL procedures using data in the WEBCON BPS form and enter/update data in the database. Test workflows This article uses two workflows to showcase running SQ (...)

(...) p; Creating search phrases By using SOLR technology, user can influence on how the engine searches indexed data and as a result – what the results are. Using appropriate parameters in the query allows for more precise results.     Below you can see basic operators which can be used by the user while creating a search query . Action name Example H (...)

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

(...) other than the “Person or group” type, you must designate a column that contains a user login or group ID).   Fig. 4. The "Dynamic" option   SQL query – by entering the appropriate SQL query that will return user logins or group IDs (the login or ID should be in the first column returned by a query ). In the presented example, the query (...)

(...) very day – how business rules can be used to download exchange rates   Converting  exchange rates from the ECB Source configuration The following screenshot presents the query to the ExchangeRates table. The first part of the query (before the “union” tag) allows you to retrieve the ID, code, exchange rate date, and rate for all currencies provided by ECB. (...)

(...) his allows you to uniformly create queries, SQL functions or stored procedures based on column names without having to modify them in the context of multiple environments. Below is an example of a query returning an instance number and the date of registration of a vacation request. This design will work properly, regardless of the environment (DEV-TEST-PROD) it will be run on. Fig.12. An exa (...)

(...) point to a specific user or group.    Fig.1 Form for checking user's or group's privileges   For each example, we will show the user’s view and the SQL query that returns the appropriate data.  Choosing a user or a group Before any data is displayed, the user must select a person or group. Basic information about the user will be displayed next (...)

(...) ID PLN_From <Int32> - Date od (in YYYYMMDD format, e.g. 20200123) PLN_To <Int32> - Data do (in YYYYMMDD format, e.g. 20200125) PLN_WFDID <Int32> - Absence plan ID The SQL query contains data from the WFElements table (such as employee's id) connected by JOIN with the WFElementDetails table with values from item lists. The DET_WFCONID constraint allows you to select the (...)

(...) rding to the item list definition, it is the DET_ID column, it is also recommended to indicate such a column in this field. Data source – indicate a connection to the current database. SQL query – the query should contain the values that will be placed on the item list with indicating a column to which these values will be passed, in the form: Select ‘Value’ as [Column (...)

(...) example – the ^Leave_request.* expression means to download a file whose name starts with “Leave_request”.   Fig. 4. Sample regular expression   SQL query – allows you to create a query that returns the ATT_ID of the attachment from which data is to be downloaded.   Fig. 5. Configuration of the SQL query returning the attachment (...)

(...) he defined regular expression that filters names and extensions.   Fig. 4. Sample configuration of the second attachment selection mode in the Get Attachments rule   C) SQL query – the rule will return attachment’s IDs based on the defined SQL query . In the example, the rule will return the ID of attachments created by the currently logged in user.   (...)

(...) s – Enter the latitude and longitude divided by a “#” sign. Address –  Enter the address of where you want the mark to be placed. Address (dynamic) – Use an SQL query , which will return an address, which will be marked on the map.   Fig. 1. An example of using coordinates   Fig. 2. An example of using an SQL query (Address - dynamic (...)

(...) L tables according to some predefined cycle (e.g. once per 24h, at night). This solution has some weaknesses, but sometimes the priority is to ease the load on system resources. In the case of a query for one value from the source data, periodic synchronisation may not be required. For example, checking the employee’s leave limits (each and every time only leave limits of the same person are (...)

(...) nd provide translations thereof. Despite indicating several columns (Fig. 4), in the drop-down list only the “Season of the year” column will be displayed (Fig. 5). By activating “query data source if variables return empty values” checkbox one can decide whether to set an Empty element display name – placeholder text introduced in this field will be displayed when no va (...)

(...) ence process. The Absence types source must contain all absence types (and in the case of the described application, all types of activities displayed on the Gantt chart).   Fig. 6. A query returning absebce types   The names of the returned columns are as in the query above: VACType_ID --> ID of the absence/activity (must be unique) *required VACType_ColorID --> (...)

(...) values. There are no subqueries or arithmetic operations on a few columns from the table - passed as input parameters. “Inline” of such functions in WEBCON BPS databases does not improve query performance. However, because they are used in large numbers in SQL queries generated, for example, by application reports, the size of such a query increases significantly during "inline", (...)