0

I have SharePoint list with more than 100K items. Due to list view threshold, I am not able to create views and display required items via any OOTB solution. As an another option, I am planning to go with any custom JavaScript based solution to display items on a grid. Can anyone please suggest which are best javascript based grids available in market who can also give features like filtering/searching/sorting of items?

  • Shad: Did you expand the list view's threshold on web application's setting? After doing that, we can create view with about 1000 items each page. – trantab Dec 7 '15 at 2:27
  • jquery datatable could be an option. – user13408 Dec 7 '15 at 4:07
  • Have you tried creating view with limited columns or say filtered view. That should work on OOTB. – Gaurravs Dec 7 '15 at 4:59
  • Hi All, Thanks for your replies. JohnThomas - Unfortunately we are not allowed to change default threshold limit. Gaurravs - As minimum records we are expecting will be more than 5000. So even limited columns option will not work as it won't allow to create view in first place. – Pratik Shah Dec 14 '15 at 0:39
0

You can use JQGrid or also datatables as suggested above. JQGrid is a grid plugin for the JQuery Javascript library. It is free, open source and gets distributed under the MIT license.

1) Works fine under IE, Firefox, Chrome, Safari, Opera.

2) CSS customizable.

3) The UI comes in 20+ languages.

4) Paging and sorting

5) Search and filtering

6) In-place cell editing or on-the-fly form creation to edit a record

7) Supports subgrids and tree grid for displaying hierarchical data

8) AJAX enabled

9) Accepts XML/JSON/local array data sources

You may refer to following links for its information,

http://jqgrid.com/

http://www.trirand.com/blog/jqgrid/jqgrid.html

  • jqgrid worked. We also tried Ng grid. We are planning to go with that. – Pratik Shah Dec 14 '15 at 0:41
0

You can try Kendo IU Grid by Telerik. It's simple to use and contains filter, search and sort options. But I think the problem will be to get list data from SharePoint.

  • Thanks. We are looking for any free option first. In case if we could not achieve required functionality then only we may explore any paid third party solution. – Pratik Shah Dec 14 '15 at 0:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.