List of groupBy() Examples

Examples of groupBy()

adipe.translate.ra.RaTermBuilder.groupBy()
com.alibaba.druid.support.monitor.annotation.MField.groupBy()
com.alibaba.druid.support.monitor.annotation.MTable.groupBy()
com.asakusafw.dmdl.thundergate.util.SummarizedModelBuilder.groupBy()
グループ化プロパティを指定する。 @param sourceProperties グループ化プロパティの一覧 @return このオブジェクト (メソッドチェイン用)
com.asakusafw.modelgen.util.SummarizedModelBuilder.groupBy()
グループ化プロパティを指定する。 @param sourceProperties グループ化プロパティの一覧 @return このオブジェクト (メソッドチェイン用)
com.projity.algorithm.Query.groupBy()
com.smartgwt.client.widgets.grid.ListGrid.groupBy()
Display the current set of records grouped by their values for the given field or fields. With no arguments, disables all grouping.
Grouping tranforms the current dataset into a Tree on the fly, then provides a familiar tree interface for exploring the grouped data.
Grouping works automatically with any dataset, providing simple default grouping based on each field's declared type. However, you can use the {@link com.smartgwt.client.widgets.grid.ListGridField#getGroupValue} API to control how records are grouped, and the{@link com.smartgwt.client.widgets.grid.ListGridField#getGroupTitle} API to control how groups are titled.
Grouping can be performed programmatically via this API, or you can set {@link com.smartgwt.client.widgets.grid.ListGrid#getCanGroupBy canGroupBy} to enable menus that allow the user toperforming grouping. To group a grid automatically, instantiate the grid with a {@link com.smartgwt.client.widgets.grid.ListGrid#getGroupByField groupByField} setting.
While grouped, theautomatically created Tree is available as {@link com.smartgwt.client.widgets.grid.ListGrid#getGroupTree groupTree} and the original dataset is availabe as {@link com.smartgwt.client.widgets.grid.ListGrid#getOriginalData originalData}.
net.sourceforge.javautil.database.query.jpa.QueryBuilderSelectJPA.groupBy()
org.apache.empire.db.DBCommand.groupBy()
Adds a list of columns to the group by phrase of an sql statement. @param exprs vararg of columns by which to group the rows
org.apache.metamodel.query.Query.groupBy()
org.jboss.dashboard.dataset.DataSet.groupBy()
Groups this data set. @param groupByProperty The property to group for. @param columns An array of the columns to be included in the resulting data set. @param functionCodes The scalar function codes to apply to each property of the resulting data set. @return A new data set instance containing the group by calculations.
org.openrdf.sail.rdbms.evaluation.SqlQueryBuilder.groupBy()

Examples of org.apache.metamodel.query.Query.groupBy()

        Column commonProdIdColumn = orderlinesTable.getColumnByName("prod_id");
        Column quantityColumn = orderlinesTable.getColumnByName("quantity");


        q.from(orderlinesTable);
        q.where(new FilterItem(new SelectItem(prodIdColumn), OperatorType.EQUALS_TO, new SelectItem(commonProdIdColumn)));
        q.groupBy(titleColumn);
        q.getSelectClause().removeItem(q.getSelectClause().getSelectItem(productPriceColumn));
        SelectItem quantitySum = new SelectItem(FunctionType.SUM, quantityColumn).setAlias("orderAmount");
        q.select(quantitySum);
        q.having(new FilterItem(quantitySum, OperatorType.GREATER_THAN, 25));
        q.orderBy(new OrderByItem(q.getSelectClause().getItem(0)));

View Full Code Here

Examples of org.apache.metamodel.query.Query.groupBy()

        Query q = new Query();
        q.from(customersTable, "c");
        q.from(employeeTable, "o");
        SelectItem countrySelect = new SelectItem(countryColumn);
        q.select(countrySelect, new SelectItem(FunctionType.SUM, creditLimitColumn));
        q.groupBy(countryColumn);
        q.orderBy(new OrderByItem(countrySelect));
        q.where(new FilterItem(new SelectItem(employeeNumberColumn1), OperatorType.EQUALS_TO, new SelectItem(
                employeeNumberColumn2)));


        assertEquals(

View Full Code Here

Examples of org.apache.metamodel.query.Query.groupBy()


        final Query q = new Query();
        q.select(ageColumn).selectCount();
        q.from(table);
        q.where(ageColumn, OperatorType.GREATER_THAN, 18);
        q.groupBy(ageColumn);
        q.having(FunctionType.COUNT, nameColumn, OperatorType.LESS_THAN, 100);
        q.orderBy(ageColumn);


        final String sql = new DB2QueryRewriter(null).rewriteQuery(q);

View Full Code Here

Examples of org.apache.metamodel.query.Query.groupBy()


        final Query q = new Query();
        q.select(dateColumn).selectCount();
        q.from(table);
        q.where(dateColumn, OperatorType.GREATER_THAN, "2012-10-31 08:09:54");
        q.groupBy(dateColumn);
        q.having(FunctionType.COUNT, nameColumn, OperatorType.LESS_THAN, 100);
        q.orderBy(dateColumn);


        final String sql = new DB2QueryRewriter(null).rewriteQuery(q);

View Full Code Here

Examples of org.apache.metamodel.query.Query.groupBy()

        Column commonProdIdColumn = orderlinesTable.getColumnByName("prod_id");
        Column quantityColumn = orderlinesTable.getColumnByName("quantity");


        q.from(orderlinesTable);
        q.where(new FilterItem(new SelectItem(prodIdColumn), OperatorType.EQUALS_TO, new SelectItem(commonProdIdColumn)));
        q.groupBy(titleColumn);
        q.getSelectClause().removeItem(q.getSelectClause().getSelectItem(productPriceColumn));
        SelectItem quantitySum = new SelectItem(FunctionType.SUM, quantityColumn).setAlias("orderAmount");
        q.select(quantitySum);
        q.having(new FilterItem(quantitySum, OperatorType.GREATER_THAN, 25));
        q.orderBy(new OrderByItem(q.getSelectClause().getItem(0)));

View Full Code Here

Examples of org.apache.metamodel.query.Query.groupBy()

        DataContext dc = new CsvDataContext(new File("src/test/resources/csv_people.csv"));
        Table table = dc.getDefaultSchema().getTableByName("csv_people.csv");


        Query q = new Query();
        q.from(table);
        q.groupBy(table.getColumnByName("gender"));
        q.select(new SelectItem(table.getColumnByName("gender")),
                new SelectItem(FunctionType.MAX, table.getColumnByName("age")),
                new SelectItem(FunctionType.MIN, table.getColumnByName("age")), new SelectItem(FunctionType.COUNT, "*",
                        "total"), new SelectItem(FunctionType.MIN, table.getColumnByName("id")).setAlias("firstId"));
        DataSet data = dc.executeQuery(q);

View Full Code Here

Examples of org.apache.metamodel.query.Query.groupBy()

        Query q = new Query();
        q.from(new FromItem(table2).setAlias("r"));
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        Column projectIdColumn = table2.getColumnByName(COLUMN_ROLE_PROJECT_ID);
        q.select(new SelectItem(FunctionType.SUM, projectIdColumn));
        q.groupBy(new GroupByItem(new SelectItem(roleColumn)));
        q.orderBy(roleColumn);
        assertEquals("SELECT SUM(r.project_id) FROM MetaModelSchema.role r GROUP BY r.name ORDER BY r.name ASC",
                q.toString());


        DataContext dc = getDataContext();

View Full Code Here

Examples of org.apache.metamodel.query.Query.groupBy()

    public void testSimpleGroupBy() throws Exception {
        Query q = new Query();
        q.from(new FromItem(table2).setAlias("r"));
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        q.select(new SelectItem(roleColumn));
        q.groupBy(new GroupByItem(new SelectItem(roleColumn)));
        assertEquals("SELECT r.name FROM MetaModelSchema.role r GROUP BY r.name", q.toString());


        DataContext dc = getDataContext();
        DataSet data = dc.executeQuery(q);
        assertEquals(1, data.getSelectItems().length);

View Full Code Here

Examples of org.apache.metamodel.query.Query.groupBy()

        Query q = new Query();
        q.from(table2, "c");
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        Column contributorIdColumn = table2.getColumnByName(COLUMN_ROLE_CONTRIBUTOR_ID);


        q.groupBy(roleColumn);
        SelectItem countSelectItem = new SelectItem(FunctionType.COUNT, contributorIdColumn).setAlias("my_count");
        q.select(new SelectItem(roleColumn), countSelectItem);
        q.having(new FilterItem(countSelectItem, OperatorType.GREATER_THAN, 1));
        q.orderBy(new OrderByItem(countSelectItem));
        assertEquals(

View Full Code Here

Examples of org.apache.metamodel.query.Query.groupBy()

        Query q = new Query();
        q.from(table2, "c");
        Column roleColumn = table2.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        Column contributorIdColumn = table2.getColumnByName(COLUMN_ROLE_CONTRIBUTOR_ID);


        q.groupBy(roleColumn);
        SelectItem countSelectItem = new SelectItem(FunctionType.COUNT, contributorIdColumn).setAlias("my_count");
        q.select(new SelectItem(roleColumn));
        q.having(new FilterItem(countSelectItem, OperatorType.GREATER_THAN, 3));
        assertEquals("SELECT c.name FROM MetaModelSchema.role c GROUP BY c.name HAVING COUNT(c.contributor_id) > 3",
                q.toString());

View Full Code Here

0 1 2 3 4 5

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.