Package it.eng.spagobi.tools.dataset.common.query

Examples of it.eng.spagobi.tools.dataset.common.query.IAggregationFunction

99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
   
    // appends measures
    Iterator<CrosstabDefinition.Measure> measuresIt = measures.iterator();
    while (measuresIt.hasNext()) {
      CrosstabDefinition.Measure aMeasure = measuresIt.next();
      IAggregationFunction function = aMeasure.getAggregationFunction();
      String alias = getSQLAlias(aMeasure.getAlias(), baseQuery, baseQuerySelectedFields);
      if (alias == null) {
        // when defining a crosstab inside the SmartFilter document, an additional COUNT field with id QBE_SMARTFILTER_COUNT
        // is automatically added inside query fields, therefore the alias is not found on base query selected fields
        if (aMeasure.getEntityId().equals(QBE_SMARTFILTER_COUNT)) {
          toReturn.append(AggregationFunctions.COUNT_FUNCTION.apply("*"));
        } else {
          logger.error("Alias " + aMeasure.getAlias() + " not found on the base query!!!!");
          throw new RuntimeException("Alias " + aMeasure.getAlias() + " not found on the base query!!!!");
        }
      } else {
        if (function != AggregationFunctions.NONE_FUNCTION) {
          toReturn.append(function.apply(alias));
        } else {
          toReturn.append(alias);
        }
      }
      if (measuresIt.hasNext()) {
View Full Code Here
183
184
185
186
187
188
189
190
191
192
193
194
195
      Iterator it = dataMartSelectFields.iterator();
      while (it.hasNext()) {
        DataMartSelectField field = (DataMartSelectField) it.next();
        int fieldIndex = query.getSelectFieldIndex(field.getUniqueName());       
        String[] f = (String[])selectFields.get(fieldIndex);
        IAggregationFunction aggregationFunction = field.getFunction();
        if (aggregationFunction != null && aggregationFunction != AggregationFunctions.NONE_FUNCTION) {
          transformer.addAggregateColumn(f[1]!=null? f[1]:f[0], aggregationFunction.getName(), field.getAlias());
        }
      }
     
      sqlQuery = (String)transformer.transformQuery(sqlQuery);
     
View Full Code Here
302
303
304
305
306
307
308
309
310
311
312
    JSONArray operandLastValuesJSONArray;
    HavingField.Operand leftOperand;
    HavingField.Operand rightOperand;
    String operator;
    String booleanConnector;
    IAggregationFunction function;
   
    logger.debug("IN");
   
    try {
   
View Full Code Here
470
471
472
473
474
475
476
477
478
479
480
481
      rootEntityAlias = (String)targetQueryEntityAliasesMap.get( rootEntity.getUniqueName() );
      logger.debug("where field root entity alias [" + rootEntityAlias + "]");
     
      if (operand instanceof HavingField.Operand) {
        HavingField.Operand havingFieldOperand = (HavingField.Operand) operand;
        IAggregationFunction function = havingFieldOperand.function;
        operandElement = function.apply(rootEntityAlias + "." + queryName);
      } else {
        operandElement = rootEntityAlias + "." + queryName;
      }
      logger.debug("where element operand value [" + operandElement + "]");
    } finally {
View Full Code Here
472
473
474
475
476
477
478
479
480
481
482
483
      rootEntityAlias = (String)targetQueryEntityAliasesMap.get( rootEntity.getUniqueName() );
      logger.debug("where field root entity alias [" + rootEntityAlias + "]");
     
      if (operand instanceof HavingField.Operand) {
        HavingField.Operand havingFieldOperand = (HavingField.Operand) operand;
        IAggregationFunction function = havingFieldOperand.function;
        operandElement = function.apply(rootEntityAlias + "." + queryName);
      } else {
        operandElement = rootEntityAlias + "." + queryName;
      }
      logger.debug("where element operand value [" + operandElement + "]");
    } finally {
View Full Code Here
TOP

Related Classes of it.eng.spagobi.tools.dataset.common.query.IAggregationFunction

  • it.eng.qbe.query.serializer.json.QueryJSONDeserializer
  • it.eng.qbe.statement.hibernate.HQLStatement
  • it.eng.qbe.statement.jpa.JPQLStatement
  • it.eng.spagobi.engines.qbe.services.formviewer.ExecuteMasterQueryAction
  • it.eng.spagobi.engines.qbe.utils.crosstab.CrosstabQueryCreator
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.