ColumnSource Property

Custom Columns are a way to add columns to Exago that don't exist in the Data Source. This is completely transparent for the users; they can then use them like any other column. New data columns can be created from composite or interpreted data fields. You could even use a formula to create data from scratch. Admins often use custom columns to make popular formula sorts available on an application-wide level.

When creating a Custom Formula Column, the ColumnSource should be set to EntityColumnSource.ExagoFormula. By default, columns from data sources are EntityColumnSource.Data.

Syntax

public EntityColumnSource ColumnSource {get; set;}

Property Value

The source of the column's content, from the EntityColumnSource Enumeration.

Exceptions

Exception	Description
WrNoMetadataColumnsDefinedException	Exception will be thrown when creating a custom formula column before the column metadata for the other columns in the Entity (Data Object) has been created.

Remarks

Before creating custom formula columns, the column metadata for the other columns in the Entity (Data Object) should be created and saved, otherwise an exception will occur.

Example

A new custom fomula column named "Merge" will be added to the Entity (Data Object) myNewEntity.

myNewEntity.ColumnMetadatas.Add(new EntityColumnMetadata("Merge")
{
	ColumnSource = EntityColumnSource.ExagoFormula, //required
	ColumnType = "String",                      	//required
	MnemonicName = "ID-Name",                   	//required
	ColumnDescription = "The ID and name combined together.",
	ColumnValue = "Concatenate({campaigns.ID},\"–\",{campaigns.Name})", //required
	SortAndGroupByFormula = "{campaigns.ID}"
});

Property Value

Reference