builder.column(metatada.getColumnId(groupIdx)); startIndex = 1; if (groupRequired || functionRequired) { if (ColumnType.NUMBER.equals(columnType)) { builder.column(columnId, AggregateFunctionType.SUM, uniqueColumnId); } else { builder.column(AggregateFunctionType.COUNT, uniqueCountId); builder.column(columnId, uniqueColumnId); builder.column(AggregateFunctionType.COUNT, uniqueCountId); } else { builder.column(columnId, uniqueColumnId);
builder.column(metatada.getColumnId(groupIdx)); startIndex = 1; if (groupRequired || functionRequired) { if (ColumnType.NUMBER.equals(columnType)) { builder.column(columnId, AggregateFunctionType.SUM, uniqueColumnId); } else { builder.column(AggregateFunctionType.COUNT, uniqueCountId); builder.column(columnId, uniqueColumnId); builder.column(AggregateFunctionType.COUNT, uniqueCountId); } else { builder.column(columnId, uniqueColumnId);
builder.dataset(EXPENSE_REPORTS); builder.filter(AND(filter1, OR(filter2, filter3))); builder.column(COLUMN_ID); builder.column(COLUMN_CITY); builder.column(COLUMN_DEPARTMENT); builder.column(COLUMN_EMPLOYEE); builder.column(COLUMN_AMOUNT); builder.column(COLUMN_DATE); builder.sort(COLUMN_ID, SortOrder.ASCENDING);
builder.dataset(EXPENSE_REPORTS); builder.filter(AND(filter1, OR(filter2, filter3))); builder.column(COLUMN_ID); builder.column(COLUMN_CITY); builder.column(COLUMN_DEPARTMENT); builder.column(COLUMN_EMPLOYEE); builder.column(COLUMN_AMOUNT); builder.column(COLUMN_DATE); builder.sort(COLUMN_ID, SortOrder.ASCENDING);
@Test public void testMissingGroup() { DataSetLookup lookup = DataSetLookupFactory.newDataSetLookupBuilder() .column(DATE) .column(AMOUNT, AggregateFunctionType.SUM) .buildLookup(); ValidationError error = TWO_COLUMNS_GROUPED.check(lookup, METADATA); assertNotNull(error); assertEquals(error.getCode(), DataSetLookupConstraints.ERROR_GROUP_REQUIRED); }
@Test public void testMissingGroup() { DataSetLookup lookup = DataSetLookupFactory.newDataSetLookupBuilder() .column(DATE) .column(AMOUNT, AggregateFunctionType.SUM) .buildLookup(); ValidationError error = TWO_COLUMNS_GROUPED.check(lookup, METADATA); assertNotNull(error); assertEquals(error.getCode(), DataSetLookupConstraints.ERROR_GROUP_REQUIRED); }