NotesViewEntry.ColumnValues does not get all values from view index

HCL Domino Domino Forum
1

hello forum.

i have a view with 2 categorized colums, the first is an UNID which i am searching by “Set entry = view.GetEntryByKey(sUNID)”.

The second column is also categorized and displays a multiple field which i am manipulating by an formula “@ReplaceSubstring(myField;”\“; “$%$”)” because of the backslashes in the strings. This values i need to read by “Forall cc In entry.ColumnValues”.

So far so good, everything works fine but sometimes (always the same entries) i got less information back. In the (ui) view i can see much more entries but the ColumnValues object contains just 2 or 3 of the values. If i am deleting these entries i got another 2 ones but never all (maybe 20).

I read here at the forum that ColumnValues gets it’s information from the view index. So my question is, is there any limitation or something why some of the informations are not stored at the index (i know about the limitations of UI formulas and constants and yes, there are readers fields in the displayed documents but i think that doesn’t matter).

Thanks in advance for any suggestion…

2

Subject: NotesViewEntry.ColumnValues does not get all values from view index

In a viewentrycollection, multi-value fields don’t work the way you’d expect. You set a column to show multiple values as separate entries, and sure enough, you see the separate entries. But, when you run a script to cycle through the rows (NotesViewEntry), you won’t get the separate entries. You pretty much have to grab the doc from the entry and loop through the multi-values. It’s a pain.

3

Subject: RE: NotesViewEntry.ColumnValues does not get all values from view index

Hello Michael,

thank you for your answer.

I don’t think that the problem is the multi value because with other documents in that view it works great.

The Columnvalues element have all category strings in its array. Only some documents don’t … well, it looks like this that all my documents in my test database are working well but in the productive database it shows the described problem. Also when i’m copying these documents into my test database they show the same result …

Thanks anyway.

4

Subject: RE: NotesViewEntry.ColumnValues does not get all values from view index

A category row is an entry also. A category entry has no associated document, and only contains the values of the categories.

5

Subject: RE: NotesViewEntry.ColumnValues does not get all values from view index

Hello Andre,

i’m sorry but i don’t understand your post. What does that mean? The view shows every single field value in my multi field as a category in the view. But the viewentry object contains just some of the values i can see in the view in UI.

Thanks for any suggestion.