Skip to Main Content
Feature Request FR-4145
Product Area APIs
Status CLOSED

7 Voters

APEX_UTIL.GET_BLOB_FILE_SRC - No Page Item Required

aschultz Public · Dec 11 2024

Idea Summary
APEX_UTIL.GET_BLOB_FILE_SRC is great for getting the URLs for blobs in tables.  Where it falls short is when you want to get that image from a different app or display an image dynamically.  Your choices then become:

  1. Add an arbitrary page so you can add a page item to use APEX_UTIL.GET_BLOB_FILE_SRC
     
  2. Create an Application Process and do something like this:  https://joelkallman.blogspot.com/2014/03/yet-another-post-how-to-link-to.html
     

Use Case

When you have a suite of APEX apps that share sessions and/or have subscriptions for shared components:

  1. One of the apps is for managing a user profile and is where a user can upload an image of themselves.  You want to use that profile image in the navigation bar for all apps
     
  2. You want to display logos dynamically because many different organizations/teams use the same application
     

Preferred Solution (Optional)

  1. I propose we add another signature to APEX_UTIL.GET_BLOB_FILE_SRC that can accept a query string to query a table directly
     
  2. Another option would be to add another signature to APEX_UTIL.GET_BLOB_FILE_SRC that accepts a table name, column name, and primary key
We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • vincent morneau Admin OP 8 days ago

    I too, would have wanted this many years ago. However now with all the new ways of displaying images in reports, template components, display image item, etc., it seems like this API is less needed, so it was decided that we can't prioritize this idea.

  • aschultz OP 8 days ago

    Thank you for the feedback Vincent.  I appreciate the consideration.