In this blog we will learn How to use like and not like operator in FetchXML? Use like and not 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…
Category: 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…
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 <fetch mapping=”logical” aggregate=”true” version=”1.0″> <entity name=”entity_name”> <attribute name=”attribute_name” alias=”allias_name” aggregate=”min” /> </entity>…
How to pass null and not null operator in FetchXML
In this blog we will learn How to pass null and not null operator in FetchXML? First learn about What is a NULL Value? A field with a NULL value is a field with no value. If a field in a table is optional, it is possible to insert a new record or update a record without adding a value…
How to pass null operator in FetchXML
In this blog we will learn How to pass null operator in FetchXML? First learn about What is a NULL Value? A field with a NULL value is a field with no value. If a field in a table is optional, it is possible to insert a new record or update a record without adding a value to this field.…
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…
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…
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.…
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…
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.…