-
dotnet-api
-
C1.DataEngine Assembly
-
C1.DataEngine
-
Classes
- BaseTable
- Column
- ColumnCondition
- ColumnCopy
- ColumnDerived
- ColumnOp
- ColumnOpCustom
- ColumnOpCustomBase
- ColumnOpCustomGroup
- Columns
- CondValue
- CondValues
- Condition
- Connector
- Converter
- DbConnector
- JoinColumns
- JoinQuery
- LicenseManager
- ObjectConnector<T>
- Op
- Query
- Table
- UnsupportedTypeException
- Values
- Workspace
- Enums
- Interfaces
- Delegates
-
Classes
-
C1.DataEngine
- C1.PivotEngine Assembly
- C1.Win.FlexPivot.8 Assembly
-
C1.DataEngine Assembly
- dotnet-framework-api
C1.DataEngine.Op
Op Class
Class used in specifying queries. See "DataEngine queries" for explanations of how queries are created and executed.
Namespace: C1.DataEngine
Assembly: C1.DataEngine.dll
Syntax
public class OpMethods
| 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. |