Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Fetching Element Entry Values in Fast Formulas as of Specific Date
Content
Hello,
We'd like to fetch the element entry value for the 'Amount' input value as of a particular date.
For example, an employee has an entry for the element 'X' with the Amount input value as 100 in 01-Jan-21. From 01-Feb-21 onwards, the element entry was updated and the Amount set as 200. In an another fast formula, we'd like to retrieve the element entry information for 'X' as of 01-Jan-21, i.e. 100.
Our assumption was that we could write the fast formula code as below, but unfortunately that appears to fetch only the latest value (In the example, 200)
l_entry_val = 0<br />
CHANGE_CONTEXTS(EFFECTIVE_DATE = '2021/01/01' (date)) (<br />
l_entry_val = X_AMOUNT_ASG_ENTRY_VAL<br />
)
0