View Error: Entry Not Found in Index

Scenario:


A view used for lookup suddenly starts to throw the error "Entry not found in index", even though there are documents that match the lookup key and no change was made to the view's design.




Problem:


The view has the option "ODBC Access: generate unique key" active and there are Replication Conflict documents displayed on the view.

Solution:


Add this formula to the view's selection formula, to exclude the Replication Conflicts and the error will stop:  !@IsAvailable($Conflict)

Notes: SelectAll in an embedded view does not work

Problem:
When using the formula in an embedded view, no document is selected.

Solution:
Use a button with these formulas:

@Command([OpenView];"view_name");
@Command([ViewCollapseAll]);
@Command([ViewExpand]);
@Command([EditSelectAll]);
@Command([FileCloseWindow]);
@Command([ToolsRunMacro];"(dummy_agent_name)")

Posted on Notes Forum.

Notes: Document has not yet been saved error.

Scenario:

Embedded view on a form (or page) has an action button that invokes a LS agent to work on selected documents. This works fine in a regular view.

Problem:

This action button returns the error: "Document has not yet been saved".

Solution:

In embedded views, the LS needs to be in the action button.

Notes: View Entry's ColumnValues returns an array for a specific column

This will happen if the column's property "Show multiple values as selected entries" is selected.

In this case the ColumnValues property of the NotesViewEntry class, will return an Array and the common way of obtaining it's value will fail.

To access the entry's column value weather it's an array or not, use this:

Function getColValue (vCol As Variant) As String
If Isarray(vCol) Then
getColValue = Cstr(vCol(0))
Else
getColValue = Cstr(vCol)
End If
End Function

And then use it like this:

stringValue = getColValue(vwEntry.ColumnValues(1))

Notes: View doesn't refresh

Symptoms:

• permanently shows the Refresh Icon

• the "NoCache" parameter on the dblookup "doesn't work"

• the view.Refresh statement doesn't refresh the view

Problem:

The view probably uses @Now or @Today formulas in the Selection Formula or in a column, which prevents the view's index to be updated (it's always out-of-date as these formulas force the calculation to go to the minute:second detail).

Solution:

Use this formula instead: @TextToTime("Today") - it calculates only to the year-month-day so that the index only updates once a day.

Notes - Client: View autoframe

The view autoframe property only works for the Web, but for the client there's the following workaround (undocumented feature and only works for the database default frameset):

. Create a Frameset with only one Frame and call this Frame NotesView and select any view;
. In the database default Frameset, open the previously created Frameset in one of it's frames.

Now, when opening a view (through a link, for example), the database will force the default frameset to open "around" the view.

Notes - Web: document link in html view

"<a href=\"0/" +@Text(@DocumentUniqueID)+"\">" + field_name + “</a>”