Thursday, 12 September 2013

BreezeJS - Regular expression in Where Clause

BreezeJS - Regular expression in Where Clause

I'm trying to do something like:
var predicate = breeze.Predicate.create('columnName',
breeze.FilterQueryOp.Contains, 'regexHere');
manager.executeQuery(entityQuery.From('tableName').where(predicate));
It all works fine when I try to search it "normal" way, but I'd like to
include regex search that would work as sql LIKE operator. Mostly, I'm
interested in how to make clause similar to sqls:
WHERE columnName LIKE '%abc%def%'
Is that possible with Breeze?

No comments:

Post a Comment