I am still getting up to speed with Sharepoint, after spending two months correcting the noob error of letting my main list view get above 5000 items.
I have split this library up (it had upwards of 22,000 files) into 20+ different libraries that will all stay below the 5000 list view threshold. (I use Sharepoint with MS Dynamics CRM, and apparently CRM will not tolerate an excess of 5000 items).
That single library had a great view, with a custom boolean field ("Done") which marked files that needed to be reviewed. Files would come in, the receptionist staff would mark them as "Not Done", and additional staff would have the option to go through this list and review the documents that were Not Done.
Now, with the library broken up into 20+ pieces, I need to know the best way to achieve a view that will give me access to every "Not Done" document in each of the separate libraries I have created.
What methodologies should I start looking at?