latest posts

Hi
I’m working on the same issue. How can I solve this error without generating the document directly in HTML and converting it to PDF?

.

Hi,

maybe there’s something I’m missing but I would use an item list with the columns and something like „Metadata“ for the first column which is not editable. I would then start with a fixed initialization.

Maybe the metadata column would be a choose field so that you can use the id instead of relying on the name/row number.

Best regards,
Daniel

Hi,
How can I create a form in WEBCON BPS Designer Studio with four columns: field name, current value from an SQL table, new value to be entered,description for the entry?
Just like in the screenshot. I need to display the current value to the user, and the user should be able to enter a new one.

I have a single line text field as a technical field that I set to describe specific status e.g. Approved / Denied
English is set as the original language within the business rule that sets me the field along the way.
I use this technical field within our dashboards but it always defaults to English no matter what I do,.
The path gets triggered by a subworkflow.

If I the author myself go on the path the translation is ok but if I manage it through the sub-worflow from a superior for example.. it defaults to the English texts the entire time within the dashboard ?

How can I stop this?

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 !