You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Question
13
Views
0
Comments
edited Aug 20, 2021 12:37PM in Performance Management

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 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!