Hello,
I want to get IFS Users Picture for an external app. PERSON_INFO_TAB has a column named PICTURE_ID but i didn’t find a table which stores pictures. Can you help me?
Solved
IFS User Pictures
Best answer by dhlelk
Hi
Could you please try this?
SELECT t.data
FROM Binary_Object_Data_Block_TAB t
WHERE t.blob_id = <YOUR_PICTURE_ID_HERE>
;
Cheers !
Dhananjaya.
This topic has been closed for comments
+15Hi
Could you please try this?
SELECT t.data
FROM Binary_Object_Data_Block_TAB t
WHERE t.blob_id = <YOUR_PICTURE_ID_HERE>
;
Cheers !
Dhananjaya.
https://www.linkedin.com/in/kludl/
+12SELECT * FROM person_info_tab;
SELECT * FROM binary_object_tab;
person_info_tab.picture_id = binary_object_tab.blob_id
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.