Attribute - view items

0

Hi Piotr,
Do you want to insert a calculated column in the report?
If yes, try this:
(SELECT ISNULL(WFD_AttChoose5, STRING_AGG (CAST(DET_Att1 AS NVARCHAR(MAX)), ';')) FROM WFElementDetails WD WHERE WD.DET_WFDID = wfelems.WFD_ID)

What type of error do you have?

Hi Jack,
yes i do.
I'm trying to insert a calculated column in the report.
Your solustion is almost good.
I modified your suggestion by adding the function dbo.ClearWFElem(value) but it doesn't work properly.
It 'clears' only the first item, the others no longer for example:

PV-SP-325-35B-M-0000;365ecad5-2183-46c9-a31f-daff14099705#ES-PY-BMS-SC1000

I Want to remove all characters before #
Do you have any ideas?

Hi,
please try: dbo.ClearWFElemADV()

Regards