Is it possible to display a picture (with SQL binary data) into the user's general information panel?
If yes what is the way to make it?
Thank a lot by advance.
I know an easier way, you can upload the user images into "Admin > User Interface > Files > Images"
Then create an IDC (maybe csv file) that maps UserIDs to HTML code that loads these images.
The URL of UI photos is something like this: https://<server_fqdn>:<server_port>/aveksa/custom/images/
So you can embed this URL into an HTML code as below:
<html><img src="https://10.148.248.17:44314/aveksa/custom/images/User1.jpg" alt="User1" style="width:96px;height:120px;"></html>
Meaning in the end you can create a CSV file that looks like the attached sample, have an IDC to collect from it into a new string custom attribute.
Let me know if this is helpful or not so clear.
Thanks for you answer .
Thanks Mostafa Helmy, your answer gave me an idea that I applied.
In Oracle SQL database collector:
Transform the binary data like this (by exemple):
select [...], '<img src="data:image/gif;base64,' || utl_raw.cast_to_varchar2(UTL_ENCODE.BASE64_ENCODE(col)) || 'alt="Base64 encoded image" width="150" height="150"/>' as URL from table
alt="Base64 encoded image" width="150" height="150"/>
Result in user's general profile:
Next modify the formatting .
Nice trick I guess the only limitation here would be the size of the user attribute as it will not be able to hold a large picture unless your create a custom user attribute with a very large size.
Retrieving data ...