CRM Plugin: Delete multiple records base on QueryExpression

(0) Share

Report

Posted on by Community Member

Hi all,

I'm trying to create a plugin to delete some records base on a lookup field.

I'm now using QueryExpression and Filter to query those should be deleted, under the condition such as "lookup filed" Equals "certain GUID". So, there will be multiple records retrieved as an EntityCollection.

I wanna know how can the program delete once by using the query result.

Btw, if there're not so many records, is it recommended to delete one by one with loop? How can I take it into consideration.

Thanks,

Yvonne

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

If you have several records to delete you can use ExecuteMultipleRequest for this purpose - msdn.microsoft.com/.../jj863604.aspx

Also if number of records to delete is not huge you can delete it in loop one by one.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (1)

Report

In addition you can also do BulkDeleteRequest using execute method.

msdn.microsoft.com/.../hh670605.aspx

Was this reply helpful? Yes No
C. Jensen 384 on at

Like (0)

Report
Hi Yvonne

You could do something like this:

private void DeleteRelatedRecords(string entityName, string attributeName, object attributeValue) { var query = new QueryExpression(entityName) { PageInfo = new PagingInfo() { Count = 250, PageNumber = 1 }, ColumnSet = new ColumnSet(false), }; query.Criteria.AddCondition(attributeName, ConditionOperator.Equal, attributeValue); while (true) { var RecordCollection = Service.RetrieveMultiple(query); if (RecordCollection != null && RecordCollection.Entities.Count > 0) { foreach (var record in RecordCollection.Entities) { Service.Delete(record.LogicalName, record.Id); } } if (RecordCollection.MoreRecords) { query.PageInfo.PageNumber++; query.PageInfo.PagingCookie = RecordCollection.PagingCookie; } else { break; } } }

That will loop through all the related records, and delete them.

Best regards

Christian Jensen

Was this reply helpful? Yes No
Suggested answer

sandeepstw 4,601 on at

Like (0)

Report

Hi,

protected void Delete(Guid LookupID)

{

string fetchquery = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>

<entity name='new_entityname>

<attribute name='new_id' />

<filter type='and'>

<condition attribute='new_lookupid' operator='eq' value='##ID##' />

</filter>

</entity>

</fetch>";

fetchquery = fetchquery.Replace("##ID##", LookupID + "");

EntityCollection results = service.RetrieveMultiple(new FetchExpression(fetchquery));

foreach (Entity e in results.Entities)

{

service.Delete(e);

}

}

Was this reply helpful? Yes No