How to archive information about the folder a document came from along with the document

Answer

Not automatically, but through some customizing, you can add that capability.

To enable Lotus Notes to track folder references, the database must include two hidden views: "($FolderInfo)" and "($FolderRefInfo)". The standard Lotus Notes mail template already includes these two views. Although the template will come prepared for keeping folder references, databases are by default not enabled to track them. To enable a database to keep folder references, the following LotusScript routine must be run once:

NotesDatabase.folderReferencesEnabled = true

After a particular Notes database is enabled to track folder references, any newly arriving message will be added to its corresponding folder reference list. Normally, any note will only reside in a single folder. For example, any newly received mail will have a reference to the "($Inbox)" folder, and when dragged to another folder, this reference will be replaced by that of the new folder. This list of folder references can be retrieved from a document using the following LotusScript code:

NotesDocument.FolderReferences

By using this list, you can define a pre-archiving agent that will execute code to get a document's list of folder references and write them to an extra item in the document:

Dim folderRefs() as String

folderRefs = doc.FolderReferences
Call doc.ReplaceItemValue("MyFolderRef",folderRefs)
Call doc.Save(True,False)

This extra item can then be mapped in the CSLD Document Mapping, which will cause it to be stored as an attribute in the repository. Then it can be used during searches.

Further, by defining a post-retrieve agent, you can read the extra field from the restored note and move the document back to the folder it originally came from.