Dynamics Community Forum Thread Details

How to clear the body of an email which has been sent without changing its SentOn timestamp?

In order to recoup some storage, we want to clear the description of some email records which have already been sent,

The aim is to retrain the emails in the activity feed with the relevant data such as subject, sent, etc. but without the body.

I tried opening the email, updating the description and setting the state back to Sent, but this updates the Sent date.

Does anyone have any idea how to achieve this?

                IOrganizationService svc = service;
                var email = svc.Retrieve(Email.EntityLogicalName, Guid.Parse(""), new ColumnSet(true));
                var senton = email.Attributes["senton"]; // 2020/01/01
                svc.Execute(new SetStateRequest {
                    EntityMoniker = email.ToEntityReference(),
                    Status = new OptionSetValue {
                        Value = (int)email_statuscode.Draft
                    },
                    State = new OptionSetValue { Value = (int)EmailState.Open }
                });
                var update = new Entity(Email.EntityLogicalName, email.Id);
                update.Attributes["description"] = "";
                svc.Execute(new UpdateRequest { Target = update });
                svc.Execute(new SetStateRequest {
                    EntityMoniker = email.ToEntityReference(),
                    Status = new OptionSetValue {
                        Value = (int)email_statuscode.Sent
                    },
                    State = new OptionSetValue { Value = (int)EmailState.Completed }
                });
                email = svc.Retrieve(Email.EntityLogicalName, Guid.Parse(""), new ColumnSet(true));
                senton = email.Attributes["senton"]; // date is set to "Now". How to keep the original date?

Quick Links