tingodb
tingodb copied to clipboard
$in : [ /^regex$/i] not returning expected records
Should work in mongo: https://docs.mongodb.org/manual/reference/operator/query/regex/#in-expressions
this.db.collection('user').find({ //returns []
Username: {$in: [new RegExp('^'+escape('Admin')+'$', 'i')]}
}, {}).toArray(function(err, data){
log.trace(err);
log.trace(data);
});
this.db.collection('user').find({ //returns correct record
Username: new RegExp('^'+escape('Admin')+'$', 'i')
}, {}).toArray(function(err, data){
log.trace(err);
log.trace(data);
});
output:
I have searchInArray to true:
var Db = tingo({searchInArray: true}).Db;
idb.db = new Db(idb.dataFolder, {});