search results

(...) m fields,   asynchronous invocations of form fields such as data table, data row, chart, pick box (along with the content of queries),   application report’s query content.   Each invocation has its duration displayed.   The session preview window can filter invocations by their source (form, reports, Portal). It is also poss (...)

(...) tachment from the form. In our example, we have configured the action to place the user picture in a category named "User photo."  However, you can also use a regular expression or SQL query to indicate where it should be placed. The photos created must be saved in an appropriate format (JPG, BMP, PNG, GIF), have a size not larger than 10 KB, and their resolution cannot exceed 96x96 pixe (...)

(...) ximum requisition value a given supervisor can accept. For the condition to be considered fulfilled, it must return “1” or “True” in the first column, in the first line of the query response. Let us comment on the function in figure 12 now. The value “Limit” reads the approval limit set for the superior who is being checked at the moment. The ‘## login ##&r (...)

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