I need to run a workflow on all items in a library. This SPServices example seems like a good plan but I'm running into problems.
The library has folders and the CAML query returns only the folders, not the individual items. I have tried CAML - How to filter folders from result setCAML - How to filter folders from result set but I can only use the Where
clause in the SPServices call and cannot set the scope to recursive.
Another option is the HarePoint Workflow Scheduler. If I run it on a list view that shows only the documents, nothing happens. If I set the CAML query in the tool itself, I can again only use the Where
clause.
The library has way over 5000 items, hence the folders. I was planning to use view filters to work on batches of less than 5000, so the view threshold is not breached. Maybe there is a way to use SPServices to iterate over a subset of items that does not breach the view threshold?
Ideas welcome, as long as they don't involve Visual Studio. I'm fine with SPD and JavaScript.