在MS Dynamics CRM中选择前10条记录

Question

如何向CRM Dynamics查询前50条记录，如sqlserver中的top。

谢谢,

Answer 1

您需要分页：Is it possible to limit the amount of results returned in a response when using a QueryExpression in CRM 4

Answer 2

您需要TopCount的QueryExpression属性：

var query = new QueryExpression(entity) {
     ColumnSet = new ColumnSet(someColumns),
     Criteria = {
         Conditions = ...
     },
     TopCount = 50
 };

Answer 3

您可以使用fetch xml，如下所示：

<fetch top="50" >
  <entity name="contact" >
    <attribute name="contactid" />
    <attribute name="fullname" />
  </entity>
</fetch>