AG Grid JPA Adapter

QueryBuilder.builder(MasterEntity.class, MasterEntity_.id, DetailEntity.class, em)
    .masterDetail(true)
    .masterDetailParams(
        QueryBuilder.MasterDetailParams.<MasterEntity, Long, DetailEntity>builder()
            .detailClass(DetailEntity.class)
            .detailColDefs(
                ColDef.builder(DetailEntity_.detailId).build(),
                ColDef.builder(DetailEntity_.amount).build()
            )
            .detailMasterReferenceField(DetailEntity_.parentEntity) // Relationship mapping
            .build()
    )
    .build();

@Transactional(readOnly = true)
public void writeCsv(ServerSideGetRowsRequest request, Writer writer) {
    this.queryBuilder.streamRows(request).forEach(row -> writeLine(writer, row));
}

body: JSON.stringify({ ...params.request, needsGrandTotal: params.needsGrandTotal })

var colDef = ColDef.builder(Trade_.tradeId)
    .filter(new AgMultiColumnFilter<Long>()
        .filterParams(
            MultiFilterParams.<Long>builder()
                .filters(
                    new AgNumberColumnFilter<Long>(),
                    new CustomNumberFilter<Long>()
                )
                .build()
        )
    )
    .build()

var colDef = ColDef.builder(Trade_.portfolio)
    .filter(new AgTextColumnFilter()
        .filterParams(
            TextFilterParams.builder()
                .textFormatter((cb, expr) -> {
                    Expression<String> newExpression = expr;
                    // Force lowercase for case-insensitivity
                    newExpression = cb.lower(newExpression);
                    // Remove accents using SQL TRANSLATE
                    newExpression = cb.function("TRANSLATE", String.class, newExpression,
                        cb.literal("áéíóúÁÉÍÓÚüÜñÑ"),
                        cb.literal("aeiouAEIOUuUnN"));
                    
                    return newExpression;
                })
                .build()
        )
    )
    .build()

// 1. Define the Filter Model
public class CustomNumberFilterModel implements IFilterModel {
    private String value; // e.g., "Even", "Odd", or "All"
    // getters and setters
}

// 2. Define Filter Parameters
public class CustomNumberFilterParams implements IFilterParams {
    private boolean includeNullValues;
    // getters and setters
}

// 3. Implement the Filter Logic
public class CustomNumberFilter<T extends Number> extends IFilter<T, CustomNumberFilterModel, CustomNumberFilterParams> {
    
    @Override
    public CustomNumberFilterModel recognizeFilterModel(Map<String, Object> map) {
        CustomNumberFilterModel model = new CustomNumberFilterModel();
        model.setValue(map.get("value").toString());
        return model;
    }

    @Override
    public CustomNumberFilterParams getDefaultFilterParams() {
        return new CustomNumberFilterParams();
    }

    @Override
    public Predicate toPredicate(CriteriaBuilder cb, Expression<T> expression, CustomNumberFilterModel model) {
        String value = model.getValue();
        if (value == null || value.equalsIgnoreCase("All")) {
            return cb.and(); // Always true
        }

        Expression<Integer> integerExpression = expression.as(Integer.class);
        Predicate predicate;
        if (value.equalsIgnoreCase("Even")) {
            predicate = cb.equal(cb.mod(integerExpression, 2), 0);
        } else {
            predicate = cb.notEqual(cb.mod(integerExpression, 2), 0);
        }
        
        if (this.filterParams.isIncludeNullValues()) {
            predicate = cb.or(predicate, cb.isNull(expression));
        }
        
        return predicate;
    }
}