Calculated Column in Report (V2025)

0

Hi, try to use wfelems.wfd_id instead of WFD_ID

You need to use wfelems.WFD_ID because WFD_ID alone isn’t recognized inside the subquery.
At that level, SQL doesn’t know which table the column belongs to.

By adding the alias wfelems (which i think refers to the V_WFElements view in the main query), SQL can correctly link both tables.
So the correct version is:

(
SELECT
dbo.ClearWFElemAdv(DET_Att3)
FROM WFElementDetails
WHERE DET_WFCONID = 9579
AND DET_WFDID = wfelems.WFD_ID
AND dbo.ClearWFElemID(DET_Att1) = 1
)

Hi,
In previous versions, WFD_ID alone worked (unless you have the WFElements table included in this subquery). Is there any change in this regard in version 2025?

And just remember that DET_WFCONID will be different for DEV/TEST/PROD environments (you should probably use the GUID).

Hi Jacek,

good point!
How do I build in the GUID into the query?

Kind regards,
Klaus

you should add

INNER JOIN WFConfigurations ON WFCON_ID = DET_WFCONID
AND WFCON_Guid = 'xxxxxx-xxxxxx-xxxxxx-xxxxx-xxxxx'

Great! Thanks a lot!