Skip to Main Content
HCL Domino Ideas Portal

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

Status Under Consideration
Workspace Domino Designer
Categories @Formulas
Created by Guest
Created on Oct 8, 2020

Add a keyword to @DbLookup to continue past non-matching keys

If you call @DbLookup with a list of keys, the lookup will stop after the first non-matching key. I would like it to keep going and process the rest of the keys in the list.

For example, say you want the entries for the months February, March, August and September, but August happens to have no entries. If you try to do this using a single @DbLookup (e.g. with the key field set to "February":"March":"August":"September"), the call will succeed but the entries for September won't be retrieved.

Assuming you even notice the problem, unless you have a way of knowing in advance which months have no entries, your only recourse is to make a separate @DbLookup for each month instead. Adding a keyword would also help to clarify the documentation, which doesn't make the current behavior clear.

  • Attach files
  • Guest
    Reply
    |
    Oct 9, 2020

    This would be a great improvement but it needs an option to enable.