Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

AliasedValue Class

Definition

Namespace:
Microsoft.Xrm.Sdk
Assembly:
Microsoft.Xrm.Sdk.dll
Package:
Microsoft.PowerPlatform.Dataverse.Client v1.2.10

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Used to return aggregate, group by, and aliased values from a query.

public ref class AliasedValue sealed : System::Runtime::Serialization::IExtensibleDataObject
[System.Runtime.Serialization.DataContract(Name="AliasedValue", Namespace="http://schemas.microsoft.com/xrm/2011/Contracts")]
[System.Runtime.Serialization.KnownType("GetKnownAliasedValueTypes")]
public sealed class AliasedValue : System.Runtime.Serialization.IExtensibleDataObject
[<System.Runtime.Serialization.DataContract(Name="AliasedValue", Namespace="http://schemas.microsoft.com/xrm/2011/Contracts")>]
[<System.Runtime.Serialization.KnownType("GetKnownAliasedValueTypes")>]
type AliasedValue = class
 interface IExtensibleDataObject
Public NotInheritable Class AliasedValue
Implements IExtensibleDataObject
Inheritance
AliasedValue
Attributes
Implements

Examples

// Fetch the average of estimatedvalue for all opportunities. This is the equivalent of 
 // SELECT AVG(estimatedvalue) AS estimatedvalue_avg ... in SQL.
 System.Console.WriteLine("===============================");
 string estimatedvalue_avg = @" 
 <fetch distinct='false' mapping='logical' aggregate='true'> 
 <entity name='opportunity'> 
 <attribute name='estimatedvalue' alias='estimatedvalue_avg' aggregate='avg' /> 
 </entity> 
 </fetch>";

 EntityCollection estimatedvalue_avg_result = _serviceProxy.RetrieveMultiple(new FetchExpression(estimatedvalue_avg));

 foreach (var c in estimatedvalue_avg_result.Entities)
 {
 decimal aggregate1 = ((Money)((AliasedValue)c["estimatedvalue_avg"]).Value).Value;
 System.Console.WriteLine("Average estimated value: " + aggregate1);

 }

Constructors

Name Description
AliasedValue()

Initializes a new instance of the AliasedValue class.

AliasedValue(String, String, Object)

Initializes a new instance of the AliasedValue class.

Properties

Name Description
AttributeLogicalName

Gets the name of the attribute on which the aggregate, group by, or select operation was performed.

EntityLogicalName

Gets the name of the entity the attribute belongs to.

ExtensionData

Gets or sets the structure that contains extra data.

Value

Gets the value returned by the query.

Applies to