In Lotus script, how can I extract values dectectly from the view rather than using doc.fieldname(0)?

HCL Domino Domino Forum
1

In Lotus script, how can I extract values dectectly from the view rather than using doc.fieldname(0).If I know the row and column how can I get the value without refering to the fieldname.

I’m sure I’ve done this before but I can’t see how I did it.

Thanks

Bob

2

Subject: In Lotus script, how can I extract values dectectly from the view rather than using doc.fieldname(0)?

The direct answer to your question, as well as the most efficient solution, is to use the NoteViewEntry class, which reads data from the view index already cached in memory rather than accessing the doc note from disk.

3

Subject: That is not entirely true. you can access doc.ColumnValues(x). As long as you do not reference…

any fields, the document is not opened.

4

Subject: RE: That is not entirely true. you can access doc.ColumnValues(x). As long as you do not reference…

That makes sense when you think about it; just instantiating the doc from getnextdoc or whatever shouldn’t necessitate touching the doc on disk until, as you say, you access an item (or property) of that doc. Cool.

5

Subject: In Lotus script, how can I extract values dectectly from the view rather than using doc.fieldname(0)?

If you pulled the doc from a view, then you can use the COLUMNVALUES property on the NotesDocument.

doc.columnvalues(0) = first column data in view

doc.columnvalues(1) = 2nd column

doc.columnvalues(2) = 3rd column

…etc

6

Subject: And remember that Hidden columns are included in the list.

7

Subject: Check out NotesView class

It contains:

NotesViewColumn, NotesViewEntry, NotesViewEntryCollection, and NotesViewNavigator