latest posts

Great! Thanks a lot!

you should add

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

Hi Jacek,

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

Kind regards,
Klaus

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

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, try to use wfelems.wfd_id instead of WFD_ID

Łukasz, thank you for explanation. Kind Regards, Ondrej

Hi everybody.

I'm trying to implement a calculated column into a report.
This is the Query:
(
SELECT
dbo.ClearWFElemAdv(DET_Att3)
FROM WFElementDetails
WHERE DET_WFCONID = 9579
AND DET_WFDID = WFD_ID
AND dbo.ClearWFElemID(DET_Att1) = 1
)

This column is empty. If I put in a value for WFD_ID, e.g. 52750 the column is filled with the correct Value (for item 52750).

What am I doing wrong?

Kind regards
Klaus

Hi,

it’s not an issue! We’re simply replacing the old Designer Studio–based audit view with our new and more powerful Analytics framework.

This change brings flexibility, and a much richer experience when analyzing workflow data in WEBCON BPS.

You can read more about this module here:
https://community.webcon.com/posts/post/data-analysis-in-webcon-bps/385/4

Best regards,
Łukasz

Hi Daniel,
After a longer search, I finally managed to find what I was looking for.

https://community.webcon.com/posts/post/tool-for-workflow-analysis/95/20#:~:text=A%20workflow%20audit%20is%20available,execute%20a%20more%20advanced%20analysis.&text=b)%20Display%20unique%20elements%20%E2%80%93%20this,actions%20executed%20on%20a%20path.

It was available in the 2022 version, but unfortunately, I can't find it in the 2025 version. In post is written, than: Applies to version: 2020.1.x and above; author: Paweł Drab

Does anyone know what might be the issue or where it could be located in version 2025?