Wednesday 11 May 2011

Top 10/x Records

Bringing back the top 10 records in CRM2011 using fetchxml is extremly simple, you just need to add in count="10" into the first fetch tag as per below

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" count="10">
  <entity name="bc_renewal">
    <attribute name="subject" />
  </entity>
</fetch>

3 comments:

  1. Hi, I have a question.
    Is this fetchxml query working?
    I'm trying to get top 100 or top 1000 record from cloud crm with 3rd party Coyroc component but I'm getting error.
    Can you inform me about this topic.
    Thanks.

    frtsn@hotmail.com
    TURKEY

    ReplyDelete
    Replies
    1. Hi,

      Yes this query does work, paste your fetchxml if you still need assistance with it.

      Regards
      Pete

      Delete
  2. Useful information, thanks for posting. Just make sure that the 'count' attribute is lowercase, otherwise it has no effect.

    ReplyDelete

ADFS Timeout on Server 2012 for CRM 2011

This follows on from this Microsoft Guide http://social.technet.microsoft.com/wiki/contents/articles/7681.setting-the-adfs-timeout-for-crm...