How to query large list for items in Document Set?

  • 14 September 2017
  • 2 replies
  • 2 views

Userlevel 2
Badge +11

I need to run an approval workflow on certain documents in a document set, in a library exceeding the view threshold limit. As such the workflow action Query List currently fails because of the threshold. Is there an option to include a specific View (by its GUID) to the CAML Query? Or does anyone have an other suggestion how I can accomplish this?

The workflow will be started with an HTML button from the document set's welcome page. It documents it needs to run use a dedicated content type.

Although a good starting point, the article "Iterate through documents in a Document Set" by ‌ fails because of the large number of items.


2 replies

Badge +11

Hi Jean-Pierre Huls‌,

if you have server access you can disable throttling on a specific list to get rid of this threshold. You can use following PowerShell:

$web = Get-SPWeb [URL]

$list = $web.Lists["ListName"]

$list.EnableThrottling = $false

$list.Update()

Dont think you can query a specific view via caml. If you have access to an object model you can normally get the view first and execute the query directly on this view but thats not applicable via Nintex Workflow.

Best Regards

Philipp

Userlevel 2
Badge +11

Thank you ‌, but that is what intended to avoid.

Kind regards,

Jean-Pierre

Reply