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
[php]
<fetch mapping="logical" aggregate="true" version="1.0">
<entity name="entity_name">
<attribute name="attribute_name" alias="allias_name" aggregate="min" />
</entity>
</fetch>
[/php]
MAX() Syntax
[php]
<fetch mapping="logical" aggregate="true" version="1.0">
<entity name="entity_name">
<attribute name="attribute_name" alias="allias_name" aggregate="max" />
</entity>
</fetch>
[/php]
MIN() Example
The following fetchxml finds the price of the cheapest product:
[php]
<fetch mapping="logical" aggregate="true" version="1.0">
<entity name="products">
<attribute name="price" alias="SmallestPrice" aggregate="min" />
</entity>
</fetch>
[/php]
MAX() Example
The following fetchxml finds the price of the expensive product:
[php]
<fetch mapping="logical" aggregate="true" version="1.0">
<entity name="products">
<attribute name="price" alias="LargestPrice" aggregate="max" />
</entity>
</fetch>
[/php]
