Op Class

Class used in specifying queries. See "DataEngine queries" for explanations of how queries are created and executed.

Inheritance

Namespace: C1.DataEngine

Assembly: C1.DataEngine.dll

Syntax

public class Op

Public Class Op

Methods

Name	Description
Add(Column, Column)	Add: binary, simple (without aggregation) operation.
Avg(Column)	Average: aggregation operation.
Count(Column)	Count: aggregation operation.
Div(Column, Column)	Divide: binary, simple (without aggregation) operation.
Dt(Column, string)	formatted DateTime: unary, simple (without aggregation) operation on DateTime producing string column.
DtPart(Column, DateTimeParts)	DateTime part: unary, simple (without aggregation) operation on DateTime.
First(Column)	First (value in the first row in the column order): aggregation operation.
Fmt(Column, string)	Format: unary, simple (without aggregation) operation.
LCase(Column)	Convert to lower case: unary, simple (without aggregation) operation on strings.
Last(Column)	Last (value in the last row in the column order): aggregation operation.
Max(Column)	Maximum: aggregation operation.
Min(Column)	Minimum: aggregation operation.
Mod(Column, Column)	Modulo: binary, simple (without aggregation) operation.
Mul(Column, Column)	Multiply: binary, simple (without aggregation) operation.
Rnd(Column, int)	Round: unary, simple (without aggregation) operation.
Rpl(Column, string, string)	Replace: unary, simple (without aggregation) operation on strings.
Std(Column)	Standard deviation: aggregation operation.
StdP(Column)	Population standard deviation: aggregation operation.
Sub(Column, Column)	Subtract: binary, simple (without aggregation) operation.
SubStr(Column, int, int)	Substring: unary, simple (without aggregation) operation on strings.
Sum(Column)	Sum: aggregation operation.
UCase(Column)	Convert to upper case: unary, simple (without aggregation) operation on strings.
Var(Column)	Variance: aggregation operation.
VarP(Column)	Population variance: aggregation operation.