public Predicate addFilter(
Root<UserEntity> root, FilterConstraint constraint, String value, CriteriaBuilder cb) {
if (constraint != FilterConstraint.PRESENT
&& (field.getType() == ExtensionFieldType.INTEGER
|| field.getType() == ExtensionFieldType.DECIMAL)) {
value = numberPadder.pad(value);
}
final SetJoin<UserEntity, ExtensionFieldValueEntity> join =
createOrGetJoin(
generateAlias(urn + "." + field.getName()), root, UserEntity_.extensionFieldValues);
Predicate filterPredicate =
constraint.createPredicateForExtensionField(
join.get(ExtensionFieldValueEntity_.value), value, field, cb);
Predicate valueBelongsToField =
cb.equal(
join.get(ExtensionFieldValueEntity_.extensionField)
.get(ExtensionFieldEntity_.internalId),
field.getInternalId());
join.on(valueBelongsToField);
return filterPredicate;
}
NativeEvaluator createEvaluator(RolapEvaluator evaluator, FunDef fun, Exp[] args) {
if (!isEnabled()) {
return null;
}
if (!FilterConstraint.isValidContext(evaluator, restrictMemberTypes())) {
return null;
}
// is this "Filter(<set>, <numeric expr>)"
String funName = fun.getName();
if (!"Filter".equalsIgnoreCase(funName)) {
return null;
}
if (args.length != 2) {
return null;
}
// extract the set expression
List<CrossJoinArg[]> allArgs = crossJoinArgFactory().checkCrossJoinArg(evaluator, args[0]);
// checkCrossJoinArg returns a list of CrossJoinArg arrays. The first
// array is the CrossJoin dimensions. The second array, if any,
// contains additional constraints on the dimensions. If either the
// list or the first array is null, then native cross join is not
// feasible.
if (allArgs == null || allArgs.isEmpty() || allArgs.get(0) == null) {
return null;
}
CrossJoinArg[] cjArgs = allArgs.get(0);
if (isPreferInterpreter(cjArgs, false)) {
return null;
}
// extract "order by" expression
SchemaReader schemaReader = evaluator.getSchemaReader();
DataSource ds = schemaReader.getDataSource();
// generate the WHERE condition
// Need to generate where condition here to determine whether
// or not the filter condition can be created. The filter
// condition could change to use an aggregate table later in evaluation
SqlQuery sqlQuery = SqlQuery.newQuery(ds, "NativeFilter");
RolapNativeSql sql = new RolapNativeSql(sqlQuery, null, evaluator, cjArgs[0].getLevel());
final Exp filterExpr = args[1];
String filterExprStr = sql.generateFilterCondition(filterExpr);
if (filterExprStr == null) {
return null;
}
// Check to see if evaluator contains a calculated member that can't be
// expanded. This is necessary due to the SqlConstraintsUtils.
// addContextConstraint()
// method which gets called when generating the native SQL.
if (SqlConstraintUtils.containsCalculatedMember(evaluator.getNonAllMembers(), true)) {
return null;
}
LOGGER.debug("using native filter");
final int savepoint = evaluator.savepoint();
try {
overrideContext(evaluator, cjArgs, sql.getStoredMeasure());
// Now construct the TupleConstraint that contains both the CJ
// dimensions and the additional filter on them.
CrossJoinArg[] combinedArgs = cjArgs;
if (allArgs.size() == 2) {
CrossJoinArg[] predicateArgs = allArgs.get(1);
if (predicateArgs != null) {
// Combined the CJ and the additional predicate args.
combinedArgs = Util.appendArrays(cjArgs, predicateArgs);
}
}
TupleConstraint constraint = new FilterConstraint(combinedArgs, evaluator, filterExpr);
return new SetEvaluator(cjArgs, schemaReader, constraint);
} finally {
evaluator.restore(savepoint);
}
}
