Hello Everyone, I am trying to filter some list items based on there modified dates. My list contains about 67 columns. My environment is Office 365 i.e. Emuparadise size dibawah 100 mbps internet. Hi, This happens to you because of 'List View threshold' exceed,But still I am able to retrieve the required rows based on optimized CAML Query, After increasing the your threshold, please follow to consider the steps, Here is some tips to work with large list, You have to optimize your CAML query with AND operator on Modified Date column [You must index the column 'Modified' as suggested by Mike and with RowLimit] to narrow down the records from the query.

Hi there I'm having some serious issues passing report parameters to a CAML query that's behind my reporting connecting to a SharePoint list. I have defined 2 report parameters (datetime type): Start_Date and End_Date.

Another example you can also split the list of items into logical chunk by creating the multiple Views and the use the View Name in the CAML Query to expect the better performance over list view threshold exceeded. And also I see that you are trying to querying the row based on the Date and Time with timestamp, from this example, you might have aware of the ISO368 date format before using it on CAML Query. There might be some conversion on your date format back and forth between SQL,CAML and SharePoint UI (ListView) you may consider try to optimize this area too. Believe or not believe, I have followed these steps in the list that has exceeded more than 8000, i.e 13000 list item and worked for me in SharePoint 2010, So It will on SharePoint 2013. Murugesa Pandian MCPD MCTS SharePoint 2010 .

Hi, This happens to you because of 'List View threshold' exceed,But still I am able to retrieve the required rows based on optimized CAML Query, After increasing the your threshold, please follow to consider the steps, Here is some tips to work with large list, You have to optimize your CAML query with AND operator on Modified Date column [You must index the column 'Modified' as suggested by Mike and with RowLimit] to narrow down the records from the query. Another example you can also split the list of items into logical chunk by creating the multiple Views and the use the View Name in the CAML Query to expect the better performance over list view threshold exceeded. And also I see that you are trying to querying the row based on the Date and Time with timestamp, from this example, you might have aware of the ISO368 date format before using it on CAML Query. There might be some conversion on your date format back and forth between SQL,CAML and SharePoint UI (ListView) you may consider try to optimize this area too.

Believe or not believe, I have followed these steps in the list that has exceeded more than 8000, i.e 13000 list item and worked for me in SharePoint 2010, So It will on SharePoint 2013. Murugesa Pandian MCPD MCTS SharePoint 2010 .