Fast Formula - Global Absence Entry Validation - GET_VALUE_SET Formula — Cloud Customer Connect
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

Fast Formula - Global Absence Entry Validation - GET_VALUE_SET Formula

edited Mar 5, 2020 1:12PM in Workforce Management 8 comments

Summary

GET_VALUE_SET Formula

Content

Hi,

 

I want to create a fast formula controls that if a worker has an absence type A, this worker shouldn't get any absence. To do so I created this fast formula:

 

 

l_person_id = GET_CONTEXT( PERSON_ID,0)
l_absence_type_id = GET_CONTEXT( ABSENCE_TYPE_ID,0)

 

l_person_id_char =to_char(l_person_id)

L_absence_type_id_char = to_Char(l_absence_type_id)

 

L_PARAM ='|=PERSON_ID='||l_person_id_char||'|=ASSIGNMENT_ID='||L_absence_type_id_char

 

L_RETURN_VALUE = GET_VALUE_SET('

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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