Skip to main content
Solved

IFS User Pictures

  • May 24, 2021
  • 2 replies
  • 239 views
C
Do Gooder
Forum|alt.badge.img+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?

Best answer by dhlelk

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.

Ragaventhan Sathananda
tahir.ali
This topic has been closed for replies.

2 replies

dhlelk
Superhero
Forum|alt.badge.img+15
  • dhlelk
  • Superhero
  • Answer
  • May 24, 2021

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
Dumeesha Wanigarathna
Chathuranga Samarakoon
Hero (Partner)
Forum|alt.badge.img+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
X
Terms & ConditionsCookie settingsAccessibility statement