it.eng.spagobi.engines.worksheet.services.runtime
Class LoadCrosstabAction

java.lang.Object
  extended by it.eng.spago.dispatching.service.DefaultRequestContext
      extended by it.eng.spago.dispatching.service.DefaultHttpRequestContext
          extended by it.eng.spago.dispatching.action.AbstractHttpAction
              extended by it.eng.spagobi.utilities.service.AbstractBaseHttpAction
                  extended by it.eng.spagobi.utilities.engines.AbstractEngineAction
                      extended by it.eng.spagobi.engines.worksheet.services.AbstractWorksheetEngineAction
                          extended by it.eng.spagobi.engines.worksheet.services.runtime.LoadCrosstabAction
All Implemented Interfaces:
it.eng.spago.dispatching.action.ActionIFace, it.eng.spago.dispatching.service.HttpRequestContextIFace, it.eng.spago.dispatching.service.RequestContextIFace, it.eng.spago.dispatching.service.ServiceIFace, it.eng.spago.init.InitializerIFace, java.io.Serializable

public class LoadCrosstabAction
extends AbstractWorksheetEngineAction

See Also:
Serialized Form

Field Summary
static org.apache.log4j.Logger auditlogger
           
static org.apache.log4j.Logger logger
          Logger component.
static java.lang.String SHEET
           
 
Fields inherited from class it.eng.spagobi.utilities.engines.AbstractEngineAction
PRIVATE_SCOPE, PUBLIC_SCOPE
 
Constructor Summary
LoadCrosstabAction()
           
 
Method Summary
protected  java.lang.String buildSqlStatement(CrosstabDefinition crosstabDefinition, it.eng.spagobi.tools.dataset.persist.IDataSetTableDescriptor descriptor, java.util.List<it.eng.qbe.query.WhereField> filters, it.eng.spagobi.tools.datasource.bo.IDataSource dataSource)
          Build the sql statement to query the temporary table
 void service(it.eng.spago.base.SourceBean request, it.eng.spago.base.SourceBean response)
           
 
Methods inherited from class it.eng.spagobi.engines.worksheet.services.AbstractWorksheetEngineAction
adjustMetadata, adjustMetadata, applyOptions, buildSqlStatement, executeWorksheetQuery, getAllFields, getConnection, getDataSource, getEngineInstance, getFiltersOnDomainValues, getGlobalFiltersOnDomainValues, getOptionalFilters, getSheetFiltersOnDomainValues, getUserSheetFilterValues, persistDataSet, setDataSource, setEngineInstance, transformIntoWhereClauses, transformIntoWhereClauses, updateWorksheetDefinition
 
Methods inherited from class it.eng.spagobi.utilities.engines.AbstractEngineAction
getAuditServiceProxy, getConetxtManager, getEnv, getLocale, getSpagoBIHttpSessionContainer, getSpagoBISessionContainer, init, saveAnalysisState, setLocale
 
Methods inherited from class it.eng.spagobi.utilities.service.AbstractBaseHttpAction
delAttributeFromHttpSession, delAttributeFromSession, getAttribute, getAttributeAsBoolean, getAttributeAsBoolean, getAttributeAsCsvStringList, getAttributeAsInteger, getAttributeAsJSONArray, getAttributeAsJSONObject, getAttributeAsList, getAttributeAsString, getAttributeFromHttpSession, getAttributeFromHttpSessionAsBoolean, getAttributeFromHttpSessionAsBoolean, getAttributeFromHttpSessionAsString, getAttributeFromSession, getAttributeFromSessionAsBoolean, getAttributeFromSessionAsBoolean, getAttributeFromSessionAsString, getAttributesAsLinkedMap, getAttributesAsMap, getHttpSession, getSessionContainer, getSpagoBIRequestContainer, getSpagoBIResponseContainer, httpSessionContainsAttribute, requestContainsAttribute, requestContainsAttribute, sessionContainsAttribute, setAttribute, setAttributeInHttpSession, setAttributeInSession, setSpagoBIRequestContainer, setSpagoBIResponseContainer, tryToWriteBackToClient, writeBackToClient, writeBackToClient, writeBackToClient, writeBackToClient, writeBackToClient
 
Methods inherited from class it.eng.spago.dispatching.action.AbstractHttpAction
getActionMethod, getActionName, getConfig, setActionMethod, setActionName
 
Methods inherited from class it.eng.spago.dispatching.service.DefaultHttpRequestContext
freezeHttpResponse, getHttpRequest, getHttpResponse, getServletConfig, isHttpResponseFreezed, setRequestContext, unfreezeHttpResponse
 
Methods inherited from class it.eng.spago.dispatching.service.DefaultRequestContext
getErrorHandler, getRequestContainer, getResponseContainer, getServiceRequest, getServiceResponse
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface it.eng.spago.dispatching.service.RequestContextIFace
getErrorHandler, getRequestContainer, getResponseContainer, getServiceRequest, getServiceResponse
 

Field Detail

SHEET

public static final java.lang.String SHEET
See Also:
Constant Field Values

logger

public static transient org.apache.log4j.Logger logger
Logger component.


auditlogger

public static transient org.apache.log4j.Logger auditlogger
Constructor Detail

LoadCrosstabAction

public LoadCrosstabAction()
Method Detail

service

public void service(it.eng.spago.base.SourceBean request,
                    it.eng.spago.base.SourceBean response)
Specified by:
service in interface it.eng.spago.dispatching.service.ServiceIFace
Overrides:
service in class it.eng.spagobi.utilities.engines.AbstractEngineAction

buildSqlStatement

protected java.lang.String buildSqlStatement(CrosstabDefinition crosstabDefinition,
                                             it.eng.spagobi.tools.dataset.persist.IDataSetTableDescriptor descriptor,
                                             java.util.List<it.eng.qbe.query.WhereField> filters,
                                             it.eng.spagobi.tools.datasource.bo.IDataSource dataSource)
Build the sql statement to query the temporary table

Parameters:
crosstabDefinition - definition of the crosstab
descriptor - the temporary table descriptor
dataSource - the datasource
tableName - the temporary table name
Returns:
the sql statement to query the temporary table