Many a times we come across situations where we accidentally, delete a particular record and wish to recover that record
back in CRM.
This
is possible only if you have “Auditing” enabled for that respective entity. So
from the audit history we can re-create deleted records in CRM.
Let us take an example, supposing some records were deleted
today and needs to be recovered.
//fetch XML for retrieving auditing records
which were deleted today
string fetchXML = "<fetch
version='1.0' output-format='xml-platform' mapping='logical' no-lock='true'
distinct='false'> " +
"<entity
name='audit'> " +
"<attribute
name='auditid' /> " +
"<attribute
name='operation' /> " +
"<filter
type='and'> " +
"<condition
attribute='createdon' operator='today' /> " +
"<condition
attribute='operation' operator='eq' value='3' /> " +
"</filter>
" +
"</entity>
" +
"</fetch>";
//retrieve the audit records from fetchxml
var auditrecords = service.RetrieveMultiple(new FetchExpression(fetchXML));
//loop through each audit entity record found and
create deleted records
foreach (Entity
audit in auditrecords.Entities)
{
// create retrieve
audit detail request object
RetrieveAuditDetailsRequest auditDetailsRequest
= new RetrieveAuditDetailsRequest();
//assign audit id value
auditDetailsRequest.AuditId = audit.Id;
//execute request and retrieve response
RetrieveAuditDetailsResponse
auditDetailsResponse =
(RetrieveAuditDetailsResponse)_service.Execute(auditDetailsRequest);
//create auditDetail variable and assign its value
AuditDetail auditDetail =
auditDetailsResponse.AuditDetail;
//type cast audtitDetail as AttributeAuditDetail
AttributeAuditDetail attributeAuditDetail =
auditDetail as AttributeAuditDetail;
//create the deleted
record
service.Create(attributeAuditDetail.OldValue);
}
In above code first we have retrieved audit entity records
which were created “today” and operation was “Delete”.
“Operation” field is an “Option Set” field and values are
- Create = 1
- Update = 2
- Delete = 3
- Assign = 4
Hope this post helps!
