Hi

 

I am trying to filter a view control using a column value using a value held elsewhere.  It is multiple keys but will not display the view entries.  I have entered the expected result of my code as the keys and it works.  When left to the code it does not work.  Here is the code which I know returns the correct keys.  I have looked through different forums and checked all the usual thing ( like the columns are sorted), But still it does not work.

 

Anyone have any ideas where I should look next?

 

Many thanks in advance

 

Matt

 

 var database = session.getDatabase(@DbName()[0], @DbName()[1]);
var profDoc:NotesDocument = database.getProfileDocument("DbProfile","");
var db = profDoc.getItemValue("CustomiserRepId");
var vw = "Custom";
var key = "XpageSouthRegions" ;

var lookup = @DbLookup( db, vw, key, 2,"[FailSilent]");
var array = new Array();
var tmpstr = lookup.valueOf();   
array = tmpstr.split("," );
var qstring;

for( var i = 0; i < array.length; i++ ){
    if (i == 0){
        qstring = "'"+array[i]+"'";
    }else{
        qstring = qstring+",'"+array[i]+"'";
    }
}    

return qstring.toString()