Hi! I am struggling with getting images stored as blobs to display in an interactive grid. I know there are tons of posts on this but after looking at those I am still stuck. I specifically looked at Sample Database Application page 3 – Products and IG Cookbook v6 page 8 (Custom Row Height with Image).
Sample Database Application page 3 is an Interactive Report not a grid and IG Cookbook v6 page 8 is an interactive grid but with the images loaded as static images so none of these are exactly what I am trying to do.
Nevertheless I tried to re procedure what is done in these apps and I was able to get both of these examples working fine, I.e. dynamic blobs in a IR and static images in a IG but not dynamic BLOBs in a IG. This is what I did:
-
Created a new Form page (page 2003) on top of table DEMO\_PRODUCT\_INFO. This created a
P2003_PRODUCT_IMAGE item that already had file browse so I did not make any
changes to this item or anything else on the page
2. Created a new IR page with the following query:
a. select
apex_util.get_blob_file_src('P2003_PRODUCT_IMAGE',p.product_id)
image_hidden,
null
image_display
from
demo_product_info p
b. In the IR region in column image_display I added the following under Column
Formatting - HTML Expression (column type = Plain Text): <image
src='#IMAGE_HIDDEN#' width=75 height=75>
c. The image appers as expected in the IR report
3. Added a IG region to the same page with the following query:
a. select
apex_util.get_blob_file_src('P2003_PRODUCT_IMAGE',p.product_id)
image_hidden,
null
image_display,
'biz_user_yellow_bx_128x128.png'
image
from
demo_product_info p
b. In column image_display I made the type HTML Expression and under settings I added
the following under HTML Expressions: <image src='#IMAGE_HIDDEN#'
width=75 height=75>.
c. In column image I made the type HTML Expression and under settings I added the
following under HTML Expressions: <image
src='#IMAGE_PREFIX#menu/&IMAGE.' width=75 height=75>.
d. Column image_display shows a regular missing image icon while column Image shows the
static image (this was to show that I could do the example from IG Cookbook v6
page 8)
In both the IR and IG regions I am showing the Image Hidden value although it is
exactly the same behavior if I hide these columns. I did however compare the
output from apex_util.get_blob_file_src and they are identical between the IR
and IG version. So it almost seems to me that column type Plain Text with HTML
Expression set under Column Formatting behaves differently than a IG column
type of HTML Expression with the HTML Expression set under Settings.
I am using APEX 20.1 on Oracle 19.5.
Appreciate any tips on what I am doing wrong.