Portal reports: Process columns from multiple worflows?

0

Hi Flo,

since the column WFD_AttText1 could be the title in one process and in another a Comment, it typically doesn't make sense to do this.
The only exception from this is global fields, but these should have the same meaning across all processes they would be selectable.

For your use case though you could add calculated columns.
For example if you want to display a description column and it's stored in difference database column for different form types (processes) you could use the following formula:

(case when WFD_DTYPEID = 29 then WFD_AttLong1
when WFD_DTYPEID = 39 then WFD_AttLong2
else null end)

Remark:
Since we use the integer form type id here a transport would fail. I have some hopes that this won't be a problem in BPS 2023 any more.

Best regards,
Daniel

Hey Daniel,
that worked.
Thanks as always!