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 org.apache.ojb.broker.query.ReportQueryByCriteria.addGroupBy()

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


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

View Full Code Here

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


        // BRJ: we have to preserve groupby information
        Iterator iter = aQuery.getGroupBy().iterator();
        while(iter.hasNext())
        {
            countQuery.addGroupBy((FieldHelper) iter.next());
        }


        return countQuery;
    }

View Full Code Here

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

        Criteria crit2 = new Criteria();
        crit2.addLike("lastname", name);
        crit.addAndCriteria(crit2);
        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()

        Criteria crit2 = new Criteria();
        crit2.addLike("lastname", name);
        crit.addAndCriteria(crit2);
        ReportQueryByCriteria q = QueryFactory.newReportQuery(Person.class, crit);
        q.setAttributes(new String[]{"max(id)"});
        q.addGroupBy(new String[]{"lastname", "firstname"});


        Iterator iter = broker.getReportQueryIteratorByQuery(q);


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

View Full Code Here

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

        crit2.addLike("lastname", name);
        crit.addAndCriteria(crit2);


        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);
        assertNotNull(iter);

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

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

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


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

View Full Code Here

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


        // BRJ: we have to preserve groupby information
        Iterator iter = aQuery.getGroupBy().iterator();
        while(iter.hasNext())
        {
            countQuery.addGroupBy((FieldHelper) iter.next());
        }


        return countQuery;
    }

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

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.