0
votes

I'm returning values from two different columns but will like to narrow down the results by using a key.

enter image description here

And below is my code which returns all. Efforts to use keys returns in mistypes.

var v:NotesView = database.getView("myView");
var key = getComponent("key").getValue();
var nav:NotesViewNavigator = v.createViewNavFromCategory(key);
//solved by replacing-v.createViewNav();
var entry:NotesViewEntry = nav.getFirst();
var list = new java.util.Vector(); 
while (entry != null) {
   var tabs:string = "";
   for (var i=0; i<entry.getIndentLevel(); i++) tabs = tabs + "\t";
   requestScope.status += "\n" + tabs + entry.getColumnValues().elementAt(entry.getIndentLevel()).toString();
list.addElement(entry.getColumnValues().elementAt(entry.getIndentLevel()).toString());
   var tmpentry:NotesViewEntry = nav.getNextCategory();
   entry.recycle();
   entry = tmpentry;
}
print(requestScope.status);
return list;

Will be pleased with your help.

Have you tried createViewNavFromCategory instead of createViewNav? - Sven Hasselbach
That worked. Thanks Sven. - Samuel Omopariola