2 thoughts on “Use @Transform to build JSON and consume the output in an XAgent”
Setting NotesViewNavigator.VN_ENTRYOPT_NOCOLUMNVALUES as an entry option is not a good idea in this case. This lets the ViewNavigator only read a few ViewEntry properties and no column values. But in your loop, you read the column values via entry.getColumnValues(), which leads to another server transaction to fetch that missing data.
Setting nav.setEntryOptions(NotesViewNavigator.VN_ENTRYOPT_NOCOUNTDATA) should produce a better performance.
Setting NotesViewNavigator.VN_ENTRYOPT_NOCOLUMNVALUES as an entry option is not a good idea in this case. This lets the ViewNavigator only read a few ViewEntry properties and no column values. But in your loop, you read the column values via entry.getColumnValues(), which leads to another server transaction to fetch that missing data.
Setting nav.setEntryOptions(NotesViewNavigator.VN_ENTRYOPT_NOCOUNTDATA) should produce a better performance.
Thx, Karsten. Updated the snippet