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>
Subscribe to:
Post Comments (Atom)
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...
-
How to turn CRM 2011 Pre-filtering on for Reporting Services Reports. Open the dataset, edit the fetchxml query and add in the enableprefi...
-
Sometimes you might be querying a hidden entity in CRM, or you simply dont want to have to go into CRM to check field names. Therefore to...
-
This follows on from this Microsoft Guide http://social.technet.microsoft.com/wiki/contents/articles/7681.setting-the-adfs-timeout-for-crm...
Hi, I have a question.
ReplyDeleteIs 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
Hi,
DeleteYes this query does work, paste your fetchxml if you still need assistance with it.
Regards
Pete
Useful information, thanks for posting. Just make sure that the 'count' attribute is lowercase, otherwise it has no effect.
ReplyDelete