You are here: Portals > Case Manager portal > Case attachments

Case attachments

An attachment identifies a file, screen shot image, scanned document, URL, or text note that a user or activity associates with a case.

You can also configure your application to access and store case attachments in external CMIS repositories and web storage providers.

By default, attachments are stored as rows of the pc_data_workattach table. Attachments are not stored in the same database table as the cases.

Attachment storage

When a user designates a file as an attachment, the system uploads a copy of the file and links it to the history of the work item. The system saves attachments for correspondence in HTML format (.htm file type) even if a user edited the correspondence with Microsoft Word. If the correspondence includes embedded images or other embedded objects, the attachment is saved as a .zip archive containing the objects and the .htm file. The system converts the .zip file internally into characters using Base64 encoding.

If a user accesses the Pega 7 Platform server with the HTTPS protocol (rather than HTTP), this may block certain download operations from the server to the workstation. For details and suggestions, see PDN article Troubleshooting: "Internet Explorer cannot download messages" (Tomcat with SSL).

Optionally, you can choose to store file attachments for an application in an external content management system such as Alfresco. This capability requires the optional Pega-Connect ruleset.

Attachment versioning

File attachments are normally a permanent read-only part of the history of a work item. However, in some applications, you can edit and update the attached file (using Windows workstation software), creating a higher-numbered version of the file attachment. The application retains all versions, in sequence. You can edit the description of a new version to add a number or other distinguishing information.

For example, a photograph stored as a .jpg file might be difficult to interpret or might contain extraneous material. When rules have the appropriate configuration, you can open and manipulate the .jpg file (using Windows imaging software) to crop, filter, or annotate the image. Pega 7 Platform retains the original unaltered file as the first edition and the updated file as the second edition.

Similarly, you can edit a project plan file with Microsoft Project, or revise a Microsoft Word document, and so on.

The standard flow action Work-.EditAttachment supports opening and editing file attachments.

Virus checking

Files received from any source might contain computer viruses. You can connect your application's processing of work item attachments to an external virus-checking module. Virus checking occurs before the system saves the attachment to the database. Override the standard extension point activity Data-WorkAttach-File.CallVirusCheck to call the checker and modify processing by the flow to handle files reported to contain viruses. The virus check module can be a Java routine or (when Pega 7 Platform is hosted on Microsoft Windows) in a Windows DLL file.

Limits

While the number of attachments you can add to a work item is unlimited, the standard list view rule  Link-Attachment.AttachmentList.ALL displays only up to 100 attachments. You can override this rule if necessary.

The description text (Subject field) of a file attachment is limited to 60 characters.

By default, file attachments are restricted to 1 gigabyte in size. You can set a larger or smaller limit with the prconfig.xml file setting:

<env name="Initialization/MaximumFileUploadSizeMB" value="nn" />

where nn is the size in megabytes.

Note: As an alternative to updating the prconfig.xml file, you can use Dynamic System Settings to configure your application. See Prconfig settings and classifications.

Attachments and search results

If the Index Attachments check box is selected in the Search tab of the System landing page (Designer Studio> System > Settings > Search), a search of work items in a composite User portal can include searching the contents of text-file attachments for a specified word or text string. See Understanding full-text search.

Conversion of Microsoft Word document to PDF format

Pega 7 Platform provides two approaches to convert Microsoft Word documents to Portable Document Formats (PDFs). For each approach, the original .doc or .docx file and the converted PDF file become two file attachments, typically of separate categories.

To convert in the foreground, include the standard flow action .Work-.ConvertAttachmenttoPDF as a local flow action in appropriate assignments in the flow. You must select this flow action, complete the form, and wait for workstation conversion.

Attachment reference properties

You can use the standard page list properties pyAttachments and pyAttachmentCategories to reference all attachments or by category. When a the system or the user adds an attachment, the system automatically populates both properties and associates them with the case.