Any Visualforce Data Grid plugins?

Question

Any recommendations on grids that are richer than standard HTML tables?I need a data grid to list sObject rows and attribute columnd on a VF page under a Salesforce tab.

The attributes are a mix of string dates, URLs. On each row I want CRUD buttons to edit or delete records. Built in column sorting, filtering etc.

I've previously used WiceGrid for RoR and looking for anything equivalent for VF - https://github.com/leikind/wice_grid

Answer 1

While this is a javascript grid implementation as opposed to a visualforce one, I cannot speak highly enough about Slickgrid. It is flexible so you will be able to add buttons in each row and also extremely performant, capable of handling even hundreds of thousands of records.

It has the built-in column sorting and filtering you are looking for, in addition to many other features. Here is an example of slickgrid doing both of those things: http://mleibman.github.io/SlickGrid/examples/example-header-row.html

I have used slickgrid successfully many times and getting data into it can be as simple as hooking up a javascript remoting call that just returns query results on the apex side.

Answer 2

Its not quite a feature rich as some of your other options but we use a component called PageBlockTableEnhancer

https://github.com/Avinava/Visualforce-PageBlock-Table-Enhancer

The nicest thing we have found about it is that its super simple to setup just include the component on your page with a regular pageBlockTable and it adds pagination, column sorting, etc...

like this:

<c:PageBlockTableEnhancer targetPbTableIds="apps" paginate="true" defaultPageSize="100" pageSizeOptions="5,10,20,30,40,50,100"/>  

<apex:pageBlock title="{!grantRound.Name} Completed Applications">   
<apex:pageBlockTable value="{!applications}" var="a" id="apps"> 
<apex:column value="{!a.Title__c}"/> 
...

Answer 3

I just made my configurable Visualforce TableGrid component open source on Github.

It features:

• Native Salesforce.com Look And Feel
• Works as Standalone table grid or as an embedded replacement for Related List
• Works as replacement for Standard Lookup popups with
• Works for Standard and Custom SObjects
• Spreadsheet-like Cell-Editing
• Delete Muliple records
• Pagination with cutomizable page size
• Filter Builder UI to let users filter records
• Field Selection UI to let users customize columns
• Each user`s customizations can be auto-saved in a "database-cookie"

Feel free to use, share and improve ;-)

Answer 4

I also found a grid solution on the Developer Force Wiki that uses ParamQuery with JavaScript remoting. The page is titled, "Building Spreadsheets with Visualforce and Apex".

P.S. Thanks for starting this thread, as I'm about to dive into a project that requires a similar grid.