how to handle 5000 limit in large list queries sharepoint 2013.

We have approved proposals that will quickly go beyond 5000. Now we do want user to see data beyond 5k in a grid in paged manner. But if I give query that brings beyond 5k and page it will it

Hi Amit

Check out these Articles it might be helpful for you

Manage lists and libraries with many items

Techniques for managing large lists

Thanks

Thanks Ankit.

But I need exact details on how to handle approved proposals in a grid where approved proposals itself go beyond 5k(for example 12000 approved proposals in a list). Now how to bring this data and show it in a grid?

I can not limit 12k to only show 5k approved. I want user to see 12k approved proposals using pagination in grid. I also do not want to change list threshold limit from 5k to more because this 12k will increase to

Hi,

You may use Get Data table and Merge Table using https://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splist.getdatatable(v=office.14).aspx 

also you can use Paging Info for merge table https://msdn.microsoft.com/EN-US/library/office/microsoft.sharepoint.splistitemcollectionposition.paginginfo.aspx