FetchXML Tutotorial

How to use like operator in FetchXML

In this blog we will learn how to use like operator in FetchXML? Use like operator in FetchXML The LIKE operator is used to search for a specified pattern in a column. Generally There are two wildcards often used in conjunction with the LIKE operator: 1. The percent sign (%) represents zero, one, or multiple characters 2. The underscore sign…

Continue Reading

FetchXML Tutotorial

Use MIN() and MAX() Functions in FetchXML

In this blog we will learn how to Use MIN() and MAX() Functions in FetchXML? Use MIN() and MAX() Functions in FetchXML. MIN(): The MIN() function returns the smallest value of the selected column. MAX(): The MAX() function returns the largest value of the selected column. MIN() Syntax MAX() Syntax MIN() Example The following fetchxml finds the price of the…

Continue Reading

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