Assembly: Db;
The ISQLComponents interface contains properties to access to a separate parts of query for cube data extraction.
ISQLComponents
If for cube data source, using the IStandardCubeDataset.SetCallback method, any query generation handler was assigned, then on cube opening the ISQLCallback.BeforeConstruction and ISQLCallback.AfterConstruction methods will be executed. Using the Components parameter of the ISQLCallback.BeforeConstruction method it is possible to get and modify a separate parts of query. The general list of query parts is presented in the ISQLCallback interface description.
| Property name | Brief description | |
|
Aggregation | The Aggregation property determines a part of query where expression for data aggregation is specified. |
|
Condition | The Condition property returns parameters of a separate condition included into Where. |
|
ConditionCount | The ConditionCount property returns a number of a separate conditions that are included into Where. |
|
DalCommandOption | The DalCommandOption property determines the mode of SQL query execution. |
|
From_ | The From_ property determines a part of query where data source is specified. |
|
GroupBy | The GroupBy property determines a part of query where an expression for results grouping is specified. |
|
OrderBy | The OrderBy property determines a part of query where the expression for results sorting is specified. |
|
Select_ | The Select_ property determines a part of query where the main part of query, determining extracted data, is specified. |
|
SubQuery | The SubQuery property returns whether subqueries are used in query. |
|
TableAlias | The TableAlias property returns an alias that is used in query to reduce names of tables. |
|
Where | The Where property determines a part of query where the whole condition of element selection for dimensions is specified. |
See also: