Solved

Micosoft Dynamics CRM relationship/middle entity help

Posted on 2010-09-23
3
1,389 Views
Last Modified: 2012-05-10
Hello all,

I had a previous question which I've deleted, so I can restate the problem and the errors I'm receiving. I'm trying to find all of the products associated with an account in CRM. A middle/intersect entity has been created called new_accountproductdetail.

Account entity has a 1:N to the new_accountproductdetail entity on accountid to new_accountid attributes.

Product entity has a 1:N to the new_accountproductdetail entity on productid to new_producttid attributes.

When I run my code I get the following error:
 'New_accountproductdetail' entity doesn't contain attribute with Name = 'productid'.

The following code that I'm using has been based on the following article:
http://blogs.msdn.com/b/crm/archive/2008/02/14/crm-4-0-relationships-explained.aspx

public void GetPrimaryAcctProducts(CrmService service, string accountID)

          {

               try

               {



                    ConditionExpression conditionName = new ConditionExpression();

                    conditionName.AttributeName = "productid";

                    conditionName.Operator = ConditionOperator.Equal;

                    conditionName.Values = new object[1];

                    conditionName.Values[0] = "product";



                    FilterExpression selectByName = new FilterExpression();



                    selectByName.Conditions = new ConditionExpression[] { conditionName };



                    //Create nested link entity and apply filter criteria 

                    LinkEntity nestedLinkEntity = new LinkEntity();

                    nestedLinkEntity.LinkToEntityName = "account";

                    nestedLinkEntity.LinkFromAttributeName = "accountid";

                    nestedLinkEntity.LinkToAttributeName = "new_accountid";

                    nestedLinkEntity.LinkCriteria = selectByName;



                    //Create the nested link entities 

                    LinkEntity intersectEntity = new LinkEntity();

                    intersectEntity.LinkToEntityName = "new_accountproductdetail";

                    intersectEntity.LinkFromAttributeName = "new_productid";

                    intersectEntity.LinkToAttributeName = "productid";

                    intersectEntity.LinkEntities = new LinkEntity[] { nestedLinkEntity };



                    //Create Query expression and set the entity type to lead 

                    QueryExpression expression = new QueryExpression();

                    expression.EntityName = "product";

                    expression.LinkEntities = new LinkEntity[] { intersectEntity };



                    RetrieveMultipleRequest request = new RetrieveMultipleRequest();



                    request.Query = expression;



                    //Execute and examine the response 

                    RetrieveMultipleResponse response = (RetrieveMultipleResponse)service.Execute(request);



                    BusinessEntity[] entities = response.BusinessEntityCollection.BusinessEntities;



                    string totals = "Total related=" + entities.Length; 



               }

               catch (SoapException error)

               {

                    throw new Exception(error.Detail.SelectSingleNode("//description").InnerText);

               }

          }

Open in new window

0
Comment
Question by:Paul_Gastineau
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
stacko111 earned 500 total points
ID: 33746037
Without looking too deeply into this it looks like your code should be looking for 'new_productid' rather than 'productid'
0
 

Author Comment

by:Paul_Gastineau
ID: 33746847
Thanks for the reply stacko, I swapped all of the LinkFromAttributeName and LinkToAttributeName values. In the code I'd posted I'd also forgotten to list my input var accountID as the contionname.value.

This has gotten rid of the errors but I'm still not getting any products returned. Can anyone help?
public void GetPrimaryAcctProducts(CrmService service, string accountID)

          {

               try

               {



                    //This code will retrieve a list of "leads" associated with the entity "Foo" on the relationship whose intersect entity is "new_account_lead_custom" 

                    //Filter by the specific record that we are looking for 

                    //(In this example we assume that there are no other accounts with the name Foo, otherwise 

                    // if would be recommended to use the account "id" instead of the name. 



                    ConditionExpression conditionName = new ConditionExpression();

                    conditionName.AttributeName = "accountid";

                    conditionName.Operator = ConditionOperator.Equal;

                    conditionName.Values = new object[1];

                    conditionName.Values[0] = accountID;



                    FilterExpression selectByName = new FilterExpression();



                    selectByName.Conditions = new ConditionExpression[] { conditionName };



                    //Create nested link entity and apply filter criteria 

                    LinkEntity nestedLinkEntity = new LinkEntity();

                    nestedLinkEntity.LinkToEntityName = "account";

                    nestedLinkEntity.LinkFromAttributeName = "new_accountid";

                    nestedLinkEntity.LinkToAttributeName = "accountid";

                    nestedLinkEntity.LinkCriteria = selectByName;



                    //Create the nested link entities 

                    LinkEntity intersectEntity = new LinkEntity();

                    intersectEntity.LinkToEntityName = "new_accountproductdetail";

                    intersectEntity.LinkFromAttributeName = "productid";

                    intersectEntity.LinkToAttributeName = "new_productid";

                    intersectEntity.LinkEntities = new LinkEntity[] { nestedLinkEntity };



                    //Create Query expression and set the entity type to lead 

                    QueryExpression expression = new QueryExpression();

                    expression.EntityName = "product";

                    expression.LinkEntities = new LinkEntity[] { intersectEntity };



                    RetrieveMultipleRequest request = new RetrieveMultipleRequest();



                    request.Query = expression;



                    //Execute and examine the response 

                    RetrieveMultipleResponse response = (RetrieveMultipleResponse)service.Execute(request);



                    BusinessEntity[] entities = response.BusinessEntityCollection.BusinessEntities;



                    string totals = "Total related=" + entities.Length; 





               }

               catch (SoapException error)

               {

                    throw new Exception(error.Detail.SelectSingleNode("//description").InnerText);

               }

          }

Open in new window

0
 

Author Closing Comment

by:Paul_Gastineau
ID: 33747550
I had all of the LinkFromAttributeName and LinkToAttributeName reversed. Switching them cleared all of the errors.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now