String selectQuery = (new SelectQuery()) .addColumns(t1Col1, t1Col2, t2Col1) .addJoin(SelectQuery.JoinType.INNER_JOIN, joinOfT1AndT2) .addOrderings(t1Col1) .validate().toString();
String selectQuery = (new SelectQuery()) .addColumns(t1Col1, t1Col2, t2Col1) .addJoin(SelectQuery.JoinType.INNER_JOIN, joinOfT1AndT2) .addOrderings(t1Col1) .validate().toString();
public SelectQuery build() { return new SelectQuery( dataSource, querySegmentSpec, descending, dimFilter, granularity, dimensions, metrics, virtualColumns, pagingSpec, context ); }
String query3 = new SelectQuery() .addCustomColumns( custNameCol, FunctionCall.sum().addColumnParams(orderTotalCol)) .addJoins(SelectQuery.JoinType.INNER, custOrderJoin) .addCondition(BinaryCondition.like(custNameCol, "%bob%")) .addCondition(BinaryCondition.greaterThan( orderDateCol, JdbcEscape.date(new Date(108, 0, 1)), true)) .addGroupings(custNameCol) .addHaving(BinaryCondition.greaterThan( FunctionCall.sum().addColumnParams(orderTotalCol), 100, false)) .validate().toString();
ObjectContext context = ... SelectQuery select = new SelectQuery(MyClass.class); select.setPageSize(100); List<MyClass> result = context.performQuery(select);
SelectQuery query = new SelectQuery(Responsibility.class); query.addPrefetch("employee"); List<Responsibility> responsibilities = context.performQuery(query);
DbTable table1= schema.findSchema("table1"); DbColumn column1 = table1.findColumn("column1"); SelectQuery sql = new SelectQuery(); sql.addAllColumns().addCustomFromTable(table1); sql.addCondition(BinaryCondition.like(column1, "A"));
public SelectQuery withQuerySegmentSpec(QuerySegmentSpec querySegmentSpec) { return new SelectQuery( getDataSource(), querySegmentSpec, dimFilter, granularity, dimensions, metrics, pagingSpec, getContext() ); }
public SelectQuery withOverriddenContext(Map<String, Object> contextOverrides) { return new SelectQuery( getDataSource(), getQuerySegmentSpec(), dimFilter, granularity, dimensions, metrics, pagingSpec, computeOverridenContext(contextOverrides) ); }
SelectQuery sql = new SelectQuery(); sql.addAllColumns().addCustomFromTable("table1"); sql.addCondition(BinaryCondition.like(new Column("column1"), "A"));
SelectQuery sql = new SelectQuery(); sql.addAllColumns().addCustomFromTable("table1"); sql.addCondition(BinaryCondition.like(new CustomSql("column1"), "A"));