[]
DEMOS DOCS API SAMPLES DOWNLOAD
(Showing Draft Content)

C1.DataEngine.Op

Op Class

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

Inheritance
object
Op
Namespace: C1.DataEngine
Assembly: C1.DataEngine.dll
Syntax
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.