CalculatedField.DataMember Property

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v21.2.Core.dll

Declaration

[DefaultValue(null)]
public string DataMember { get; set; }

<DefaultValue(Nothing)>
Public Property DataMember As String

Property Value

Remarks

The DataMember property should be specified only for DashboardSqlDataSource and DashboardEFDataSource. The SQL and EF Data Sources can contain multiple queries and the DataMember property of a calculated field determines to what query this field belongs.

The following example shows how to specify DataMember for calculatedFieldNotWorking:

CalculatedField calculatedFieldNotWorking = new CalculatedField {
    DataMember = "DashboardSqlDataSourceQueryWithJoin",
    Name = "Calculated Field",
    Expression = "[FirstName]",
    DataType = CalculatedFieldType.String
};

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DataMember property.

Name = "Sales Person",
DataMember = selectQuery.Name,
Expression = "Concat([FirstName], ' ', [LastName])"

CalculatedField isGreater = new CalculatedField();
isGreater.DataMember = "SalesPerson";
isGreater.Name = "IsGreater";

Private Shared Function CreateCalculatedFields(ByVal selectQuery As SqlQuery) As CalculatedFieldCollection
    Dim fieldSalesPerson As New CalculatedField() With {.Name = "Sales Person", .DataMember = selectQuery.Name, .Expression = "Concat([FirstName], ' ', [LastName])"}
    Dim fieldExtPrice As New CalculatedField() With {.Name = "Extended Price", .DataMember = selectQuery.Name, .Expression = "[Quantity] * [UnitPrice]"}

Dim isGreater As New CalculatedField()
isGreater.DataMember = "SalesPerson"
isGreater.Name = "IsGreater"