Question
Tata Consultancy Services
IN
Last activity: 19 Oct 2017 11:21 EDT
Tracking of Case Attachment size
Attachments added to the pega case should be stored in PEGA_DATA.PC_DATA_WORKATTACH table, is there a way to track the attachment size with each of the case?
Pegasystems Inc.
IN
Hi Gagan,
There's no property in Data-Attach-File to track attachment size. Hence ,no exposed column in the PC_DATA_WORKATTACH that you can use
If you wanted some broad indication of whether an attachment was big or small, you could write connect-sql to use the native dbms/oracle function to look at length of pzpvstream. It won't tell you the attachment size but will give you some idea -- though keep in mind that we take attachments, base64 encode them to text, then zip our java object to create the pzpvstream column.
The below links may also help you:
https://pdn.pega.com/forums/prpc/performance/check-attachment-file-size-before-attempting-to-upload
Hi Gagan,
There's no property in Data-Attach-File to track attachment size. Hence ,no exposed column in the PC_DATA_WORKATTACH that you can use
If you wanted some broad indication of whether an attachment was big or small, you could write connect-sql to use the native dbms/oracle function to look at length of pzpvstream. It won't tell you the attachment size but will give you some idea -- though keep in mind that we take attachments, base64 encode them to text, then zip our java object to create the pzpvstream column.
The below links may also help you:
https://pdn.pega.com/forums/prpc/performance/check-attachment-file-size-before-attempting-to-upload
https://pdn.pega.com/forums/prpc/java-activities/get-the-size-of-a-file-on-the-client-side
Thanks,
Gisela