XPages View Filtering

HCL Domino Domino Forum
1

I have a question regrading the searching of a view control on an XPage.

I have a view with 10 columns and I want to give the user an option to filter on each of those 10 columns. (Examples of columns would be: department, cost center, homeowner/renter, initiation date range, last name).

From what I have read the best way to do this would be using the fulltext search. I was hoping there was a way to do this without fulltext indexing databases. This is on our extranet, and we have about 50 clients, each with their own database. Fulltexting these would take up a lot of space, and I just want to know if that is truly my only or best option.

And of course, search speed is a factor.

Currently we are using a “TDC Object” with JavaScrit, which is limited only to IE, or we use a C#.net/XML external application. I was hoping with the upgrade to Notes 8.5 we could stop supporting the C# and TDC object and keep everything within lotus.

Thanks for any questions or comments.

AWL

2

Subject: javascript solution

You can display the view using a javascript based grid available in dojo (enhanced data grid) or DHMLD grid. Both support column filtering and would be much faster than a server based solution.

However, this might not make sense if the number of records are not too large.

thx. Rakesh

3

Subject: Examples

Do you know where I can find some examples of this? I am going to do some searching, but you could point me in the right direction that would be great.

It seems like the built in dojo toolkit might work, just need to see it in action.

Thanks.

4

Subject: 'Fraid so.

FTSearch is the only way once your dbs get beyond a certain size (Depends, but I’d turn it on >30Mb). Disk space is cheap. Backup space can be expensive, but you don’t have to backup the index directories.