List of addGroupBy() Examples

Examples of addGroupBy()

mondrian.rolap.sql.SqlQuery.addGroupBy()
org.apache.ojb.broker.query.ReportQueryByCriteria.addGroupBy()
org.jooq.SelectQuery.addGroupBy()
Adds grouping fields @param fields The grouping fields

Examples of mondrian.rolap.sql.SqlQuery.addGroupBy()

                continue;
            }
            final String alias = "d" + i;
            innerSqlQuery.addSelect(expr, alias);
            if (databaseProduct == Dialect.DatabaseProduct.GREENPLUM) {
                innerSqlQuery.addGroupBy(expr, alias);
            }
            final String quotedAlias = dialect.quoteIdentifier(alias);
            outerSqlQuery.addSelectGroupBy(quotedAlias);
        }

View Full Code Here

Examples of mondrian.rolap.sql.SqlQuery.addGroupBy()


            String alias = getMeasureAlias(i);
            String expr = measure.generateExprString(outerSqlQuery);
            innerSqlQuery.addSelect(expr, alias);
            if (databaseProduct == Dialect.DatabaseProduct.GREENPLUM) {
                innerSqlQuery.addGroupBy(expr, alias);
            }
            outerSqlQuery.addSelect(
                measure.getAggregator().getNonDistinctAggregator()
                    .getExpression(
                    dialect.quoteIdentifier(alias)));

View Full Code Here

Examples of mondrian.rolap.sql.SqlQuery.addGroupBy()

                columnExpr = measure.getAggregator().getExpression(columnExpr);
            }
            final String columnName = columnNameList.get(k);
            String alias = query.addSelect(columnExpr, columnName);
            if (!(column instanceof Measure)) {
                query.addGroupBy(columnExpr, alias);
            }
        }
        // remove whitespace from query - in particular, the trailing newline
        return query.toString().trim();
    }

View Full Code Here

Examples of mondrian.rolap.sql.SqlQuery.addGroupBy()

                columnExpr = measure.getAggregator().getExpression(columnExpr);
            }
            final String columnName = columnNameList.get(k);
            String alias = query.addSelect(columnExpr, null, columnName);
            if (!(column instanceof Measure)) {
                query.addGroupBy(columnExpr, alias);
            }
        }
        // remove whitespace from query - in particular, the trailing newline
        return query.toString().trim();
    }

View Full Code Here

Examples of mondrian.rolap.sql.SqlQuery.addGroupBy()

                continue;
            }
            String alias = "d" + i;
            alias = innerSqlQuery.addSelect(expr, null, alias);
            if (databaseProduct == Dialect.DatabaseProduct.GREENPLUM) {
                innerSqlQuery.addGroupBy(expr, alias);
            }
            final String quotedAlias = dialect.quoteIdentifier(alias);
            outerSqlQuery.addSelectGroupBy(quotedAlias, null);
            // Add this alias to the map of grouping sets aliases
            groupingSetsAliases.put(

View Full Code Here

Examples of mondrian.rolap.sql.SqlQuery.addGroupBy()

            innerSqlQuery.addSelect(
                expr,
                measure.getInternalType(),
                alias);
            if (databaseProduct == Dialect.DatabaseProduct.GREENPLUM) {
                innerSqlQuery.addGroupBy(expr, alias);
            }
            outerSqlQuery.addSelect(
                measure.getAggregator().getNonDistinctAggregator()
                    .getExpression(dialect.quoteIdentifier(alias)),
                measure.getInternalType());

View Full Code Here

Examples of org.apache.ojb.broker.query.ReportQueryByCriteria.addGroupBy()

        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addLike("firstname", "%o%");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Person.class, crit);
        q.setAttributes(new String[] { "id", "firstname", "count(*)" });
        q.addGroupBy(new String[] { "id", "firstname" });


        Iterator iter = broker.getReportQueryIteratorByQuery(q);


        assertNotNull(iter);
        while (iter.hasNext())

View Full Code Here

Examples of org.apache.ojb.broker.query.ReportQueryByCriteria.addGroupBy()

        int types[] = new int[]{Types.DECIMAL, Types.VARCHAR, Types.BIGINT};


        crit.addLike("firstname", "%o%");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Person.class, crit);
        q.setAttributes(new String[] { "id", "firstname", "count(*)" });
        q.addGroupBy(new String[] { "id", "firstname" });
        q.setJdbcTypes(types);


        Iterator iter = broker.getReportQueryIteratorByQuery(q);


        assertNotNull(iter);

View Full Code Here

Examples of org.apache.ojb.broker.query.ReportQueryByCriteria.addGroupBy()

        Criteria crit = new Criteria();
        Collection results = new Vector();
        crit.addLike("firstname", "%o%");
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Person.class, crit);
        q.setAttributes(new String[] { "id", "firstname", "count(*)" });
        q.addGroupBy(new String[] { "id", "firstname" });


        q.setStartAtIndex(3);
        q.setEndAtIndex(5);
        Iterator iter = broker.getReportQueryIteratorByQuery(q);

View Full Code Here

Examples of org.apache.ojb.broker.query.ReportQueryByCriteria.addGroupBy()

    {
        Criteria crit = new Criteria();
        Collection results = new Vector();
        ReportQueryByCriteria q = QueryFactory.newReportQuery(ProductGroup.class, crit);
        q.setAttributes(new String[] { "groupName", "sum(allArticlesInGroup.stock)", "sum(allArticlesInGroup.price)" });
        q.addGroupBy("groupName");


        Iterator iter = broker.getReportQueryIteratorByQuery(q);
        
//        SELECT A0.KategorieName,sum(A1.Lagerbestand),sum(A1.Einzelpreis)
//        FROM Kategorien A0

View Full Code Here

0 1 2 3

TOP

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.