Skip to main content
Solved

IFS User Pictures

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.

View original
Chanu_Yazi
1 person likes this
  • Chanu_Yazi
    Chanu_Yazi
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

dhlelk
Superhero
Forum|alt.badge.img+15
  • dhlelk
  • Superhero
  • 200 replies
  • 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
2 people like this
  • Chathuranga Samarakoon
    Chathuranga Samarakoon
  • Dumeesha Wanigarathna
    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
1 person likes this
  • X
    Xavier Fernando
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings