Unable to display more than 100 rows in the datatable
Unable to display more than 100 rows in the datatable
audrine
Posts: 4Questions: 1Answers: 1
Hello,
I am fetching odata which has more than 200 records. But when the datatable is generated only 100 rows are displayed. I believe this is a default setting but I am unable to change it to display all the records. This is what I have tried so far.
"bPaginate": true,
"lengthMenu": [[250, 300, 500, -1], [250, 300, 500, "All"]],
"blengthChange": true,
"iDisplayLength": 200,
"iDisplayStart": 200,
I would really appreciate any help I can get. Thanks
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Just an update on some research I did on this issue for anyone trying to fetch oData and populate in the dataTables. I have oData from 2 sources Sharepoint Lists and Project server oData. By default odata allows retrieval of 100 records at a time. You can overcome this in the list api using $top however it doesn't seem to work for Project server oData.
Thanks for posting back with your findings. I'm sure others will find this useful!
Regards,
Allan