Question

5
Replies
4072
Views
Close popover
Kensho Tsuchihashi (TSUCK)
PEGA
Project Delivery Leader
Pegasystems Inc.
JP
TSUCK Member since 2010 126 posts
PEGA
Posted: April 18, 2018
Last activity: April 24, 2018
Closed
Solved

How to get attachments file size

Hi,

There is a field called "pyFileSize" in Data-WorkAttach-File class which I guess was planned to be built to hold the file size. However, unfortunately this property seems not to be used nor is there any functionality or API to obtain the file size.

Requirement is to get file size for all attachments and after much consideration I built an activity to call Oracle's DBMS_LOG package (GETLENGTH function) for pzPVStream column using CONNECT-SQL. However, the size is quite bigger than the actual size.. it varies but about 10%, sometimes more than 20%+. I need more accurate file size but how can I achieve this?

Please see attached for my code (DBMS_LOG package approach) and let me know if there is better approach.

Thanks,

Low-Code App Development
Moderation Team has archived post