FetchXML Tutotorial

Use aggregation in FetchXML

In this article, we will learn How to Use Use aggregation in FetchXML. In this blog we will see, How to Use aggregation in FetchXML In Common Data Service, FetchXML includes grouping and aggregation features where you can calculate sum, average min, max and count. The following aggregate functions are supported in fetchxml: 1. sum 2. avg 3. min 4.…

Continue Reading

FetchXML Tutotorial

Use FetchXML aggregation

In this article we will learn How to Use FetchXML aggregation. In this blog we will see, How to Use FetchXML aggregation In Common Data Service, FetchXML includes grouping and aggregation features where you can calculate sum, average min, max and count. The following aggregate functions are supported in fetchxml: 1. sum 2. avg 3. min 4. max 5.count(*) 6.count(attribute…

Continue Reading

FetchXML Tutotorial

Order By in Fetch XML Dynamic CRM

In this article, we will learn Order By in Fetch XML Dynamic CRM. In this blog, we will learn Order By in Fetch XML Dynamic CRM. Order By in Fetch XML Dynamic CRM The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default.…

Continue Reading

FetchXML Tutotorial

Order Type in Fetch XML Dynamic CRM

In this article, we will learn Order Type in Fetch XML Dynamic CRM. In this blog, we will learn Order Type in Fetch XML Dynamic CRM. Order Type in Fetch XML Dynamic CRM The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default.…

Continue Reading

FetchXML Tutotorial

FetchXML OR Condition in Dynamic CRM

In this article, we will learn FetchXML OR Condition in Dynamic CRM. In this blog, we will learn how to use FetchXML OR Condition in Dynamic CRM. FetchXML OR Condition in Dynamic CRM The OR operators are used to filter records based on more than one condition: The OR operator displays a record if any of the conditions separated by…

Continue Reading

FetchXML Tutotorial

fetchxml WHERE Clause in dynamic crm

In this article we will learn how to use fetchxml WHERE Clause in dynamic crm ? fetchxml WHERE Clause in dynamic crm The WHERE clause is used to filter records. The WHERE clause is used to extract only those records that fulfill a specified condition. Syntax: fetchxml WHERE Clause Example Key Point: vnks_customer:It is a logical name of entity. vnks_name:It…

Continue Reading

FetchXML Tutotorial

FetchXML Distinct in Dynamic Crm

FetchXML Distinct Here Laxmikant has explained with an example, FetchXML Distinct in Dynamic Crm. The DISTINCT statement is used to return only distinct (different) values. Inside a entity, a attribute often contains many duplicate values; and sometimes you only want to list the different (distinct) values. FetchXML Distinct Syntax Below is a show all records from the “Customers” entity FetchXML…

Continue Reading