FetchXML Tutotorial

Group by year in fetchxml.

In this article we will learn How to use Group by year in fetchxml? In this example shows how to use Group by year in fetchxml? FetchXML includes grouping and aggregation features that you can use this function calculate sum, average min, max and count. Information About aggregation For create an aggregate attribute, set the keyword aggregate to true, then…

Continue Reading

FetchXML Tutotorial

How to use Group by with linked entity in fetchxml

In this article we will learn How to use Group by with linked entity in fetchxml ? In this example shows how to use the sum“aggregate attribute to sum linked entity values. FetchXML includes grouping and aggregation features that you can use this function calculate sum, average min, max and count. Information About aggregation For create an aggregate attribute, set…

Continue Reading

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