Hello friends i am having trouble with displaying an image on my Interactive Report. I have my images saved as application components so i am getting them from the APEX_WORKSPACE_STATIC_FILES, however i dont understand what to give to the query as the source of my column.
Ive made the column type display image and ive given it the expected rows
However when i launch the page it says NO_DATA_FOUND, I dont understand what to select in my query as that row so that it shows the image. right now i have
'<img src="'||APEX_UTIL.GET_BLOB_FILE_SRC('P21_BLOB', 86684938405421089)||'" />'
Where P21_BLOB is a page item that is selecting the FILE_CONTENT column from my APEX_WORKSPACE_STATIC_FILES table.
Any experienced users can help me figure out what im doing wrong here?
Im working on oracle apex 22.2