#SimpleAggregateFunction

##Properties

Datatype Property name Property description Default Value
Hashtable AllowedTypeGroups Gets a list of key/value pairs that define the collection of Izenda.AdHoc.Database.SqlTypeGroups that are valid for this aggregation function. null
String Caption Gets the display text that is used for this aggregation function. String.Empty
Hashtable DisallowedTypeGroups Gets a list of key/value pairs that define the collection of Izenda.AdHoc.Database.SqlTypeGroups that are not valid for this aggregation function. null
IFormatter[] Formatters Gets a set of formatters that can optionally be used to format the results of the aggregation function. []
String Function Gets the System.String representation of the raw SQL function that expressions will be wrapped with when using this aggregation function. String.Empty
Boolean IsExtraFunction Determines whether this function can be used in pivot column function lists. False
Boolean IsGroup Determines whether this aggregate function requires grouping in order to be used. False
Boolean IsScalar Determines whether or not this aggregation function is able to accept a group function. False
SqlType OutputType Gets the database type that the resulting output of the aggregate function will use. Unknown

##Methods

###CompatibilityWithFunction(System.Boolean) Represents a method that determines whether this aggregate function is compatible with pivots.

Parameters:

  • System.Boolean isExtraFunction - Whether the function list that the aggregation function is being added to is a pivot column function list. When false then the function list is a standard aggregate function list.

Returns:

True when this aggregation function can be used with the aggregation function list that is being constructed.


###Equals(System.Object) Determines whether the specified System.Object is equal to the current System.Object.

Parameters:

Returns:

true if the specified System.Object is equal to the current System.Object; otherwise, false.


###GetHashCode() Serves as a hash function for a particular type.

Returns:

A hash code for the current System.Object.


###GetSQL(System.String,Izenda.AdHoc.Database.SqlType) Represents the method that builds the SQL expression for the aggregate function.

Parameters:

Returns:

The entire SQL statement that will be generated when the aggregation function is applied to the statement.


###GetType() Gets the System.Type of the current instance.

Returns:

The System.Type instance that represents the exact runtime type of the current instance.


###ToString() Returns a System.String that represents the current System.Object.

Returns:

A System.String that represents the current System.Object.