Solved

IFS User Pictures

  • 24 May 2021
  • 2 replies
  • 198 views
C
Rank
Userlevel 2
Badge +2

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?

icon

Best answer by dhlelk 24 May 2021, 07:30

View original
This topic has been closed for comments

2 replies

dhlelk
Rank
Userlevel 6
Badge +15

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.

https://www.linkedin.com/in/kludl/
Chathuranga Samarakoon
Rank
Userlevel 6
Badge +12

@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

Chathuranga Samarakoon
Terms & ConditionsCookie settings