Script:
const query = req.body.data;
if(query!==''){
await User.find(
{ $or:[
{username: { "$regex": query, "$options": 'i' }},
{name: { "$regex": query, "$options": 'i' }},
{collegeName: { "$regex": query, "$options": 'i' }},
{collegeEmail: { "$regex": query, "$options": 'i' }}
], active: true},
function(err,docs) {
if(err){
console.log(err);
}else{
res.send(docs);
}
}
);
}
I find with " ( ( uername: query || name: query || collegeName: query || collegeEmail: query) && (active : true) ) " this query. but i write on above code is not working .can anybody help me??
I get my Question answer, so easy sorry...
const query = req.body.data;
if(query!==''){
await User.find({
$and:[{active: true},
{ $or:[
{username: { "$regex": query, "$options": 'i' }},
{name: { "$regex": query, "$options": 'i' }},
{collegeName: { "$regex": query, "$options": 'i' }},
{collegeEmail: { "$regex": query, "$options": 'i' }}
]}]
},
function(err,docs) {
if(err){
console.log(err);
}else{
res.send(docs);
}
}
);
}