search results

(...) Hi, is there a way to update two fields in the info panel, shown in the screenshot below ? I'm running a 'Start workflow(SQL )' action and it seems that I can only overwite the author, but that still wouldn't work because values is not obtained thorugh SQL , but applied.

(...) tion. Warning: Null value is eliminated by an aggregate or other SET operation. Warning: Null value is eliminated by an aggregate or other SET operation. Category: OLAP Role: OLAP Microsoft.Data.SQL Client.SQL Exception (0x80131904): Arithmetic overflow error converting expression to data type int. Arithmetic overflow error converting expression to data type int. The statement has been terminate (...)

(...) next one with 15.01.2026 … and so on, all with the same data as the parent workflow, just different dates. Is that possible in WEBCON BPS? Do you have an idea how to implement this (maybe with SQL )? Thanks!

(...) Hi, is it possible, to use the action 'mergeattachment' not only for attachments in ONE form but also in DIFFERENT forms? If not, is it possible via SQL ? In the attached picture there is a screenshot of the following SQL -query of the webcon-database: select ATF_WFDID, ATF_OrginalName, ATF_OrginalValueHash from dbo.WFAttachmentFiles where ATF_WFDID > 9620 how can I export the word-docs a (...)

(...) 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. Unfortu (...)

(...) Quite often we have the use case, that we need to provide a personalized dataset. With SQL data sources we do have the possibility to use calculated fields with a subquery. Which could end up with performance issues when using large datasets. As an example this calculated column returns 1 if the first letter of the COS_ExtensionAttribute05 field in the COS table matches the value of the dataset. The (...)

(...) g to the instructions "WEBCON BPS standalone installation" (windows 2025 and updates, .NET Framework 4.7.2, installed automatically with the system, ASP.NET Core Runtime 8.0 Windows Hosting Bundle, MSSQL 2019 with installed full-text search , Ms SQL Server Management Studio 20, IIS with Windows Authentication), also tried to fix using this thread -> https://community.webcon.com/forum/thread/1042 . (...)

(...) is to set up a third environment (TEST), align it with PROD, and then perform the upgrade there. My question is: is it feasible to do this on a laptop/notebook with Windows Server, running a local SQL Server instance and WEBCON on IIS? Or are there any specific requirements or limitations I should be aware of? I’d like to do this without interfering with the existing database servers or current (...)

(...) ith a specific date and description directly in the Item list, and after saving, have this customer stored and visible in the same Item list for future instances. Can this be achieved using Run an SQL procedure, or is Item list intended only for displaying data and not for creating new workflow elements? Thanks in advance!

(...) me has now the translated value of the current user. Until 2025 this line logged always the Designer Studio name. as of 2026 it is the translated value for the executing user. logger.Log($"Adding SQL field'{SQL Field.DisplayName}' as placeholder"); This is causing us some troubles. We have a generic SDK which allows us to access all the fields of the workflow instances as placeholders. For exa (...)

(...) , które są czytelne. Reguły biznesowe i logika procesu – Reguły formularza, reguły ścieżek, walidacje. – Jak nadawać „inteligencję” workflowowi. Akcje w procesach – Najważniejsze typy akcji (SQL , startowanie innych obiegów, wysyłka maili, aktualizacja elementów). – Kiedy której używać. Źródła danych i słowniki – Zapytania SQL , listy danych, integracja z zewnętrznymi źródłami. – Jak uni (...)

(...) Data Source to be reused dynamically across multiple fields, Item Lists, and Business Rules, drastically reducing redundancy and improving maintainability. Example Use Case: Consider a recursive SQL query on a dictionary representing the organizational model. The goal is to retrieve information about parent OUs starting from a base OU. - Current approach: For each column you want to return (e.g (...)

(...) Hi, we are using version 2025.2.1.179. For a demonstration of a possible bug I've created a MSSQL data source with this query (the cat column can be ignored): SELECT 123 AS ref, 1 AS cat, 'EQU' AS country UNION ALL SELECT 123 AS ref, 2 AS cat, 'EQU' AS country UNION ALL SELECT 123 AS ref, 3 AS cat, 'EQU' AS country UNION ALL SELECT 567 AS ref, 1 AS cat, 'ESP' AS country UNION ALL SELEC (...)

(...) mplate. This is a special case to only load the columns configuration instead of the whole configuration In the case of switching the data source of a picker field (e.g. a department picker with MSSQL data source shall be replaced by a new REST Web Service data source) such a template would significantly simplify the migration. Not so nice but better than now: - Add an option to export an adva (...)

(...) Hi, short: Business rule text parameter string values only containing digits seem to get casted to an integer value in WEBCON. long: Declaring a VARCHAR variable in SQL as a string like '001' is returned as string. If 001 is replaced by a text parameter in between single quotes its value '001' turns to 1 as integer. I would expect that a string value '001' remains a string when using it as (...)

(...) ce there are no options to use business rules or similar in a data source filter of a choose field I'm preparing the filter value on step entry. This is sufficient for this case.. #With a standard SQL data source I would use one of these options. The hard coded values would be replaced by the field value. {COLUMN:ID#ID} in ('KHL_030','KHL_020') {COLUMN:ID#ID} in (select item from dbo.SplitToTabl (...)

(...) d as in processes. There is so much data in data sources we'd like to visualize, search, filter, ... on a dashboard. As a dev imagine a WEBCON monitoring dashboard that has lots of widgets with SQL data sources that show e.g. a mail log, login log, process log, error log, ... Kind regards Sébastien

(...) step and then go on to the next step. The mail is sent, but the system step does not go to the next step. (we have Webcon 2025.2.1.91) ("move workflow" is not available; only "move workflow (SQL )", but it is not possible to move the workflow you are in at the moment) (there is only one path after the system step and it es marked as default path) (the article covering system steps did not h (...)

(...) Hi, I have a MSSQL data source with a column newHash that get's created by HASHBYTES and VARCHAR(64) in the SQL query of the data source over some other columns to check if there is a value updated. This hash gets stored in the dictionary entry together with all other values. In the same query I also add the column with the diHash of the associated dictionary entry. When doing a daily sync betw (...)

(...) the task creation only on test. And if only on dev then the task on dev. Have you already found a way how to prevent a task creation on the "lower" environments? One first idea would having 3 MSSQL connections for all 3 environments. Then a MSSQL data source for each connection that gets process information, mainly the process GUID and then a business rule managing where this process GUID can b (...)