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

Best pratice for DoR Looping Rule to determine if DoR is new

Accepted answer
22
Views
2
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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