Hi
We recently changed the version of Webcon from 2020 to 2022 and I came across this problem.
In the report we used a calculated column to show comments:
(SELECT ISNULL (dbo.f_clear_description(wfelems.WFD_SIGNATURE), 'None'))
However, from what I can see in database, the comment format has changed and now when using this function I get an error:
"Invalid length parameter passed to the LEFT or SUBSTRING function."
In the attachment, I marked in green old comments, and those starting with [{ are new.
Old comments show up in the report and when I go to newer issues I get an error in the report.
Does anyone have a solution to make comments in the old and new format work?
Regards
Michael