Querying list using a "where Modified" triggering List View Threshold, even though it is indexed?

%3CLINGO-SUB%20id%3D%22lingo-sub-213628%22%20slang%3D%22en-US%22%3EQuerying%20list%20using%20a%20%22where%20Modified%22%20triggering%20List%20View%20Threshold%2C%20even%20though%20it%20is%20indexed%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213628%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20retrieve%20records%20modified%20since%20a%20given%20date%20from%20a%20list%20that%20has%2020k%2B%20items%20in%20it.%20I%20have%20created%20an%20index%20on%20the%20%22Modified%22%20column%2C%20and%20then%20tried%20(using%20PnP%20Powershell)%20to%20retrieve%20the%20items%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%24items%20%3D%20Get-PnPListItem%20-List%20%22Shop%20Opening%20Records%22%20-PageSize%205000%20-Query%20%22%3CVIEW%3E%3CBR%20%2F%3EScope%3D'RecursiveAll'%26gt%3B%3CROWLIMIT%3E5000%3C%2FROWLIMIT%3E%3CQUERY%3E%3CWHERE%3E%3CGEQ%3E%3CFIELDREF%20name%3D%22'Modified'%22%3E%3C%2FFIELDREF%3E%3CVALUE%20type%3D%22'DateTime'%22%3E2018-07-10T03%3A30%3A05Z%3C%2FVALUE%3E%3C%2FGEQ%3E%3C%2FWHERE%3E%3C%2FQUERY%3E%3C%2FVIEW%3E%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20this%20is%20resulting%20in%20a%20LVT%20error.%20Any%20ideas%20why%3F%20I%20thought%20indexing%20%22Modified%22%20would%20avoid%20this%20as%20it%20is%20the%20only%20field%20used%20in%20the%20query%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi,

 

I am trying to retrieve records modified since a given date from a list that has 20k+ items in it. I have created an index on the "Modified" column, and then tried (using PnP Powershell) to retrieve the items:

 

$items = Get-PnPListItem -List "Shop Opening Records" -PageSize 5000 -Query "<View
Scope='RecursiveAll'><RowLimit>5000</RowLimit><Query><Where><Geq><FieldRef Name='Modified' /><Value Type='DateTime'>2018-07-10T03:30:05Z</Value></Geq></Where></Query></View>"

 

However this is resulting in a LVT error. Any ideas why? I thought indexing "Modified" would avoid this as it is the only field used in the query?

 

Thanks

0 Replies