search results

(...) edicated account for reading data from the database already existed in earlier versions of the system, but now it is created by default. Thus, bps_user is the standard account in the context of which SQL COMMAND rules and all queries using the Default connection are executed, e.g. when configuring selected form fields or actions, executing or testing SQL queries with the use of <Current BPS databa (...)

(...) ds 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 settings” → the “Global parameters” no (...)

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

(...) GDPR class. Tools provided: 4 SDK actions are used for operating on data sets 1 action – anonymization/data removal 3 custom data sources are used for providing data to Data Table (SQL Grid) reporting controls   Action searching through process-type personal databases (based on BPS process) WebCon.WorkFlow.Extensions.GDPR.Actions.FillPersonalDataItemList Act (...)

(...) s.   Tracing Module’s name Remarks ASP .NET Core Instrumentation   SQL Client For Portal and Service it is possible to view SQL queries. HttpClient   WCF Client Integration with Se (...)

(...) hich said it could be followed if two tasks had been completed.   The Solution   It is quite possible to get the desired voting-style behavior from WEBCON BPS using one or two SQL queries together with a Workflow Control step. Moreover, the SQL queries can be encapsulated onto global business rules that can be reused repeatedly. At a high level, it looks like this: & (...)

(...) e “ID” serves as an identifier and “Name” represents the displayed name. The first part, “ID”, represents a unique value. It is the element most frequently used in SQL queries designed to filter results displayed in picker fields populated with values from a specific data source. Such filtering is often employed to exclude irrelevant information, presenting only wh (...)

(...) along with a business case for its use.   Basic definitions and functional assumptions LIKE and CONCAT are functions that can be used in WEBCON BPS to create business rules, form rules, SQL queries, and to retrieve values from data sources. CONCAT combines text values into a single string and is available among the functions dedicated to text. With CONCAT you can retrieve global cons (...)

(...)   Backup and Restore WEBCON databases. Next, we need to recreate all WEBCON databases, such as: Configuration Content Attachments Archive (if necessary)   The MSSQL Admin should create a copy of production databases, and recreate the database on the development or test environment from this copy – replacing existing databases. If the databases were recreat (...)

(...) p; Requirements WEBCON BPS containers are based on images that use Windows Server Core architecture. Therefore, the admin cluster needs to be able to run loads of this type. If SOLR and/or SQL components are to be implemented in the same cluster, the cluster must support loads based on both Linux and Windows containers. The application requires the ingress controller to support ARR with (...)

(...) de to the Item list, the action log displays data on the number of rows updated, added, or removed. Action configuration and execution example The action was configured with the external MSSQL database data source named “Spare part price list”, whose columns correspond to the columns of the “List of spare parts” Item list. The action execution assumption in the pres (...)

(...) w. Data Population in the Itemlist Itemlists can populate data either dynamically or statically. Dynamic initialization typically involves integrating data from various sources, often using SQL scripts that can range from simple to complex. Once the script is created, the columns from the SQL output are mapped to the itemlist to ensure accurate data transfer. Alternatively, static initializ (...)

(...) Hi, with the introduction of BPS Portal we got a few additional options were we can add "code" and where variables from the expression editor would be useful if not even mandatory. 1. Report - SQL Filter, there are a few variables there already 2. Calculated field in Reports and BPS internal view, no option to use existing variables 3. Report - advanced formatting, no options to use existing varia (...)

(...) Hi, just a simple, easy request - can you please add a usefull code editor to SQL rules, JavaScript rules and HTML fields details ? Sure, one can copy paste the code from external editors, but it takes time, having an embedded editor would be a great feature.

(...) Hi, so HTML attributes are great, but only untill you try to do something with them - like hide for example... or export - import Seems like you keep them all in a single SQL field:-( So, some JS manipulation is needed, rule editor is useless. Can you make normal HTML attributes - every attribute in separate SQL field?

(...) positive. I thought about using the advanced settings, but I have no idea how. Documentation: You can also define the path dynamically. To do this, select Use advanced settings and create a suitable SQL query in the Advanced path choice field. When is this executed? a) When the first sub-workflow is started b) When one sub-workflow finishes c) When all sub-workflows are in state finished Verificat (...)

(...) l to users from item list? I think it will be nice to have this option directly in "Send a custom email" action configuration". For now you have to use intermediate solution to get users list using SQL /CAML querry.

(...) Adding possibility to add SQL row as a column could be also a workaround to achieve that. Right now (BPS 2020...434) is is only possible to add instance number from system fields to mass notifications.

(...) ts/post/using-calculated-columns/196/3) but that's not my case. What I would like to do is join the items from the report to a table in a different database (on the same server) or to an existing MSSQL data source. In many processes I have a global field with the unique identifier. I would like to use this key for a 1:1 join. I can show the join results on the form (using Data row field type) but n (...)

(...) Hello everyone, did someone update the database compatibility level from the default 'SQL Server 2008 (100)' to a newer one and can share their experience? I really would like to make use of those "new" functions instead of using hard to read workarounds. Best regards, Daniel