I don't think "everyone" knows the Tigerstyle demo, but thanks for the tip of the hat.

Your idea will work, but you should bear in mind that the ViewEntries will be recycled between pages. So you're going to have to come up with a wrapper that can handle request-safe retrieval of the underlying Notes object.

For the record, Tigerstyle does do full-text searches. The search term box isn't showing up right now for some reason I don't have time to troubleshoot, but the code is all in there and I've done about 100 different searches in testing. Works like a charm. It's pretty cool to to an FT search, AND apply a column filter, and still resort the results by yet-another column.

the recycling is not a problem yet... what I'm still needs to nail down is if the HTTP server frees up memory automatically, or if I need to recycle the notesViewEntry by myself like in pure Java.

In my earlier tests with other algorithms the HTTP eat up lots of memory, and didn't free it after the request was completed.

I posted one method for sorting the results of a FT search and displaying it in a repeat control of an XPage. I don't claim that it's the best or most efficient method but it worked for my purposes.

{ Link }

Ernie, thanks for the link! Yes, that's a possible solution, too.

I tested a similar approach, but in my case it took too long to compute and needed too much memory.

Not sure if you follow my blog..?

If not, here's my best attempt (so far) on the issue of sortable search results.

{ Link }

The search interface itself in the demo is crappy, so please ignore that, and take a look at the (messy) code that powers the Data Table (if you're interested). I'm really happy with the sorting/pagination performance.

Tommy,

yes, I follow your blog and I saw your post... I already made a comment to it, but for whatever reason the comment is lost.

I think your idea for sorting is a good one, too!

Nevertheless does IBM have to come up with a general solution so that we can spare the workarounds :-)

I've opened up the comment system now, so hopefully I'll get more input on my weird experiments. :)

Hi Julian,

thank you for sharing your solution with us. But for the Beginner it is very difficult to understand.

maybe you could put your solution in a small sample database.

That would be a great Help.

Thanks

Sezgin

Hi Sezgin,

sorry, I don't have time to provide a sample db in near future.

hwta became the code for this:

- get the NotesView

- do a ftsearch on the NotesView

- get the NotesViewEntryCollection of the already searched view

- loop over all NotesViewEntry elements of the collection (which has max 5000 entries)

- add each NotesViewEntry to a java.util.TreeMap with an entry's column value as the key

- return the values of the TreeMap to a repeat control.

Hi Julian,

we had the same problem. But in our case the views are not too large (< 1000) and so I decided to do the sorting on the client via JavaScript (paging must be disabled)

I found a scriptlib that I adopted a little, and I think it works very well (at a table with mutltiple columns and img sorting is very fast).

You just have to add a class="sortable"

Here is the code:

function initSortableView(viewPanelId) {

//alert("viewPanelId=" + viewPanelId);

sortables_init();

}

/*

Table sorting script by Joost de Valk, check it out at { Link }

Based on a script from { Link }

Distributed under the MIT license: { Link } .

Copyright (c) 1997-2007 Stuart Langridge, Joost de Valk.

Version 1.5.7

*/

/* You can change these values */

var image_path = "/domjava/xsp/theme/common/images/";

var image_up = "sort_both_ascending.gif";

var image_down = "sort_both_descending.gif";

var image_none = "sort_none.gif";

var europeandate = true;

var alternate_row_colors = true;

/* Don't change anything below this unless you know what you're doing */

// addEvent(window, "load", sortables_init);

var SORT_COLUMN_INDEX;

var thead = false;

function sortables_init() {

// Find all tables with class sortable and make them sortable

if (!document.getElementsByTagName) return;

tbls = document.getElementsByTagName("table");

for (ti=0;ti<tbls.length;ti++) {

thisTbl = tbls[ti];

if (((' '+thisTbl.className+' ').indexOf("sortable") != -1) && (thisTbl.id)) {

ts_makeSortable(thisTbl);

}

}

}

function ts_makeSortable(t) {

if (t.rows && t.rows.length > 0) {

if (t.tHead && t.tHead.rows.length > 0) {

var firstRow = t.tHead.rows[t.tHead.rows.length-1];

thead = true;

} else {

var firstRow = t.rows[0];

}

}

if (!firstRow) return;

// We have a first row: assume it's the header, and make its contents clickable links

for (var i=0;i<firstRow.cells.length;i++) {

var cell = firstRow.cells;