latest posts

It works! Thank you so much

Hey,
Try out to wrap Your query into rounded brackets:
(SQL Query here)
Remember to select TOP 1 row, or wrap multiple values into STRING_AGG(..) :)

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 already connected to the WEBCON database.
I tried using a query like this:

SELECT Value
FROM [serverX].[Mydatabase].[table]
JOIN [serverY].[WEBCONdatabase].[dbo].[WFElements]
ON key = WFD_AttInt1

However, the report fails with a generic error:
“Failed with an unknown exception… Error during saga execution…”
Even simpler SELECTs against the linked server don’t seem to work in calculated columns.

My questions:
Are linked servers / cross-server queries supported in calculated columns in reports?
Is there any limitation on JOINs or external data sources in this context?
How do you usually handle cases where report data needs to come from another database/server?

Any advice or best practices would be greatly appreciated.
Thanks in advance!

Hi Damian,
I've encountered the issue, although went with the boring educate the users way.
After a bit of a time no technical solution was needed, leaving a comment though, as i'm interested in solutions made by others if there are any :)

I already asked a similar question regarding a signature field.
I updated the Word template because old references broke it apparently, then and then it worked.

I now have a multi-line advanced text field with settings and editor.
I tried to add in word as rich text field control with and without Business rule / only text field value.

Should I try to create the word again until it works ?
Or is it just not possible to take the format of the text over into the word-file?

Best regards
Phil

I added an example!
The has green text colour and grey background in the online editor.
The format is taken over !

Hi,

I'm experiencing an issue with selection attributes.

If a user types a value but doesn’t explicitly confirm the selection, the value still appears in the field after saving the form or moving along the workflow path. However, the problem is that the value change rules are not triggered in this case, which often results in the form not being populated correctly.

Has anyone encountered this behavior or found a reliable workaround?

SQL

Is there any conflict in the Placeholder prop? In the attachment, SQL from WFStepFormFields.

No, just one instance, mssql installed exclusively for webcon. :(
The thing that bothers me is the two different numbers of versions - GDR 15.0.2165.1(15.0.4465.0) - maybe Webcon installer uses the incorrect one thinking it is not the right one?

Hi,

I have a problem with the form.

I get this message when I break inheritance on a step. I can't fix it. It affects the order of attributes, and I can't change their settings. Has anyone had a similar problem? Version ver. 2025.2.1.321