javascript - querying MongoDb with nodejs -


i have situation here. have ajax call used query value , return. in js file gave this

function getlogindata(){     debugger;     var getusername=$("#inputusername").val();     $.ajax({         url:'/users/loginvalidation',         datatype:'json',         data:{"uname":getusername},         type:'post',         async:false,         success:function(data){             debugger;         }     }) }  

in users.js file in routes gave this

router.post('/loginvalidation',function(req,res){     var db=req.db;     var getname=req.body.uname;     db.collection("users").find({"name":getname},{"type":{$in: [ "admin", "owner" ]}}).toarray(function(err,result){         res.json(result);     })  }) 
  1. my requirement want check in users collection containing name in "getname" variable
  2. along want check whether name of type "admin" or "owner".
  3. if both these conditions don't satisfy return error message

my user collection this

{ "_id" : 1, "name" : "rohith", "type" : "admin" } { "_id" : 2, "name" : "kumar", "type" : "owner" } { "_id" : 3, "name" : "krishna", "type" : "sales" } { "_id" : 4, "name" : "nikhil", "type" : "sales" } { "_id" : 5, "name" : "don", "type" : "admin" } 

now getting null value in success of ajax call... thanks

use $and, this:

db.collection("users")     .find({"$and": [         {"name": getname},         {"type": {"$in": [ "admin", "owner" ]}     ]})     .toarray(function(err,result){         if (!err && !result) err = 'no results';         if (err) return res.send(500, err);         res.json(result);     }) 

Comments

Popular posts from this blog

java - How to specify maven bin in eclipse maven plugin? -

single sign on - Logging into Plone site with credentials passed through HTTP -

php - Why does AJAX not process login form? -