ISQLComponents

Assembly: Db;

Namespace: Prognoz.Platform.Interop.Db;

Description

The ISQLComponents interface contains properties to access to a separate parts of query for cube data extraction.

Inheritance Hierarchy

ISQLComponents

Comments

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.

Properties

	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.
	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:

Db Assembly Interfaces