16.4 Displaying BLOB Column Images
Display images from a URL or BLOB column in common APEX regions, with a special approach for Interactive Grid.
All regions can display images using a URL, but many can display images
directly from a BLOB column including: Form, Cards, Classic Report,
Interactive Report, Template Component, and Search. Showing a
graphic in an Interactive Grid requires an <img> HTML tag
whose src attribute references the URL of the graphic to display.
- Showing BLOB Column Images on Cards
Configure a Cards region to display uploaded photos from a BLOB column with captions and preview links. - Previewing Image in a Form Region
To preview an image from a BLOB image column, use a Form region based on the table or view that includes it, or use a SQL query that selects it. - Displaying BLOB Images in Classic Reports
In a Classic Report region, include the size of the BLOB in your query instead of the BLOB column itself. - Using BLOB Images in Interactive Reports
In an Interactive Report region, include the size of the BLOB in your query instead of the BLOB column itself. - Including BLOB Images in Content Row
In a Content Row Template Component region, choose a table or view that includes the BLOB image column. - Viewing BLOB Images in Search Results
When creating a Search page, base your related Search Configuration on table or view including the BLOB image column. - Showing BLOB Images in Interactive Grid
An Interactive Grid has no native Display Image column type. To show an image in a row, use an HTML<img>tag with asrcURL the browser can fetch and render inline. - Using BLOB Column Image URLs Anywhere
While the Interactive Grid requires it, use your preferred image URL generation approach anywhere that supports an image URL.
Parent topic: Uploading, Viewing, and Downloading Files