Fast Formula - Global Absence Array Type Index issue

Summary

Fast Formula - Global Absence Array Type Index issue

Content

Dear Expert,

I need to get exact index for ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR dbi for my logic,

 

This is the case:

Employee put 10 records in absence type.

I need to get Duration is greater than 4 entries of above put 10 records.

Example array type fast formula code:

l_absence_type_id=300000008142737

k=1 

   

   CHANGE_CONTEXTS(START_DATE = l_start_date, END_DATE = IV_PLANENROLLMENTENDDATE, PERSON_ID = l_person_id)

   (

 

WHILE ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR.exists(k) 

LOOP

(

 

CHANGE_CONTEXTS (ABSENCE_ENTRY_ID = ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR[k], START_DATE = l_start_date, END_DATE = IV_PLANENROLLMENTENDDATE,PERSON_ID = l_person_id)