Search code examples
lotus-noteslotusscriptagent

I have to get Lotus notes document by setting 2 combinations as unique

I have to pick a document in lotus notes Using vertical and country as unique. I have used below code which is showing error:

Set vcDoc = vcVw.GetDocumentByKey(empStubDoc.empVertical(0) & empStubDoc.empCountry(0))

My vertical form has following fields;

Vertical, Vertical Head, vertical HR SPOC, Country

Please let me know how can i do that if there is any alternative.

Solution

  • You are using the variable vcVw to refer to a view. The first view column of this view must contain the exact combination of the fields Vertical and Country and be sorted in order for you to be able to use GetDocumentByKey() with the values empStubDoc.empVertical(0) & empStubDoc.empCountry(0) as lookup key.