How to get DFF value from Employee Profile in Worksheet column using Fast formula

Summary

I am trying to fetch value from DFF created in newly added content section using base template as Work Preferences

Content

I am trying to get DFF value from employee profile in Worksheet column using below fast formula.

The DFF value gets stored in table HRT_profile_items : columns : HRT_PROFILE_ITEMS_ATTRIBUTE_NUMBER1 , HRT_PROFILE_ITEMS_ATTRIBUTE_NUMBER2, HRT_PROFILE_ITEMS_ATTRIBUTE_NUMBER3.

But no luck, I am new to Fast formula.

This is the Content section I have added in Employee Profile under profile type: Person 

 

Version

21B

Code Snippet

Fast formula:

DEFAULT_DATA_VALUE FOR HRT_PROFILE_ITEMS_ATTRIBUTE_NUMBER1 is 0
DEFAULT_DATA_VALUE FOR HRT_PROFILE_ITEMS_SECTION_ID IS 0
DEFAULT_DATA_VALUE FOR HRT_PROFILE_ITEM_CONTENT_TYPE_ID IS ' '
DEFAULT_DATA_VALUE FOR HRT_PROFILE_ITEM_PROFILE_ID IS ' '



L_CP = 0 
l_code_index = HRT_PROFILE_ITEMS_SECTION_ID.FIRST(-1)
l_code_count = HRT_PROFILE_ITEMS_SECTION_ID.COUNT

L_COUNT = 0

WHILE (L_COUNT <= l_code_count)

LOOP
(
 L_COUNT = L_COUNT + 1
IF ( HRT_PROFILE_ITEM_CONTENT_TYPE_ID[L_COUNT] = '117' AND HRT_PROFILE_ITEM_PROFILE_ID[L_COUNT] = 'ProfileID_of_an_Employee' AND HRT_PROFILE_ITEMS_SECTION_ID[L_COUNT] = 'some_SectionID') THEN 

  (
   L_CP = HRT_PROFILE_ITEMS_ATTRIBUTE_NUMBER1[L_COUNT]

   EXIT  
  )

)

RETURN L_CP