I am in the process of creating an administrative view which allows our intranet authors to view all the pages across the entire site collection that are awaiting their approval.
As our site collection is very large (about 1,100 webs with >12,000 documents and pages) I would prefer to cycle over the fewer SPWeb objects rather than each individual document or page as this would greatly reduce the time taken to display the data.
I eagerly dived in expecting the
SPWeb.Workflows member to be populated with all the workflows that are running in that web but the collection is empty! When I access the listitem of the page that requires approval, I can see the workflow there.
What would be the recommended approach to get the info of the pages pending approval along with their workflow, but not by going through each item across the entire site?