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>
Wednesday, 11 May 2011
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...
-
fetchxml conditions, what are they? Conditions in fetchxml as very straight forward, a full list of them are below. Example usage for a ...
-
I recently tried connecting to a new crm demo in BIDS, one which was setup using the office 365 portal. I connect this way for lots of custo...
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