How to get view entries when multi value field are displayed as separeted entry

I have a view sorted on the first column that contains a multi value field and each value is shown as a separete entry.I need to read in LS each entry of the view and I need to get the value that is actually shown on the entry.

I tested with one document with two values in the first field and I see two entries in the view.

But with the following I always have the same value in my LS variables

Dim rap_v As NotesView

Dim rap_c As NotesViewEntryCollection

Dim r As NotesViewEntry

Dim rn As NotesViewEntry

Set rap_v = db.GetView(“($RapDayAg)”)

rKey = “04.06.2010”

Set rap_c = rap_v.GetAllEntriesByKey(rKey, False)

Set r = rap_c.GetFirstEntry

While Not r Is Nothing

var = r.ColumnValues(0)

If Isscalar(var) Then rDayAg = var Else rDayAg = var(0)

Set rn = rap_c.GetNextEntry(r)

If Not rn Is Nothing Then

var = rn.ColumnValues(0)

If Isscalar(var) Then rnDayAg = var Else rnDayAg = var(0)

MsgBox rDayAg + " " + rnDayAg

End if

Set r = rn

Wend

the variables rDayAg and rnDayAg show the same value while the two entries in the view show different value.

What am I doing wrong ?

Thx

Subject: I thought NotesViewNavigator was meant for this?..

Subject: Can I create a navigator by key with partial match?

The collection that I extract is based on a partial match as shown on my script code.I understood that I can create a navigator on a category.

Subject: From Lotus Support:… this is a known issue

This issue has been reported to Quality Engineering as SPR# CYII74LP9A. There are no plans to address this issue. It is not recommended that the NotesViewEntryCollection class be used in cases where the relative view is categorized,

or the case where a column makes use of the “Show multiple values as separate entries” property.