search results

Hi, ver. 2025.2.1.91 Is there any changes to CTE SQL availability when used as a Data Source? After the update from version. 2025.2.1.42 to 2025.2.1.91 we found that all functions using CTE from Data Sources stopped working. Strange - when you use CTE in the action config, it still works. Can you confirm whether it is a bug or not ? Error: Error in On path action Wgrywa nadgodzi

(...) cated a custom SQL query to split the long string into individual rows with email addresses. This approach seems to work when executed via SQL COMMAND, but it doesn't work when used directly in the MSsql database or the Item List initialization. Am I on the right track? Any idea what might be going wrong?

Hi, I'm writing this post to verify, that I didn't overlooked an option. Situation: I have a data table to get the data of subworkflows and the base 64 encoded values of their attached images. This data table is used to create a word document. The standard SQL connection uses the bps_user which neither can read data from a separate database nor is the user allowed to read the attachment fi

Hi to all. As a consultant who needs to dive regularly into the database using SQL I'm surprised that there is no physical data model diagram in the documentation. A visual representation of tables and their dependancies provides a very useful overview about how data is structured, maintained and related. In SQL server there is a option to add a new database diagram and thus my question: could Web

(...) in WEBCON BPS – it’s a much-needed and well-designed solution that all most meets our needs. Like many other organizations, we handle sensitive data that should not be stored in plain text in the sql database . To address this, we've developed a simple SDK-based customization of a form field that displays the field value on the form, but stores it in an encrypted format in the database. Unfortunately – (...)

Hi, I currently have two WEBCON environments (DEV and PROD) running on separate machines. Due to the fact that we’re still on an older version (2023 R3), I’d like to upgrade an environment to version 2026 for testing purposes — mainly to verify stability and estimate the effort required to adapt our solutions. My idea is to set up a third environment (TEST), align it with PROD, and then pe

Hi, I'm currently trying to figure out a way to filter a Custom data source with an "dynamic" filter. Here's a rough overview: #Custom data source I've created an SDK of type data source which prepares the data #Filter I have a filter value which is dynamic for a given workflow instance. Here are two examples: {COLUMN:ID#ID} in ('KHL_030','KHL_020') {COLUMN:ID#ID} in ('KHL_001','KH

In a step, I configured an On timeout action that runs a SQL procedure (a very simple query that updates a field in another database) after 1 minute. However, occasionally—about 1–2 times out of 100—the field is not updated, even though in history shows that the action was executed successfully. An external process calls the WEBCON API using a specific path. On that path, a SQL procedure actio

Hi everyone, I’m running into an issue with calculated columns in a WEBCON BPS report and I’m wondering if anyone has faced something similar or found a workaround. I have a report based on some workflow, and I’m trying to add a calculated column that returns the value related to a given element in report. The value is stored in a table located on another SQL Server (linked server), which is alr