Close

Information Risk Management: 

Microsoft Office 365, Microsoft Teams, Microsoft SharePoint Server, Microsoft SharePoint Online, Microsoft Exchange Online, Azure DevOps & App Services, Azure Machine Learning

Searching for In-Place Records using CAML

John Holliday

October 31, 2011

Here’s a question I’m seeing a lot of.  “Can I write a CAML query to locate all of the documents that have been declared as in-place records?” The answer is yes, and it’s actually quite simple.
Table of Content

Just a quick note to all you records management junkies out there.  Here’s a question I’m seeing a lot of.  “Can I write a CAML query to locate all of the documents that have been declared as in-place records?”

The answer is yes.  It’s actually quite simple.  There is a new field called “Declared Record” that holds the date on which an item was declared as a record.  If that field is null, then the item was not declared.  The only trick is that you have to use the internal field name, which is “_vti_ItemDeclaredRecord”.

Here is a screenshot of a document library containing expense reports for an accounting department.  Notice that there are 2 records declared, the “Automobile Expenses” and “Expense Claim Form” documents.

SNAGHTML6e56af6

Here is another shot of a simple query in CAML Query Builder that finds all of the declared record items in the library:

image

Finally, here is the result of executing the query:

image

So, there you have it.  Easy as pie.

Share on facebook
Share on twitter
Share on linkedin
Share on email
Share on print