I am using PEGA OOTB AttachAFile local action from one assignment in my case type. Once I upload the ,attachment ,I can see the attachment in Recentcontent section of the case . I can download it too .
But when I query pc_data_workattach table(via one Report defination ) with my case's pzinskey ,I am seeing the corresponding record gets added into the table where pyattachstream values is blank but other values (pxAttachName,.pxCreateDateTime) having proper data .
Can any one please tell me why ,pyattachstream values is coming as blank ? I am able to see pyattachstream value for some other case types in the table.
My end goal is to ---Take the pyattachstream and pass it to external API in JSON
I am on PEGA 8.4.3.
***Edited by Moderator: Pooja Gadige to update product version, add platform capability tags***
For the affected attachments, can you open the attachment from the user portal or is the attachment broken?
In my mind, if the property value is very large the clipboard viewer and tracer may not show it even if it is there. If the attachment always opens in the user portal, the attachment content is safely stored somewhere.
Also, are all of your case types in the same application? Attachments for some applications may be stored in the Pega DB, whilst other applications on the same cluster may store attachments in Web Storage or a Repository. In this scenario, some Data-WorkAttach-File instances will have pyAttachStream populated for the Pega DB attachments, whilst those stored in Web Storage & Repository attachments will have a blank pyAttachStream. In the case of the latter, another property holds the path to the attachment content in the remote storage.