public CountSelectBuilderImpl(Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); this.selectItem = SelectItem.getCountAllItem(); query.select(selectItem); }
public CountSelectBuilderImpl(Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); this.selectItem = SelectItem.getCountAllItem(); query.select(selectItem); }
public Query selectCount() { return select(SelectItem.getCountAllItem()); }
public Query selectCount() { return select(SelectItem.getCountAllItem()); }
return SelectItem.getCountAllItem(); expression = expression.substring(startParenthesis + 1, expression.length() - 1).trim(); if (function instanceof CountAggregateFunction && "*".equals(expression)) { final SelectItem selectItem = SelectItem.getCountAllItem(); selectItem.setFunctionApproximationAllowed(functionApproximation); return selectItem;
return SelectItem.getCountAllItem(); expression = expression.substring(startParenthesis + 1, expression.length() - 1).trim(); if (function instanceof CountAggregateFunction && "*".equals(expression)) { final SelectItem selectItem = SelectItem.getCountAllItem(); selectItem.setFunctionApproximationAllowed(functionApproximation); return selectItem;
SelectItem countAllItem = SelectItem.getCountAllItem(); Query q = new Query().select(foreignColumns).select(countAllItem).from(table).groupBy( foreignColumns);
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(); }