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.
Best pratice for DoR Looping Rule to determine if DoR is new
Summary:
Customer: Deutsche Bahn AG
Use Case: 89
Content:
What is best practice when looping through a rowset of all DoR to check if a DoR of a type exists for the person:
Option 1: Combine all required criteria in one condition group in the same if statement eg
For each row
if Person ID matches AND Doc Type AND Doc ID matches
...
Option 2: Have one criteria per if clause/ add an if statement per criteria
For each row
if Person ID matches
If Doc Type matches
if Doc ID matches
...
(see also below)
Reason for asking: Ensuring best possible performance of rule
0