search results

Applies to version: 2026 R1 and above; author: Adrian Baszak, Lily Adamowicz   Related documentation A detailed description of the functionalities mentioned herein and their configuration can be found in the following sections of the WEBCON Help: AI Agent AI Implementation Guide Other related Community articles include: AI Agents – Business

​  Applies to version: 2026 R1; author: Łukasz Maciaszkiewicz, Lily Adamowicz   Related documentation A detailed description of the functionality regarding versions 2023 R1 to 2025: OpenTelemetry in WEBCON BPS   Introduction In the present-day dynamic and distributed application environments data monitoring and analysis are key to ensure high effic

 External content by Sébastien Anselment, March, 2026 In workflow's global actions one can add automations that get executed "on start (cyclical)". It's hard to keep an overview of all workflows with such automations through all application groups, applications, processes and workflows. To get an overview one can create an MSSQL data query with the current database

Hi all, i hope you are well. We have moved our PROD-Environments Databases to a different SQL Server last night. Except from some annoying trouble with Sharepoint and the Webcon solutions we managed to get everything running smoothly again. We uninstalled everything except from SOLR, and installed it again. The old databases are offline. Currently there is still an alias configured, that rout

We are implementing a solution of Master Data Management and are trying to use Webcon as a User interface with all the logic behind forms. The database is prepared in MS SQL with different tables. The challenge we are having is to update entries with foreing keys. Scenario: Table 1: Country has one column (apart from ID) – 'Country' Table 2: City has two columns 'Country ID' (Choice column from t

Dear all, what would be the best practice to update/change the Business Entity of an instance? Background: I would like to create an application containing people related to a company respective business entity. Over the time it is possible they would change the company and so also the business entity. I found a dirty way by using an SQL Update directly on the WFElements table, but I am struggl

Hi there, I have a data source of MSSQL type, that populates a data table. The SQL query is quite complicated but it works. However it currently takes about 33 seconds to complete. Thus when executed in SQL Studio, I get the output table. When I try to execute it in a bps process, it fails. When testing in Designer Studio, I get an error of execution timeout. Is there a way to tell Webcon to allo

Based on Daniel post https://daniels-notes.de/posts/2021/retrieve-ps-variable-value I figure, it is posible to retrive output value from SQL Procedure? How force "Run sql procedure" action to log ouptut to [dbo].[WFLogs] table? Write-Output in PowerShell is logged to LOG_Description column. How log ouput from sql procedure?

Hello, after playing around with the answers in the former thread I think it may be helpful for others to present my approach here. If anybody wants to reply to improve it, I will be grateful to learn. 1) Requirement Within a process a group of users is requested to deliver an approval by two different members from within the group. Also it shall be possible to change the process to two per

Hi, I have a following problem. I've created a data table form field that downloads data from SQL query. In that SQL query I have a following where clause, which compares a date from Oracle table to a date from a form field that is completed by an user (it is "user's date"): "where table1.date = User's date: date acc. browser settings(text)" and it doesn't work because of different date f

Hi all! I personally think the operator 'ForEach' is a great addition to version 2022.1.2.31, thanks to Webcon Team. Unfortunately I do not find any documentation on that, especially how to iterate over 'Any Collection' and access columns in custom action. If I select 'Any collection' and put some SQL statement in there, is there a way to access specific table columns from generated tabl

Hi all! We want to add some rows to an item list with 'Change item lists values' action. The SQL query should take a JSON array (which is perfectly valid) from UI element and return a table for adding new rows to this item list. Unfortunately this does not work. There seems to be some parsing on Webcon side, which eliminates all elements in the JSON array, apart from the separator, which

Hello, I have the following scenario: - Webconapps - Data Sources > Connections > MSSQL Database > Azure_SQL: I have server name, database, user and password filled. When I click Test, I get "OK" so Webcon can connect to the database. However, when I try to create a MSSQL database Data Source and chose the above connection, I get the following error: "Unknown error: The SELECT permission

(...) I've got following fields: 1. Choice field with connection to MS sql table - name of the supplier. 2. Text fields like address, postal code filled based on the value chosen in choice field from point 1. 3. Another choice field with bank account numbers - another MS sql table filter by ID value from choice field in point 1. Two qestions: 1. By clicking 'x' in supplier name choice field I'd like to re (...)

Hello all, Does anyone configured an action where the value in a specific column for an item list is a value coming from a datasource different than MS sql server? My idea is, I need to get from an oracle table the rate for a specific employee, so I'm using the action with Datasource = my table and in the advanced filter, I just add the person id and the dates for comparison but this is not

Hi all, I was wondering what the best practice is when using SQL queries in Webcon with attributes, tables or views that have different names in different environments. One example is the views. These are automatically generated by Webcon and the name is combined from the process name and the process ID. The process ID is of course always different in the three different environments. This

Hello, Do you know how can i find what query is exactly executed when i'm using raports in WEBCON. What SQL SELECT is inside, I knew that i can find it some where in the console(debug mode) F12, but I can't find it right now. Or there is some database table with this ?

Hello, I have a question, a curiosity... In the WFDataAttachmets table, there is a column called ATT_IsDeleted. If I want to Run SQL procedure (webcon action) and update table and set the ATT_IsDeleted column with 1 or 0. Is it a good practice? Or is it not allowed? Thanks.

Hi, I have a following problem. I've created a data table form field that downloads data from SQL query. In the where clause, I refer to the value of another ‘Criterion’ field on the form. The data table should display the data depending on the selected criterion. Unfortunately as I change the criterion, the table sometimes fails to refresh and displays the data for the previous criterion. How

Hi everyone, Jarosław created a threat in which he points out that elements are no longer rendered if they are used in an item list data row column.: https://community.webcon.com/forum/thread/5247 I tested the most common/likely elements and to verify which are supported by using this SQL query: select 'a tag' + ''+ 'button tag' + ''+ 'div tag' + ''+ '' + ''+ 'img tag' + ''+ 'input