{"id":101,"date":"2011-05-30T05:58:00","date_gmt":"2011-05-30T05:58:00","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=101"},"modified":"2011-05-30T05:58:00","modified_gmt":"2011-05-30T05:58:00","slug":"how-to-get-the-total-results-returned-record-count-for-a-given-query","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/","title":{"rendered":"How to get the Total Results returned Record Count for a given query"},"content":{"rendered":"<p>In CRM2011 it is now possible to get the Total count of records returned by a query using Fetch XML.<\/p>\n<p>Using Query expression:<\/p>\n<p>You can set the ReturnTotalRecordCount property to True.<\/p>\n<p><a href=\"http:\/\/2.bp.blogspot.com\/-fqdhEMEZ96U\/TeM2lgWO5qI\/AAAAAAAAAyQ\/73AgsoO5Pkw\/s1600\/30%2Bmay.jpg\"><img decoding=\"async\" border=\"0\" alt=\"\" src=\"http:\/\/2.bp.blogspot.com\/-fqdhEMEZ96U\/TeM2lgWO5qI\/AAAAAAAAAyQ\/73AgsoO5Pkw\/s400\/30%2Bmay.jpg\"><\/a><\/p>\n<p>Using FetchXml:<\/p>\n<p>You can set the same property as shown below.<\/p>\n<p><fetch mapping='logical' count='10' returntotalrecordcount='true'><br \/><entity name='account'><br \/><attribute name='accountid' \/><br \/><attribute name='accountnumber' \/><br \/><attribute name='address1_city' \/><br \/><attribute name='address1_telephone1' \/><br \/><attribute name='name' \/><br \/><order attribute='name' \/><br \/><filter><br \/><condition attribute='address1_city' operator='like' value='a%' \/><br \/><\/filter><br \/><\/entity><br \/><\/fetch><\/p>\n<p>This can be helpful to show Record 1 of <totalcount>kind of status labels.<\/p>\n<p>Hope this helps!<\/totalcount><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In CRM2011 it is now possible to get the Total count of records returned by a query using Fetch XML. Using Query expression: You can set the ReturnTotalRecordCount property to True. Using FetchXml: You can set the same property as shown below. This can be helpful to show Record 1 of kind of status labels.\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/\">Read More: How to get the Total Results returned Record Count for\u2026 &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[794],"class_list":["post-101","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm","tag-fetch-xmlquery-expression"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"In CRM2011 it is now possible to get the Total count of records returned by a query using Fetch XML.Using Query expression:You can set the ReturnTotalRecordCount property to True.Using FetchXml:You can set the same property as shown below.This can be helpful to show Record 1 of kind of status labels.Hope this helps!\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Inogic\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Microsoft Dynamics 365 CRM Tips and Tricks - By Inogic\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"How to get the Total Results returned Record Count for a given query - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta property=\"og:description\" content=\"In CRM2011 it is now possible to get the Total count of records returned by a query using Fetch XML.Using Query expression:You can set the ReturnTotalRecordCount property to True.Using FetchXml:You can set the same property as shown below.This can be helpful to show Record 1 of kind of status labels.Hope this helps!\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/2.bp.blogspot.com\/-fqdhEMEZ96U\/TeM2lgWO5qI\/AAAAAAAAAyQ\/73AgsoO5Pkw\/s400\/30%2Bmay.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/2.bp.blogspot.com\/-fqdhEMEZ96U\/TeM2lgWO5qI\/AAAAAAAAAyQ\/73AgsoO5Pkw\/s400\/30%2Bmay.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2011-05-30T05:58:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2011-05-30T05:58:00+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inogicindia\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@inogic\" \/>\n\t\t<meta name=\"twitter:title\" content=\"How to get the Total Results returned Record Count for a given query - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta name=\"twitter:description\" content=\"In CRM2011 it is now possible to get the Total count of records returned by a query using Fetch XML.Using Query expression:You can set the ReturnTotalRecordCount property to True.Using FetchXml:You can set the same property as shown below.This can be helpful to show Record 1 of kind of status labels.Hope this helps!\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@inogic\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/2.bp.blogspot.com\/-fqdhEMEZ96U\/TeM2lgWO5qI\/AAAAAAAAAyQ\/73AgsoO5Pkw\/s400\/30%2Bmay.jpg\" \/>\n\t\t<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t\t<meta name=\"twitter:data1\" content=\"Inogic\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#blogposting\",\"name\":\"How to get the Total Results returned Record Count for a given query - Microsoft Dynamics 365 CRM Tips and Tricks\",\"headline\":\"How to get the Total Results returned Record Count for a given query\",\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/2.bp.blogspot.com\\\/-fqdhEMEZ96U\\\/TeM2lgWO5qI\\\/AAAAAAAAAyQ\\\/73AgsoO5Pkw\\\/s400\\\/30%2Bmay.jpg\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#articleImage\"},\"datePublished\":\"2011-05-30T05:58:00+05:30\",\"dateModified\":\"2011-05-30T05:58:00+05:30\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#webpage\"},\"articleSection\":\"Dynamics CRM, Fetch XML;Query Expression\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-crm\\\/#listItem\",\"name\":\"Dynamics CRM\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-crm\\\/#listItem\",\"position\":2,\"name\":\"Dynamics CRM\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-crm\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#listItem\",\"name\":\"How to get the Total Results returned Record Count for a given query\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#listItem\",\"position\":3,\"name\":\"How to get the Total Results returned Record Count for a given query\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-crm\\\/#listItem\",\"name\":\"Dynamics CRM\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\",\"name\":\"Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"By Inogic\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/inogic-logo.png\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#organizationLogo\",\"width\":1000,\"height\":325,\"caption\":\"inogic logo\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/inogicindia\",\"https:\\\/\\\/twitter.com\\\/inogic\",\"https:\\\/\\\/www.instagram.com\\\/inogicindia\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCM4V7ousgLSu1hbOEv4DUuQ\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/inogicindia\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/\",\"name\":\"Inogic\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/839d9ae7d2b941d2d09e91df322267a429821f2ce5494302b53bd5ca3679f1a0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Inogic\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#webpage\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/\",\"name\":\"How to get the Total Results returned Record Count for a given query - Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"In CRM2011 it is now possible to get the Total count of records returned by a query using Fetch XML.Using Query expression:You can set the ReturnTotalRecordCount property to True.Using FetchXml:You can set the same property as shown below.This can be helpful to show Record 1 of kind of status labels.Hope this helps!\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2011\\\/05\\\/how-to-get-the-total-results-returned-record-count-for-a-given-query\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"datePublished\":\"2011-05-30T05:58:00+05:30\",\"dateModified\":\"2011-05-30T05:58:00+05:30\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/\",\"name\":\"Microsoft Dynamics 365 CRM Tips and Tricks\",\"alternateName\":\"Inogic\",\"description\":\"By Inogic\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to get the Total Results returned Record Count for a given query - Microsoft Dynamics 365 CRM Tips and Tricks","description":"In CRM2011 it is now possible to get the Total count of records returned by a query using Fetch XML.Using Query expression:You can set the ReturnTotalRecordCount property to True.Using FetchXml:You can set the same property as shown below.This can be helpful to show Record 1 of kind of status labels.Hope this helps!","canonical_url":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#blogposting","name":"How to get the Total Results returned Record Count for a given query - Microsoft Dynamics 365 CRM Tips and Tricks","headline":"How to get the Total Results returned Record Count for a given query","author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"http:\/\/2.bp.blogspot.com\/-fqdhEMEZ96U\/TeM2lgWO5qI\/AAAAAAAAAyQ\/73AgsoO5Pkw\/s400\/30%2Bmay.jpg","@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#articleImage"},"datePublished":"2011-05-30T05:58:00+05:30","dateModified":"2011-05-30T05:58:00+05:30","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#webpage"},"isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#webpage"},"articleSection":"Dynamics CRM, Fetch XML;Query Expression"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.inogic.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/#listItem","name":"Dynamics CRM"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/#listItem","position":2,"name":"Dynamics CRM","item":"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#listItem","name":"How to get the Total Results returned Record Count for a given query"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#listItem","position":3,"name":"How to get the Total Results returned Record Count for a given query","previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/#listItem","name":"Dynamics CRM"}}]},{"@type":"Organization","@id":"https:\/\/www.inogic.com\/blog\/#organization","name":"Microsoft Dynamics 365 CRM Tips and Tricks","description":"By Inogic","url":"https:\/\/www.inogic.com\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/02\/inogic-logo.png","@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#organizationLogo","width":1000,"height":325,"caption":"inogic logo"},"image":{"@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/inogicindia","https:\/\/twitter.com\/inogic","https:\/\/www.instagram.com\/inogicindia\/","https:\/\/www.youtube.com\/channel\/UCM4V7ousgLSu1hbOEv4DUuQ","https:\/\/www.linkedin.com\/company\/inogicindia"]},{"@type":"Person","@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author","url":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/","name":"Inogic","image":{"@type":"ImageObject","@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/839d9ae7d2b941d2d09e91df322267a429821f2ce5494302b53bd5ca3679f1a0?s=96&d=mm&r=g","width":96,"height":96,"caption":"Inogic"}},{"@type":"WebPage","@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#webpage","url":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/","name":"How to get the Total Results returned Record Count for a given query - Microsoft Dynamics 365 CRM Tips and Tricks","description":"In CRM2011 it is now possible to get the Total count of records returned by a query using Fetch XML.Using Query expression:You can set the ReturnTotalRecordCount property to True.Using FetchXml:You can set the same property as shown below.This can be helpful to show Record 1 of kind of status labels.Hope this helps!","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/#breadcrumblist"},"author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"creator":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"datePublished":"2011-05-30T05:58:00+05:30","dateModified":"2011-05-30T05:58:00+05:30"},{"@type":"WebSite","@id":"https:\/\/www.inogic.com\/blog\/#website","url":"https:\/\/www.inogic.com\/blog\/","name":"Microsoft Dynamics 365 CRM Tips and Tricks","alternateName":"Inogic","description":"By Inogic","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Microsoft Dynamics 365 CRM Tips and Tricks - By Inogic","og:type":"article","og:title":"How to get the Total Results returned Record Count for a given query - Microsoft Dynamics 365 CRM Tips and Tricks","og:description":"In CRM2011 it is now possible to get the Total count of records returned by a query using Fetch XML.Using Query expression:You can set the ReturnTotalRecordCount property to True.Using FetchXml:You can set the same property as shown below.This can be helpful to show Record 1 of kind of status labels.Hope this helps!","og:url":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/","og:image":"https:\/\/2.bp.blogspot.com\/-fqdhEMEZ96U\/TeM2lgWO5qI\/AAAAAAAAAyQ\/73AgsoO5Pkw\/s400\/30%2Bmay.jpg","og:image:secure_url":"https:\/\/2.bp.blogspot.com\/-fqdhEMEZ96U\/TeM2lgWO5qI\/AAAAAAAAAyQ\/73AgsoO5Pkw\/s400\/30%2Bmay.jpg","article:published_time":"2011-05-30T05:58:00+00:00","article:modified_time":"2011-05-30T05:58:00+00:00","article:publisher":"https:\/\/www.facebook.com\/inogicindia","twitter:card":"summary_large_image","twitter:site":"@inogic","twitter:title":"How to get the Total Results returned Record Count for a given query - Microsoft Dynamics 365 CRM Tips and Tricks","twitter:description":"In CRM2011 it is now possible to get the Total count of records returned by a query using Fetch XML.Using Query expression:You can set the ReturnTotalRecordCount property to True.Using FetchXml:You can set the same property as shown below.This can be helpful to show Record 1 of kind of status labels.Hope this helps!","twitter:creator":"@inogic","twitter:image":"http:\/\/2.bp.blogspot.com\/-fqdhEMEZ96U\/TeM2lgWO5qI\/AAAAAAAAAyQ\/73AgsoO5Pkw\/s400\/30%2Bmay.jpg","twitter:label1":"Written by","twitter:data1":"Inogic"},"aioseo_meta_data":{"post_id":"101","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-02-02 05:58:39","updated":"2025-07-03 21:46:22","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.inogic.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/\" title=\"Dynamics CRM\">Dynamics CRM<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to get the Total Results returned Record Count for a given query\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.inogic.com\/blog"},{"label":"Dynamics CRM","link":"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/"},{"label":"How to get the Total Results returned Record Count for a given query","link":"https:\/\/www.inogic.com\/blog\/2011\/05\/how-to-get-the-total-results-returned-record-count-for-a-given-query\/"}],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=101"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/101\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}