Package mondrian.rolap.sql

Interface MemberChildrenConstraint

All Superinterfaces:

SqlConstraint

All Known Implementing Classes:

DefaultMemberChildrenConstraint, RolapNativeSet.SetConstraint, SqlContextConstraint

public interface MemberChildrenConstraint
extends SqlConstraint

Restricts the SQL result of a MembersChildren query in SqlMemberSource.

Since:

Nov 2, 2005

Author:

av

See Also:

SqlMemberSource

Method Summary

Modifier and Type	Method	Description
void	addLevelConstraint(SqlQuery query, RolapCube baseCube, AggStar aggStar, RolapLevel level)	Will be called once for the level that contains the children of a Member.Children query.
void	addMemberConstraint(SqlQuery sqlQuery, RolapCube baseCube, AggStar aggStar, List<RolapMember> parents)	Modifies a Member.Children query so that (all or some) children of all parent members contained in parents will be returned in the result set.
void	addMemberConstraint(SqlQuery sqlQuery, RolapCube baseCube, AggStar aggStar, RolapMember parent)	Modifies a Member.Children query so that only the children of parent will be returned in the result set.

Methods inherited from interface mondrian.rolap.sql.SqlConstraint

getCacheKey

Method Detail

addMemberConstraint

void addMemberConstraint(SqlQuery sqlQuery,
                         RolapCube baseCube,
                         AggStar aggStar,
                         RolapMember parent)

Modifies a Member.Children query so that only the children of parent will be returned in the result set.

Parameters:

sqlQuery - the query to modify

baseCube - base cube for virtual members

aggStar - Aggregate star, if we are reading from an aggregate table,

parent - the parent member that restricts the returned children

addMemberConstraint

void addMemberConstraint(SqlQuery sqlQuery,
                         RolapCube baseCube,
                         AggStar aggStar,
                         List<RolapMember> parents)

Modifies a Member.Children query so that (all or some) children of all parent members contained in parents will be returned in the result set.

Parameters:

sqlQuery - Query to modify

baseCube - Base cube for virtual members

aggStar - Aggregate table, or null if query is against fact table

parents - List of parent members that restrict the returned children

addLevelConstraint

void addLevelConstraint(SqlQuery query,
                        RolapCube baseCube,
                        AggStar aggStar,
                        RolapLevel level)

Will be called once for the level that contains the children of a Member.Children query. If the condition requires so, it may join the levels table to the fact table.

Parameters:

query - the query to modify

baseCube - base cube for virtual members

aggStar - Aggregate table, or null if query is against fact table

level - the level that contains the children