225
Hello everyone,
I need to write my very first plug-in. I am needing to get the number of related records on a the parent entity. Basically the number of phone calls to an account. Unable to use a roll up field for this.
Can someone point to some good tutorials on how to do this?
*This post is locked for comments
Hello,
Apart from this I will suggest you to download CRM SDK, if you have not downloaded yet, which will give you good start. You can also look plugin development vedios in youtube:
www.google.co.in/search;source=lnms&tbm=vid&sa=X&ved=0ahUKEwi1vers-sHWAhUHv48KHcx3AtIQ_AUICigB&biw=1366&bih=662
Hope it will help.
Thanks
No,
That would be a function within the class for the entity that you are creating.
Calling this function would return the number of records for the entity, based on the criteria that you would enter in the filter area.
To get the exact query that you need, you can use fetch Xml builder from XRM Toolbox.
You can use the following sample code to get a count of record. This sample is based on the email entity:
private int RetrieveEmailCount(Guid emailId)
{
int rc = 0;
StringBuilder sb = new StringBuilder();
sb.AppendLine("<fetch distinct='false' mapping='logical' aggregate='true'> ");
sb.AppendLine(" <entity name='email'> ");
sb.AppendLine(" <attribute name='activityid' alias='email_count' aggregate='count'/> ");
sb.AppendLine(" <filter type='and'>");
sb.AppendLine(" <condition attribute='XXX' operator='eq' value='" + filterValue + "' /> ");
sb.AppendLine(" </filter> ");
sb.AppendLine(" </entity> ");
sb.AppendLine("</fetch>");
EntityCollection totalCount = service.RetrieveMultiple(new FetchExpression(sb.ToString()));
if (totalCount.Entities.Count > 0)
{
foreach (var t in totalCount.Entities)
{
rc = (int)((AliasedValue)t["email_count"]).Value;
break;
}
}
return rc;
}
Did you ever get an answer to this?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (