LO86070: XPAGES: DBLOOKUP RETURNS NULL IF FIELD HAS NULL VALUE

APAR status

• Closed as fixed if next.

Error description

• Customer creates a Xpages application that uses @DbLookup for
  the values of combo box.
  
  If even one of the target field has null value, @DbLookup always
  returns null.
  This issue occurs on Xpage only, on Notes client this issue is
  not reproduced.
  
  Steps to reproduce:
  1. Create a Form that has two fields (one is the key field, and
  the other is the target field for @DbLookup)
  2. Create a View that has two columns (one displays the key
  field and sorted, and the other displays the target field)
  3. Create some documents
  4. Create a document that the key field has value but the target
  field has null
  5. Create a Xpage, and put a combo box control
  6. Set @DbLookup for values of the combo box
  
  var result = @Unique( @DbLookup( "", "View", "keyfield",
  "targetfield", "[FAILSILENT]" ) )
   if( result == "" ){ return "nothing"; }else{ return result; }
  
  7. Access to this Xpage via Web Browser
  
  You can see the @DbLookup returns nothing if one of the target
  field has null value.
  

Local fix

Problem summary

• This APAR is closed as FIN. We have deferred the fix to a
   future release.
  

Problem conclusion

Temporary fix

Comments

• This APAR is associated with SPR# MNAA9ZG5DA.
  This APAR is closed as FIN. We have deferred the fix to a
   future release.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R900 PSN

     UP