View Column Headers Fixed Using XPages

Question

I need one help related to view panel column headers. I am using view panel to pull the data from SQL using JDBC Connection manager and displaying in view panel control using Xpages. I am displaying 500 rows at a time and when users trying to scroll the data the column headers are going scrolling up. So, now I need to fix all view column header should be fixed when the rows are scrolling up/down. Can anybody help me regarding this?

Answer 1

You can add that capability to an existing viewPanel with the jQuery.Thead plugin. There are only 2 steps involved:

• Download the library and add it to your XPage/ application.
• Activate the plugin for your viewPanel (or repeat):

x$("#{id:viewPanel1}").floatThead({});

(the x$ function comes from the ExtLib Bootstrap theme)

I've put together a small demo here:

http://bootstrap4xpages.com/bs4xp/demos.nsf/fixedHeaders.xsp

Answer 2

May be have a look at DataTables, for details to implement this in XPages see the blogs ofOliver Busse, http://oliverbusse.notesx.net/hp.nsf/blogpost.xsp?documentId=D5E

Answer 3

The easiest way will be to add viewStyle to your viewPanel and set it to 100%.

I hope this helps!