it.eng.spagobi.engines.qbe.services.worksheet
Class LoadWorksheetCrosstabAction

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.qbe.services.core.AbstractQbeEngineAction
                          extended by it.eng.spagobi.engines.qbe.services.crosstab.LoadCrosstabAction
                              extended by it.eng.spagobi.engines.qbe.services.worksheet.LoadWorksheetCrosstabAction
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 LoadWorksheetCrosstabAction
extends LoadCrosstabAction

See Also:
Serialized Form

Field Summary
 
Fields inherited from class it.eng.spagobi.engines.qbe.services.crosstab.LoadCrosstabAction
auditlogger, logger
 
Fields inherited from class it.eng.spagobi.utilities.engines.AbstractEngineAction
PRIVATE_SCOPE, PUBLIC_SCOPE
 
Constructor Summary
LoadWorksheetCrosstabAction()
           
 
Method Summary
protected  java.lang.String buildSqlStatement(CrosstabDefinition crosstabDefinition, it.eng.qbe.query.Query baseQuery, java.lang.String sqlQuery, it.eng.qbe.statement.IStatement stmt)
          Build the sql statement for the temporary table...
protected  org.json.JSONObject loadSmartFilterFormValues()
          Loads the values of the form if the calling engine is smart filter
 
Methods inherited from class it.eng.spagobi.engines.qbe.services.crosstab.LoadCrosstabAction
service
 
Methods inherited from class it.eng.spagobi.engines.qbe.services.core.AbstractQbeEngineAction
getDataSource, getEngineInstance, getFilteredQuery, getQuery, setDataSource
 
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, 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
 

Constructor Detail

LoadWorksheetCrosstabAction

public LoadWorksheetCrosstabAction()
Method Detail

loadSmartFilterFormValues

protected org.json.JSONObject loadSmartFilterFormValues()
                                                 throws org.json.JSONException
Loads the values of the form if the calling engine is smart filter

Overrides:
loadSmartFilterFormValues in class LoadCrosstabAction
Returns:
Throws:
org.json.JSONException

buildSqlStatement

protected java.lang.String buildSqlStatement(CrosstabDefinition crosstabDefinition,
                                             it.eng.qbe.query.Query baseQuery,
                                             java.lang.String sqlQuery,
                                             it.eng.qbe.statement.IStatement stmt)
                                      throws org.json.JSONException
Build the sql statement for the temporary table... Apply also the filters

Overrides:
buildSqlStatement in class LoadCrosstabAction
Parameters:
crosstabDefinition - definition of the crosstab
baseQuery - base query
sqlQuery - the sql rappresentation of the base query
stmt - the qbe statement
Returns:
Throws:
org.json.JSONException