Sorting BusinessEntityCollection

All replies

• 

  

  0

  Sign in to vote

  you need to use OrderExpression to sort the return result...
  
  following is example from SDK which retrives account sorted based on address1_city,address1_county..
  
  hope this helps..
  

  // For example, you can sort the accountnumber attribute in descending order, 
  and the address1_city attribute in ascending order.
  
  
  
  ///The following example demonstrates how to use the 
  //QueryByAttribute.Orders property.
  
  
  // Create the QueryByAttribute object.
  QueryByAttribute query = new QueryByAttribute();
  query.ColumnSet = new AllColumns();
  query.EntityName = EntityName.account.ToString();
  
  // Set the order of returned accounts.
  OrderExpression oe = new OrderExpression();
  oe.AttributeName = "address1_city";
  oe.OrderType = OrderType.Ascending;
  OrderExpression oe1 = new OrderExpression();
  oe1.AttributeName = "address1_county";
  oe1.OrderType = OrderType.Ascending;
  query.Orders = new OrderExpression[]{oe, oe1};
  

  • Proposed as answer by DavidBerryMVP, Moderator Saturday, November 21, 2009 7:46 PM
  • Marked as answer by Chevie Monday, November 23, 2009 11:32 AM

  Saturday, November 21, 2009 6:59 PM
• 

  

  0

  Sign in to vote

  Thanks a lot, that helped. I only had to change
  
  query.Orders = new OrderExpression[]{oe, oe1};
  
  to
  
  query.Orders.Add(oe);
  query.Orders.Add(oe2);
  
  Thanks a lot!!!
  

  Monday, November 23, 2009 11:33 AM