Saving images to the database.
Hello,
I have a case type where users submit details about an item (such as Item Name, Description, etc.). As part of the process, users can also upload an image of the item. The item details are saved as records in the Item database and displayed on a landing page.
However, I'm unsure what happens to the uploaded images. I found them under Image Content in the Records tab, but I cannot reference these images elsewhere in the application. For example, if I want to display an uploaded image in a section, these images are not accessible.
Could you guide me on how to save the uploaded image(s) to the database so they can be displayed on the landing page along with the other item details?
Thank you!
***Edited by Moderator Marije to add Capability tags***
HCA Healthcare
US
@AEE123 To effectively save and display uploaded images with item details on your landing page, follow these steps: First, decide whether to store images directly in the database as binary data (BLOB) or save them as files on your server and store their file paths in the database. Storing file paths is generally more efficient. When a user uploads an image, save the image file to a designated folder on your server and record the file path alongside other item details in your Item database. Ensure your database schema includes a field for the image path. When retrieving item records for the landing page, fetch the image path from the database and use it to set the src attribute of an HTML <img> tag, allowing the image to be displayed alongside the item’s name and description. Make sure your server is configured to serve the image files correctly and that the file paths are accessible by the web application. Additionally, validate and sanitize image uploads to maintain security. By linking the image paths with item records and properly referencing them in your frontend code, the uploaded images will be visible on the landing page with each item’s details. This approach ensures that images are easily manageable and display correctly within your application.
SkillStorm
US
@Sairohith Thank you for the detailed response! The explanation about storing images as file paths or binary data is helpful. However, my confusion lies in how to access the uploaded image from Pega.
When a user uploads an image via the case type, where is that image stored by default? How can I retrieve or reference that uploaded file within the application? For instance, how do I grab the file’s data or path so I can save it to the database or server for later use?
HCA Healthcare
US
@AEE123 When users upload images in a Pega case type, the images are typically stored as attachments linked to that specific case. By default, these attachments are saved within the case's record in the Pega database. To access and display these images on your landing page, follow these steps: First, ensure that your case type has an attachment section where images are uploaded. Then, create a property in your Item database to store the reference or URL of the uploaded image. Use a Pega activity or data transform to extract the attachment’s URL or binary data from the case record. This can be done by accessing the pzInsAttachments or similar property that holds attachment information. Once you have the image URL or path, save it to the corresponding property in your Item database. On your landing page, retrieve this image path from the database and use it in an HTML <img> tag’s src attribute to display the image alongside item details. Additionally, ensure that your Pega application has the necessary permissions and configurations to serve these images correctly. By linking the attachment references to your database records and properly referencing them in your UI, the uploaded images will be accessible and visible on your landing page. This method leverages Pega’s built-in attachment management while allowing seamless integration with your application's frontend display. Thank you