AliasedValue Class

Reference

Definition

Namespace:: Microsoft.Xrm.Sdk

Assembly:: Microsoft.Xrm.Sdk.dll

Package:: Microsoft.PowerPlatform.Dataverse.Client v1.1.32

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: Object
AliasedValue

Attributes: DataContractAttribute KnownTypeAttribute

Implements: IExtensibleDataObject

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

AliasedValue()	Initializes a new instance of the AliasedValue class.
AliasedValue(String, String, Object)	Initializes a new instance of the AliasedValue class.

Properties

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

Споделяне чрез