Skip to main content

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?

Hi @cancevikoglu,

 

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.

@cancevikoglu You can combine below tales to get the  IFS users picture details.

SELECT * FROM person_info_tab;

SELECT * FROM binary_object_tab;

person_info_tab.picture_id = binary_object_tab.blob_id

Terms & ConditionsCookie settings