I know that the SSJS version @DbColumn()has the same 64k limitation as the original version of the Formula language. Therefore, so far I have used NotesView.getColumnValues(), believing that here I would not encounter such a restriction.
Which is obviously wrong, as it calls an urgent support request yesterday, as well as this crash report from IBM.
The code used is used to populate the selectItems control in a comboBox; opening a page with comboBox hosting causes the HTTP server task to crash, and then, ultimately, the entire server:
<xp:selectItems>
<xp:this.value><![CDATA[#{javascript:database.getView("vwInvBySupplier").getColumnValues(0);}]]>
</xp:this.value>
</xp:selectItems>
This is a view of all category entries from the view. I use combo as a dynamic category filter for the presentation displayed on the same page.
What alternatives exist to get a complete list of all category entries from a view, even if the extracted data exceeds 64k?
Sidenotes:
I fully understand that displaying more than 2,000 entries in comboBox may not be a convincing usability concept for some, but the client likes to see all available entries in one place, and then be able to select from this list. At the very least, a standard solution with a viewing panel full of categories, twists and the need to go through multiple pages is not a solution.
The application runs on Domino 9.0.1, WinSrv 2008 / 64k
source
share