05.05.2023
11:35
Hi.
I want to show in a report in a column if an item has an attachment.
Does anybody have an idea how to do that?
Kind regards,
Klaus
05.05.2023
16:33
Hi Klaus,
the easiest option would be to use a calculated column.
I have to variations for this:
1) Number of attachments
(select Count(*) from WFDataAttachmets where ATT_WFDID = WFD_ID)
2) Traffic light/indicator whether an attachment exists
(case when (select Count(*) from WFDataAttachmets where ATT_WFDID = WFD_ID) > 0 then 1 else 2 end)
Best regards,
Daniel
08.05.2023
09:27
