search results

(...) External content by Sébastien Anselment, September, 2025;  MS Fabric is a powerful platform containing data table s in the Microsoft OneLake. This article describes how to integrate a MS Fabric lakehouse via its SQL analysis endpoint. First you have to set up once the necessary Entra application registration and the WEBCON MSSQL database connection to the lakehouse SQL analysis endpoint. Then (...)

Applies to version: 2026.1.x and above; author: Grzegorz Straś   Related documentation A detailed description of the functionalities mentioned herein and their configuration can be found in the following sections of the WEBCON Help: Administration tools Diagnostic sessions Diagnostics Services configuration Other related Community articles include: OpenTelemetr

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

(...) xt there are all columns of the excecution statistics of the cycle And last all columns of the cycle itself To get this table accessible in the portal one can create a process with a data table field associated to this MSSQL data source. Go to the Workflow Designer and just delete all paths, the end step and the phases execution and end. Put this global formrule in the behavior tab of the M (...)

Hi everyone, is someone here how understands power query? I got a task to retrieve data from a BPS report in excel to use it for additional analysis. I was able to retrieve the data but transforming the json response to a table is beyond me. Just in case there's someone who would be able to do it but doesn't know how to retrieve the data I add the logic below which can be put into the advanced

Does anyone know if it's possible to show data not present in an application on the report? I have read the article about calculated columns (https://community.webcon.com/posts/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 p

It would be great if there would be a "Usages" options for BPS groups like it exists for the most other objects like Rules, Fields, Action Template, Data sources and so on. I'm already using two workaround 1) I created a constant for each bps group so that I can use this constant wherever possible. Unfortunately there are some cases where this is not possible. For example in a "Person or group"

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

Hello, I am using an itemlist to show some data to the user. In some cases, the list contains over 50 elements. Because it also has a lot of columns, it is very hard to follow sometimes. I would like to at least make the table header sticky. How can I do that? Thank you in advance! Best regards, George

Hi everyone, I just noticed that for some reason step names are no longer displayed in reports or data grids using internal views. The root cause of this is that I used the REST Designer Studio. When you save a process using the REST designer studio unset translation of changed objects are saved as a blank string instead of null. This may lead to empty Step and Form Type columns in reports and ot

(...) 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 allow a little (...)

(...) Hi, Do you know how to make rows in a 'data table ' field colorful? I get some data from subworkflows by the table field and I want to color some rows depending on their status: open - blue, closed-green ... Is there such posibility?

Dear Webcon Community! Problem: with import excel action you can import excel tables only if you have a table container already added. Sometimes it is difficult if we want to process data in excel table coming from third party. Proposal: there is a way to define column mapping for itemlist file importing. It would be nice to have a feature in import action to take into account that one,

(...) 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 formats. I' (...)

(...) Hi folks, We have a Word File with three data table s from Webcon in there, which will be generated and converted to PDF, then put into the attachments. The thing I have struggled to figure out until now is, how to hide or not show a table when the corresponding data table in Webcon is empty. I know that it is possible to use Business Rules in there, but again none which use parameters. Is there a (...)

Hi, it is posible to export data from item list to Excel in action but only id from column value? Only way i found is map item list to excel table (Sheet1!Table1). In this way the whole (id and name) of column is exported. But I want only id or name.

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

Is it possible to create at the finish stage word file using data from WFHistoryElements table? Where should I store data regarding stages, time of the stages and person details assign to this stage to be able to used them in document template?

(...) Hi, I have an item list with a "date" column. I figured out that filtering (or even showing it in a customized date format in a data table ) is tricky as the daty type of the column is actually nvarchar(1000). What I want to reach is to filter the data table based on a "date picker" field, but I don't manage to. Kind regards, Klaus