Question

5
Replies
4549
Views
Kensho Tsuchihashi (KenshoTsuchihashi)
PEGA
Project Delivery Leader
Pegasystems Inc.
JP
KenshoTsuchihashi Member since 2010 141 posts
PEGA
Posted: April 18, 2018
Last activity: April 24, 2018
Posted: 18 Apr 2018 3:41 EDT
Last activity: 24 Apr 2018 21:36 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.