I was trying to read a multi-valued column set to “show mulivalues as seperate entries”, and I’ve not figured out how to get it to show the correct multivalue at the correct point in the view. It seems to always return the first entry.
The docs say that this will not work in a categorized view in the instances below, implying that it WILL work in other instances. I’m using GetNextEntry to iterate.
Has anyone seen this work? The field I’m trying to read is not a category, it’s just a field set to show multivalues as separate entries.
From the docs:
Duplicate entries
Duplicate entries exist when a document is categorized under multiple categories. Navigating over duplicate entries works except in the following situations:
GetNthEntry method returns the first ViewEntry instance for the document.
GetEntry method returns the first ViewEntry instance for the document if the document is not part of this collection.
DeleteEntry method deletes the first instance. You can delete multiple instances with multiple calls to this method.
George, I see the same problem in Both R5.0.12 and R6.5.4. Did you ever find a solution?
I have seen very strange things with this view entry stuff. I first used AllEntries. R5 only returned 6 entries when I know there are 7 and R6 retured 7. However, like you, I see that if I have a sorted column (not categorized) Notes will step through the list and continually return the first value in the multi-value field rather than the one shown in the view.
Are multi-value fields in viewentries just messed up or something? It took some doing but when I switched to GetAllEntriesByKey and made another view with “*” in the first column, as suggeted in another thread, that got me 7 entries in R5.
Maybe this doesn’t work in your situation, but if you don’t think of it so much as a classic DBLookup (e.g. a table with multiple values per row), you can turn off “show multiple values as separate entries” and then change the code to iterate through NotesViewEntry objects and, for each, to iterate through one or more values contained in NotesViewEntry.ColumnValues(0).
The result, for me at least, is the same, although the view may not be as useful for other purposes.
I believe that I am encountering the same problem in a java agent that is accessing view entries in a view entry collection for a view whose first column (that is sorted) has “show multiple values as separate entries” checked.
Is there any update with regards to this issue. I’m unable to locate SPR DCOE5Z7VQA.
Yes, I believe its the notes bug. It cannot pick the exact one if the sorted column has multi value shown with the separated entries. even though, we still can get the correct entry amount through the getallentriesbykey class. we can find each document by the notes entry. and loop the target column to find the needed one.Hope this helps.
George, I see the same problem in Both R5.0.12 and R6.5.4. Did you ever find a solution?
I have seen very strange things with this view entry stuff. I first used AllEntries. R5 only returned 6 entries when I know there are 7 and R6 retured 7. However, like you, I see that if I have a sorted column (not categorized) Notes will step through the list and continually return the first value in the multi-value field rather than the one shown in the view.
Are multi-value fields in viewentries just messed up or something? It took some doing but when I switched to GetAllEntriesByKey and made another view with “*” in the first column, as suggeted in another thread, that got me 7 entries in R5.
