search results

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

(...) s not affect the behavior of the SQL server itself. The database compatibility level setting provides backward compatibility with earlier versions of SQL Server in what relates to Transact-SQL and query optimization behaviors only for the specified database, not for the entire server.   Compatibility Level documentation: https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-databas (...)

(...) on of the send document action   Configuration of the subsequent action sections is presented below:   Figure 7. Attachment selection     Here, create SQL query to WFDataAttachmets table returning ID of the attachment sent for signature. In the respective case restrict searching to searching with the current instance ID, check if the file belongs to “T (...)

(...) guration, changing queries in: data sources, actions, business rules (SQL COMMAND), in locations where it is not possible to choose the <current database> option or where the query contains direct reference to the database.   If the problem applies to a newly installed WEBCON BPS app, it is better to reinstall the app than to enter the changes manually.   (...)

(...) “Use advanced appearance settings” field. Leave the colour mode field with “For whole row” value. It is now possible to type in the SQL code in the text field “SQL/CAML query that returns color”, but in the discussed case we will use the expression editor that facilitates edition. Click the ellipsis button next to the text field “SQL/CAML query that returns co (...)

(...) ngren.com/sql-server-index-and-statistics-maintenance.html   The MaintenanceSolution.sql script is available in the Download section. Download and paste it into the SQL instance in the new query window. Link to download the script directly: https://ola.hallengren.com/scripts/MaintenanceSolution.sql   Run the script in the context of the database where the logs of the operati (...)

(...) drop-down list available in “Instances selection mode”, you can choose only the current instance to undergo archiving (“Archive only current workflow instance”) or use an SQL query to indicate the instances to be archived (“Select workflow instances using SQL”). The latter option requires inserting an SQL query in the “SQL query ” field. The options av (...)

(...) lity that uses the hotmailbox option (triggering automatically workflows or adding files based on e-mails sent to an inbox configured in the hotmailbox). In the configured intervals a service sends a query to such an inbox and checks the messages it holds. Depending on the configuration, if a configured inbox receives a new message, a service can start a new workflow instance in a given process and add (...)

(...) synchronization. As a result, it is also possible to retrieve such information about AD users that would not otherwise be returned. In order to retrieve user data directly from AD, an appropriate query must be defined. To do this, use one of the existing query kinds or create your own query . A new Domain users data source can be created by selecting the Data sources tab  in WEBCON BPS Designer (...)

(...) 5. All attachments tab with collapsed branches of the folder tree   Additionally, in the Linked documents view configuration window, the user can define additional folders based on an SQL query . Fig. 6. below shows a sample SQL query based on which a folder with .xlsx files from all related workflows will be created.   Fig. 6. Sample SQL query defining a custom attachment fol (...)

(...) Global business rules The “AddAttachment_AtThisStep" rule This rule verifies whether an attachment is added on a particular step. The verification is executed by means of an SQL query that checks whether an attachment is added to an instance after defined time (date and time). A business rule with a conditional clause The rule is used to check an attachment is added on a (...)

(...) at no task is neglected. Simultaneous operation of threads means that there is no sequence per se in this case. Database processing For databases, a master queue applies. It is a single query relating to all queues simultaneously executed by an SQL server. [Currently, the system logs some of the queries sent to the content database provided the “Debug” mode (“System sett (...)

(...) Service.exe". Successful connection of the service with Portal will be evidenced by the message:   In addition, the registered printer can be checked in Portal by sending a query to the private API by adding "/api/signalr/connectedServices" to the Portal address in the browser. If the printer is registered correctly, its ID will be displayed in Portal: &nbs (...)

(...) default behavior is not enough.   The Solution Fortunately, WEBCON BPS provides a way to solve this quite readily using a technical field, an automation action, an extra path, and a SQL query .   Part One: The Technical Field Create an extra field to be used by the parent workflow of type Date and enable time selection under Advanced configuration. Part Two: The Au (...)

(...) ] FROM WFElementTasks WHERE WFT_WFDID = {WFD_ID} AND WFT_Version = (SELECT MAX(WFT_Version) FROM WFElementTasks WHERE WFT_WFDID = {WFD_ID}) AND WFT_FinishPath IS NOT NULL   The query makes use of the WFElementTasks table, which contains specific task assignments – and their results – for a process instance. As mentioned earlier, we query only the entries from the most (...)

(...) splayed in these form fields. The function allowed for the extraction of the ID component which could then be utilized for filtering or joining different database records using the JOIN clause in the query .   An example of a query that incorporates the dbo.ClearWFElemID function to extract the ID value from records stored in the specified column   While useful, the function ha (...)

(...)   However, the employee wants to be able to select only those luminaires on the form that meet the customer's requirements. It is therefore necessary to configure a suitable filter query for the Luminaire choice field, so that only those values of the data source column that meet the specified conditions are returned:   The most effective way to create such a filter co (...)

(...) de and processes the encoded value appropriately. Searching by QR codes Users of the mobile application can search databases in two ways: using the standard method, i.e., by manually entering a query in the search box, or by inputting the QR code value into the search box and initiating the search.  To use the latter, click the QR code icon available in the search box opened after clicking (...)