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.empire.db.DBCommand.groupBy()

    {
        // Define the sub query
        DBCommand subCmd = db.createCommand();
        DBColumnExpr MAX_DATE_FROM = T_EDH.C_DATE_FROM.max().as(T_EDH.C_DATE_FROM);
        subCmd.select(T_EDH.C_EMPLOYEE_ID, MAX_DATE_FROM);
        subCmd.groupBy(T_EDH.C_EMPLOYEE_ID);
        DBQuery Q_MAX_DATE = new DBQuery(subCmd);


        // Define the query
        DBCommand cmd = db.createCommand();
        // Select required columns

View Full Code Here

Examples of org.apache.empire.db.DBCommand.groupBy()

            SampleAdvDB.EmployeeDepartmentHistory T_EDH = db.T_EMP_DEP_HIST;
            
            // Define the sub query
            DBCommand cmd = db.createCommand();
            cmd.select (T_EDH.C_EMPLOYEE_ID, T_EDH.C_DATE_FROM.max());
            cmd.groupBy(T_EDH.C_EMPLOYEE_ID);
            return cmd;
        }
    }


    /**

View Full Code Here

Examples of org.apache.empire.db.DBCommand.groupBy()

    {
        // Define the sub query
        DBCommand subCmd = db.createCommand();
        DBColumnExpr MAX_DATE_FROM = T_EDH.C_DATE_FROM.max().as(T_EDH.C_DATE_FROM);
        subCmd.select(T_EDH.C_EMPLOYEE_ID, MAX_DATE_FROM);
        subCmd.groupBy(T_EDH.C_EMPLOYEE_ID);
        DBQuery Q_MAX_DATE = new DBQuery(subCmd);


        // Define the query
        DBCommand cmd = db.createCommand();
        // Select required columns

View Full Code Here

Examples of org.apache.empire.db.DBCommand.groupBy()

            SampleAdvDB.EmployeeDepartmentHistory T_EDH = db.T_EMP_DEP_HIST;
            
            // Define the sub query
            DBCommand cmd = db.createCommand();
            cmd.select (T_EDH.C_EMPLOYEE_ID, T_EDH.C_DATE_FROM.max());
            cmd.groupBy(T_EDH.C_EMPLOYEE_ID);
            return cmd;
        }
    }


    /**

View Full Code Here

Examples of org.apache.empire.db.DBCommand.groupBy()

    {
        // Define the sub query
        DBCommand subCmd = db.createCommand();
        DBColumnExpr MAX_DATE_FROM = T_EDH.C_DATE_FROM.max().as(T_EDH.C_DATE_FROM);
        subCmd.select(T_EDH.C_EMPLOYEE_ID, MAX_DATE_FROM);
        subCmd.groupBy(T_EDH.C_EMPLOYEE_ID);
        DBQuery Q_MAX_DATE = new DBQuery(subCmd);


        // Define the query
        DBCommand cmd = db.createCommand();
        // Select requried columns

View Full Code Here

Examples of org.apache.empire.db.DBCommand.groupBy()

    {
        // Define the sub query
        DBCommand subCmd = db.createCommand();
        DBColumnExpr MAX_DATE_FROM = T_EDH.C_DATE_FROM.max().as(T_EDH.C_DATE_FROM);
        subCmd.select(T_EDH.C_EMPLOYEE_ID, MAX_DATE_FROM);
        subCmd.groupBy(T_EDH.C_EMPLOYEE_ID);
        DBQuery Q_MAX_DATE = new DBQuery(subCmd);


        // Define the query
        DBCommand cmd = db.createCommand();
        // Select requried columns

View Full Code Here

Examples of org.apache.empire.db.DBCommand.groupBy()

    {
        // Define the sub query
        DBCommand subCmd = db.createCommand();
        DBColumnExpr MAX_DATE_FROM = T_EDH.C_DATE_FROM.max().as(T_EDH.C_DATE_FROM);
        subCmd.select(T_EDH.C_EMPLOYEE_ID, MAX_DATE_FROM);
        subCmd.groupBy(T_EDH.C_EMPLOYEE_ID);
        DBQuery Q_MAX_DATE = new DBQuery(subCmd);


        // Define the query
        DBCommand cmd = db.createCommand();
        // Select required columns

View Full Code Here

Examples of org.apache.empire.db.DBCommand.groupBy()

            SampleAdvDB.EmployeeDepartmentHistory T_EDH = db.T_EMP_DEP_HIST;
            
            // Define the sub query
            DBCommand cmd = db.createCommand();
            cmd.select (T_EDH.C_EMPLOYEE_ID, T_EDH.C_DATE_FROM.max());
            cmd.groupBy(T_EDH.C_EMPLOYEE_ID);
            return cmd;
        }
    }


    /**

View Full Code Here

Examples of org.apache.empire.db.DBCommand.groupBy()

    {
        // Define the sub query
        DBCommand subCmd = db.createCommand();
        DBColumnExpr MAX_DATE_FROM = T_EDH.C_DATE_FROM.max().as(T_EDH.C_DATE_FROM);
        subCmd.select(T_EDH.C_EMPLOYEE_ID, MAX_DATE_FROM);
        subCmd.groupBy(T_EDH.C_EMPLOYEE_ID);
        DBQuery Q_MAX_DATE = new DBQuery(subCmd);


        // Define the query
        DBCommand cmd = db.createCommand();
        // Select required columns

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

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.