I am trying to get type ahead working on an xpage from another database, this is what i am entering into the server side javascript computed action for suggestions. This view has only 1 colomn and is located in the applications folder.
Any help is greatly appreciated
var dbname1 = new Array(“”,“Applications\Vendors.nsf”)
@DbColumn(dbname1, “PickList”, 0)
Subject: There’s no column “0” for @DbColumn…
Like their Formula language twins, @DbColumn and @DbLookup start counting from 1, not from 0. So to access a list of values from your first column you would enter
@DbColumn(dbname1, “Picklist”, 1)
Apart from that, everything looks fine in your script.
Subject: 64kb limit
Mind that you may have tha 64kb limit using the dbcolum. I saw somewhere in internet something like@DbLookup(dbname, view , getComponent(“ebUserSelection”).getValue() ,1, “[PARTIALMATCH]”);
}
where “ebUserSelection” is the field with the type-ahead enabled
I’m trying to use this approac but the dblookup seems to be “Slow”…
Subject: same problem
Does this work for you now if you change it to a 1? I’m having the same issue.
Subject: Work Around for 64kb limitation
As Type Ahead making field slower, make first field ComboBox and it’s values (A, B, C, D … Z). Use the DbLookup in Second Field based on your selection in first field. Do not forget to Select Partial Refresh onchange event on 1st field and choose second field id.