AliasedValue Class

 

Applies To: Dynamics 365 (online), Dynamics 365 (on-premises), Dynamics CRM 2016, Dynamics CRM Online

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

Namespace:   Microsoft.Xrm.Sdk
Assembly:  Microsoft.Xrm.Sdk (in Microsoft.Xrm.Sdk.dll)

Inheritance Hierarchy

System.Object
  Microsoft.Xrm.Sdk.AliasedValue

Syntax

[DataContractAttribute(Name = "AliasedValue", Namespace = "http://schemas.microsoft.com/xrm/2011/Contracts")]
[KnownTypeAttribute("GetKnownAliasedValueTypes")]
public sealed class AliasedValue : IExtensibleDataObject
<DataContractAttribute(Name := "AliasedValue", Namespace := "http://schemas.microsoft.com/xrm/2011/Contracts")>
<KnownTypeAttribute("GetKnownAliasedValueTypes")>
Public NotInheritable Class AliasedValue
    Implements IExtensibleDataObject

Constructors

Name Description
System_CAPS_pubmethod AliasedValue()

Initializes a new instance of the AliasedValue class.

System_CAPS_pubmethod AliasedValue(String, String, Object)

Initializes a new instance of the AliasedValue class.

Properties

Name Description
System_CAPS_pubproperty AttributeLogicalName

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

System_CAPS_pubproperty EntityLogicalName

Gets the name of the entity the attribute belongs to.

System_CAPS_pubproperty ExtensionData

Gets or sets the structure that contains extra data.

System_CAPS_pubproperty Value

Gets the value returned by the query.

Methods

Name Description
System_CAPS_pubmethod Equals(Object)

(Inherited from Object.)

System_CAPS_pubmethod GetHashCode()

(Inherited from Object.)

System_CAPS_pubmethod GetType()

(Inherited from Object.)

System_CAPS_pubmethod ToString()

(Inherited from Object.)

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);

                    }

Thread Safety

Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Microsoft.Xrm.Sdk Namespace
Build queries with FetchXML
Use FetchXML aggregation
Sample: Use aggregation in FetchXML

Return to top

Microsoft Dynamics 365

© 2016 Microsoft. All rights reserved. Copyright