Sometime we need to get all activities related to specific account or contact. We can easily do this by Querying activitypointer entity based on regardingobjectID. you can use below function to get all activity related to account.<\/p>\n
You just need to pass Crm service object and Accountid to this function<\/p>\n
Public BusinessEntityCollection FetchActivityList(CrmService _Service,Guid AccountID)<\/p>\n
{<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 QueryExpression _Query = new QueryExpression();<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _Query.EntityName = “activitypointer”;<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ColumnSet _ColsToFetch = new ColumnSet();<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _ColsToFetch.Attributes = new string[] { “activityid”, “activitytypecode”, “subject” }; \/\/you can include others column based on your requirements<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _Query.ColumnSet = _ColsToFetch;<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _Query.Criteria = new FilterExpression();<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _Query.Criteria.FilterOperator = LogicalOperator.And;<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ConditionExpression _Condition = new ConditionExpression();<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _Condition.AttributeName = “regardingobjectid”;<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _Condition.Operator = ConditionOperator.Equal;<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _Condition.Values = new object[] { accountid };<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _Query.Criteria.Conditions = new ConditionExpression[] { _Condition };<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0BusinessEntityCollection _ActivityList = _Service.RetrieveMultiple(_Query);<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Return _ActivityList;<\/p>\n
}<\/p>\n
\u00a0Hope it will help somebody<\/p>\n
Happy Coding !!!<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometime we need to get all activities related to specific account or contact. We can easily do this by Querying activitypointer entity based on regardingobjectID. you can use below function to get all activity related to account. You just need to pass Crm service object and Accountid to this function Public BusinessEntityCollection FetchActivityList(CrmService _Service,Guid AccountID) { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 QueryExpression _Query =… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/197"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=197"}],"version-history":[{"count":0,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/197\/revisions"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}