protected String rewriteGroupByClause(Query query, GroupByClause groupByClause) { StringBuilder sb = new StringBuilder(); if (groupByClause.getItemCount() > 0) { sb.append(AbstractQueryClause.PREFIX_GROUP_BY); List<GroupByItem> items = groupByClause.getItems(); for (int i = 0; i < items.size(); i++) { GroupByItem item = items.get(i); if (i != 0) { sb.append(AbstractQueryClause.DELIM_COMMA); } sb.append(rewriteGroupByItem(query, item)); } } return sb.toString(); }
protected String rewriteGroupByClause(Query query, GroupByClause groupByClause) { StringBuilder sb = new StringBuilder(); if (groupByClause.getItemCount() > 0) { sb.append(AbstractQueryClause.PREFIX_GROUP_BY); List<GroupByItem> items = groupByClause.getItems(); for (int i = 0; i < items.size(); i++) { GroupByItem item = items.get(i); if (i != 0) { sb.append(AbstractQueryClause.DELIM_COMMA); } sb.append(rewriteGroupByItem(query, item)); } } return sb.toString(); }
private long getRowCount(Query q) { q = q.clone(); SelectItem countAllItem = SelectItem.getCountAllItem(); if (q.getGroupByClause().getItemCount() > 0) { q = new Query().from(new FromItem(q).setAlias("sq")).select(countAllItem); } else { q.getSelectClause().removeItems(); q.select(countAllItem); } Row row = MetaModelHelper.executeSingleRowQuery(_dataContext, q); Number count = (Number) row.getValue(countAllItem); return count.longValue(); }
private long getRowCount(Query q) { q = q.clone(); SelectItem countAllItem = SelectItem.getCountAllItem(); if (q.getGroupByClause().getItemCount() > 0) { q = new Query().from(new FromItem(q).setAlias("sq")).select(countAllItem); } else { q.getSelectClause().removeItems(); q.select(countAllItem); } Row row = MetaModelHelper.executeSingleRowQuery(_dataContext, q); Number count = (Number) row.getValue(countAllItem); return count.longValue(); }
private List<Column> getSplitColumns() { List<Column> result = new ArrayList<Column>(); if (_query.getGroupByClause().getItemCount() != 0) { List<GroupByItem> groupByItems = _query.getGroupByClause().getItems(); for (GroupByItem groupByItem : groupByItems) {
private List<Column> getSplitColumns() { List<Column> result = new ArrayList<Column>(); if (_query.getGroupByClause().getItemCount() != 0) { List<GroupByItem> groupByItems = _query.getGroupByClause().getItems(); for (GroupByItem groupByItem : groupByItems) {