Package com.tonbeller.jpivot.param

Implements Session Parameters.

See:
Description

Interface Summary

ParameterProvider	creates a list of SessionParameter from a member.
SqlAccess	provides information about members that may be used in (drill-thru) SQL queries

Class Summary

AbstractParamProvider
MemberParamProvider	creates a SessionParam from a member
PropertyParamProvider	creates a SessionParam from a member property
PropertyPrefixParamProvider	Default implementation for ParameterProvider.
SetParameterTag	looks for a http parameter with a certain name.

Package com.tonbeller.jpivot.param Description

Implements Session Parameters.

A SessionParam is a parameter that can modify MDX and SQL queries. The parameters are held in a SessionParamPool. There is one pool per HttpSession.

SessionParam may be created in several ways:

• by some application logic. For example at login-time there may be some parameters that restrict the data a user is allowed to see
• by clicking on a member in the JPivot table ClickableMemberTag
• by clicking on a hyperlink com.tonbeller.jpivot.param.ParamLinkTag

Parameters may be used in sql queries. Example for JSTL's sql tag:

<jsp:useBean id="paramPool" class="com.tonbeller.jpivot.param.SessionParamPool" scope="session"/>

<sql:query var="result" dataSource="${myDataSource}">
  SELECT ...
  FROM ...
  WHERE CUSTOMERID = ?
  <sql:param value="${paramPool.CUSTOMERID.sqlValue}"/>
</sql:query>