Navigating thru a Long View on the Web

Have you ever tried to page thru an exteremly long view on the web. The following allows you to easily navigate thru a view alphabetically.
Form properties: Select - Generate HTLM for all fields
Add a computed text field: DBCol
x := @DbColumn(""; ""; "(lu" + @Subset(@ViewTitle; 1) + ")"; 1);
@LowerCase(@If(@IsError(x); ""; @Implode(x)))
Add a computed text field: Path
"/" + @ReplaceSubstring(@ReplaceSubstring(@Subset(@DbName; -1); ""; "/");" "; "+")
Add a computed field: ViewTitle
@ReplaceSubstring(@Subset(@ViewTitle; 1); " "; "+")
Add the following text to the top of the page. You can use images, but they take more time to load.

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W| X | Y | Z

Create Javascript Hotspots over each letter:

// letter represents the first letter you navigate to in a view
var letter = "a"

in the JSHeader :
function navigation(letter)
{var a = document.forms[0].DBCol.value.toLowerCase();
var b = a.indexOf(letter);
var vt = document.forms[0].ViewTitle.value;
var dbpath = document.forms[0].Path.value;
case -1:
alert("There are no entries beginning with the letter " + letter + ".");
location=dbpath + "/" + vt +"?OpenView&StartKey=" + letter + "&Count=1000&ExpandView";

Next, create a copy of the view you need to navigate thru. In this example, the view I'm navigating thru is called DOCUMENTS. The new view should be named (luDOCUMENTS). The first column should be sorted & categorized with the following formula: @Left(columnformulahere; 1). Delete all other columns.

This formula will return a sorted & categorized view that contains only the first letter of the entry and is used by the DBCol formula above.

Dig Deeper on Lotus Notes Domino Administration Tools

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...