Select top 10 records in MS Dynamics CRM

Question

how can i query to CRM Dynamics for top 50 records like top in sqlserver.

thanks,

score 5 · Accepted Answer · edited May 23 '17 at 12:11

5

You want paging: Is it possible to limit the amount of results returned in a response when using a QueryExpression in CRM 4

edited May 23 '17 at 12:11

Community

1
1

answered Aug 01 '11 at 13:03

Matt

4,656
1
22
32

Question linked to refers to CRM 4, but it works identically for CRM 2011. – Matt Aug 01 '11 at 20:23
I think that TopCount is needed rather than paging. – hdoghmen Aug 28 '19 at 10:15
1

Yes, at the time this was originally answered it wasn't available. TopCount can also be used to do this now. – Matt Aug 31 '19 at 21:56

score 1 · Answer 2 · edited Oct 31 '21 at 02:47

1

You need the QueryExpression property TopCount :

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

edited Oct 31 '21 at 02:47

Elikill58

4,050
24
23
45

answered Aug 28 '19 at 09:48

hdoghmen

3,175
4
29
33

score 0 · Answer 3 · answered Oct 29 '21 at 16:00

0

You can use fetch xml something like below:

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

answered Oct 29 '21 at 16:00

praskulkarni88

65
7

Select top 10 records in MS Dynamics CRM

3 Answers3