public static ColumnFilter greaterOrEqualsTo(Comparable ref) { return greaterOrEqualsTo(null, ref); }
public static ColumnFilter greaterOrEqualsTo(Comparable ref) { return greaterOrEqualsTo(null, ref); }
filter = FilterFactory.greaterOrEqualsTo(cg.getSourceId(), min);
filter = FilterFactory.greaterOrEqualsTo(cg.getSourceId(), min);
filter = FilterFactory.greaterOrEqualsTo(cg.getSourceId(), min);
max); } else if (min != null) { filter = FilterFactory.greaterOrEqualsTo(cg.getSourceId(), min); } else if (max != null) {
@Test(expected = RuntimeException.class) public void testFilterByNonExistingColumn() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetFactory.newDataSetLookupBuilder() .dataset(EL_DATASET_UUID) .filter("myfield", greaterOrEqualsTo(1000)) .buildLookup()); }
@Test public void testDataSetGroupByHour() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .filter(ID.getName(), FilterFactory.AND( FilterFactory.greaterOrEqualsTo(40), FilterFactory.lowerOrEqualsTo(41))) .group(DATE.getName()).dynamic(9999, DateIntervalType.HOUR, true) .column(DATE.getName()) .buildLookup()); assertThat(result.getRowCount()).isEqualTo(25); assertThat(result.getValueAt(0,0)).isEqualTo("2012-06-12 12"); }
DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .filter(greaterOrEqualsTo(COLUMN_AMOUNT, null)) .buildLookup()).getRowCount()).isEqualTo(51);
@Test public void testFilterMultiple2() throws Exception { // The order of the filter criteria does not alter the result. DataSet result = dataSetManager.lookupDataSet( DataSetFactory.newDataSetLookupBuilder() .dataset(EL_DATASET_UUID) .filter(ExpenseReportsData.COLUMN_CITY, notEqualsTo(EL_EXAMPLE_CITY_BARCELONA)) .filter(ExpenseReportsData.COLUMN_AMOUNT, greaterOrEqualsTo(1000)) .sort(ExpenseReportsData.COLUMN_ID, SortOrder.ASCENDING) .buildLookup()); assertThat(result.getRowCount()).isEqualTo(1); assertDataSetValue(result, 0, 0, "15.00"); }
@Test public void testDataSetGroupByHour() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .filter(ID.getName(), FilterFactory.AND( FilterFactory.greaterOrEqualsTo(40), FilterFactory.lowerOrEqualsTo(41))) .group(DATE.getName()).dynamic(9999, DateIntervalType.HOUR, true) .column(DATE.getName()) .buildLookup()); assertThat(result.getRowCount()).isEqualTo(25); assertThat(result.getValueAt(0,0)).isEqualTo("2012-06-12 12"); }
@Test public void testDataSetLookupMarshalling() { DataSetLookup original = DataSetLookupFactory.newDataSetLookupBuilder() .dataset("mydataset") .filter(OR(notEqualsTo("department", "IT"), greaterOrEqualsTo("amount", 100d))) .filter("department", notEqualsTo("IT")) .filter("amount", between(100d, 200d)) .filter("date", greaterThan(jsonMarshaller.parseDate("2018-01-01 00:00:00"))) .filter("country", isNull()) .group("department").select("Services") .group("date", "year").dynamic(DateIntervalType.YEAR, true) .column("date") .column("amount", AggregateFunctionType.SUM, "total") .sort("date", SortOrder.ASCENDING) .buildLookup(); JsonObject _jsonObj = jsonMarshaller.toJson(original); assertNotNull(_jsonObj.toString()); DataSetLookup unmarshalled = jsonMarshaller.fromJson(_jsonObj); assertEquals(unmarshalled, original); }
@Test public void testDataSetLookupMarshalling() { DataSetLookup original = DataSetFactory.newDataSetLookupBuilder() .dataset("mydataset") .filter(OR(notEqualsTo("department", "IT"), greaterOrEqualsTo("amount", 100d))) .filter("department", notEqualsTo("IT")) .filter("amount", between(100d, 200d)) .filter("date", greaterThan(jsonMarshaller.parseDate("2018-01-01 00:00:00"))) .filter("country", isNull()) .group("department").select("Services") .group("date", "year").dynamic(DateIntervalType.YEAR, true) .column("date") .column("amount", AggregateFunctionType.SUM, "total") .sort("date", SortOrder.ASCENDING) .buildLookup(); JsonObject _jsonObj = jsonMarshaller.toJson(original); assertNotNull(_jsonObj.toString()); DataSetLookup unmarshalled = jsonMarshaller.fromJson(_jsonObj); assertEquals(unmarshalled, original); }
DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .filter(greaterOrEqualsTo(COLUMN_AMOUNT, null)) .buildLookup()).getRowCount()).isEqualTo(51);