tingodb icon indicating copy to clipboard operation
tingodb copied to clipboard

$in : [ /^regex$/i] not returning expected records

Open ganna-shmatova opened this issue 9 years ago • 0 comments

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: image


I have searchInArray to true:

var Db = tingo({searchInArray: true}).Db;
idb.db = new Db(idb.dataFolder, {});

ganna-shmatova avatar Feb 03 '16 16:02 ganna-shmatova