List Attachments in a report?!

0

Hi,
You can use a calculated column and create a subquery to the WFDataAttachmets table where you have the attachment details.

Hei, thanks!!

This works fine so far! My SQL looks like this for a column type "Text"

(
SELECT STRING_AGG(A.ATT_Name, ', ')
FROM WFDataAttachmets A
WHERE A.ATT_WFDID = WFD_ID
)

It would be great to add a link to each attachment. I tried this, but i can not find the URL to the attachment in the Databse.

any idea if this is possible

Remember to add the condition ATT_IsDeleted = 0 to the SELECT (otherwise, you'll also see deleted attachments).

As for the link, you can try fiddling with /api/nav/db/1/attachments/xxxx/preview?hash=0 where xxxx is the ATT_ID.

Hello,

It is much easier if you use the "SearchIndex Source" for the report Source. This way you get the attachments in the System columns (see attached image).

Cheers,
Martin

Hei Martin,

thanks, thats it :-D

Regards, Gerd

Hi Martin,
Good point. I completely forgot about that :-)
Regards,
Jacek