Is there any way to replace the @Dblookup in order to work on the Web?
The function in @DBLookup is basically the same as what you would get with either a NotesView.GetDocumentByKey or a NotesDatabase.Search. The GetDocumentByKey method implies that you have a handle to a NotesView. If you have a view that you know contains the document you are seeking, and you have a key (a must) to that document, and the first sorted column contains that key, then you can get a NotesDocument object in LotusScript via the GetDocumentByKey method. If the document doesn't exist in a view that you can get a handle to or you do not know the key to it (i.e. the first sorted column), you could use a NotesDatabase.Search method. It uses a common @Formula Selection formula to find a NotesDocumentCollection. For example, you could get a collection like this:
Set MyCollection = MyDb.Search( StartDate, "Select status = ?archive'")
Either of those functions would perform much like @DBLookup. NotesDatabase.Search is far more flexible, but FAR more server intensive. If you can use NotesView.GetDocumentByKey then definitely use that that method.
Dig Deeper on Domino Resources - Part 2
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.