Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1452
  • Last Modified:

Micosoft Dynamics CRM relationship/middle entity help

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
Paul_Gastineau
Asked:
Paul_Gastineau
  • 2
1 Solution
 
stacko111Commented:
Without looking too deeply into this it looks like your code should be looking for 'new_productid' rather than 'productid'
0
 
Paul_GastineauAuthor Commented:
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
 
Paul_GastineauAuthor Commented:
I had all of the LinkFromAttributeName and LinkToAttributeName reversed. Switching them cleared all of the errors.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now