Appending two NotesDocumentCollections

This tip was submitted to the SearchDomino.com tip library by member Michael Adams. Please let others know how useful it is via the rating scale at the end of the tip. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.

Here is some simple LotusScript to append two NotesDocumentCollections together.

Regarding the tip about adding two notesdocument collections, in the while loop there should be a statement to leave the while-loop as soon as a document has been found. it is purely unnecessary and inefficient to keep looping through the collection while it has already been decided the document should not be added to the collection.

The code snippet states:

The code snippet should s

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT LotusScript LotusScript sorts lists alphabetically LotusScript code rebuilds corrupted busytime.nsf file Soft-code item names to facilitate LotusScript management LotusScript agent automates selective mail file replication LotusScript filters and attaches files to a Notes form How to create mail files using a LotusScript agent Extract value pairs from text arrays with LotusScript Mass-input form uses LotusScript to ease large-scale employee moves LotusScript button updates email addresses in Lotus Notes PAB Code exports Lotus Notes data to an OpenOffice Calc spreadsheet LotusScript LotusScript sorts lists alphabetically Run or restart Notes/Domino agents via text messages LotusScript code rebuilds corrupted busytime.nsf file Soft-code item names to facilitate LotusScript management LotusScript agent automates selective mail file replication Can I create and copy Microsoft Excel spreadsheets with LotusScript? LotusScript filters and attaches files to a Notes form How to create mail files using a LotusScript agent Can you use LotusScript to read a text file attached to a Notes doc? Extract value pairs from text arrays with LotusScript

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

tate:
—Oscar H.

******************************************

1. The described method is not very practical: you can use this method only for very small collections. If the first collection contains N documents and the second contains M, the described algorithm needs N*M to perform the task. Just imagine, to append two relatively small collections, N=1000, M=1000, the algorithm will perform 1000000 steps!

2. In some cases the algorithm even won't work. For instance, when col1 and col2 are results of NotesView.GetAllDocumentsByKey from the different views, AddDocument will fail.

3. The internal loop is unnecessary: in case the document is already contained by collection NotesDocumentCollection..AddDocument raises an exception. The code can trap it and continue to the next line.
—Aleksei S.