none
Share Point CAML query for rows greater than 5000 RRS feed

  • Question

  • Dear All,

                 The aim is to use Query List Activity on Orchestrator to query SharePoint records that has more than 5000 rows. However, i get the below error.

    "The number of items in this list exceeds the list view threshold"

    Below is the query that  i am using.

    <Where><And><Contains><FieldRef Name="Computer_x0020_Name" /><Value Type="Text">COMPUTERNAME</Value></Contains><Contains><FieldRef Name="Application_x0020_Name" /><Value Type="Text">APPLICATIONNAME</Value></Contains></And></Where>

    Requirement:

    I obviously cant ask SP folks to increase the threshold and therefore I need a CAML query to query SharePoint link that has more than 5000 rows.

    Your help is appreciated.

    Thanks,

    Oz


    Oz

    Friday, June 29, 2018 11:44 AM

Answers

All replies