Node Mongo - find multiple parameters

Question

I'm trying to find in a collection if there is already a session number, to avoid duplications. dadosORS.email and dadosORS.sessao (which is 3)come from a form. So when I do this:

mongoClient.collection('registosORS', function(err,collection){
  collection.find({email:{$eq:dadosORS.email}},{sessao:{$eq:dadosORS.sessao}}).toArray(function(err,result){

                    try{
                    console.log(result);
                    }catch (err){
                      console.log(err);                          
                    }

                      if(result){
                        // callback(false)
                        return
                      } else {

I get result = undefined. If I change the query to

 collection.find({email:dadosORS.email},{sessao:dadosORS.sessao}).toArray(function(err,result){

it lists my every occurence of the email:

      [ { _id: 5a37b4c3da53ff1e825f94b4, sessao: '1' },
{ _id: 5a37b4e6da53ff1e825f94b6, sessao: '1' },
    { _id: 5a37b57ce500ca1ea5522e22, sessao: '2' } ]

So, how can I see if the dadosORS.sessao for that dadosORS.email already exists?

Kevin Smith · Accepted Answer · 2017-12-18 15:28:44Z

1

Just do an and query:

 collection.find( { email : dadosORS.email, sessao : dadosORS.sessao } )

or can be expressed as

 collection.find( { $and: [ { email : dadosORS.email }, { sessao : dadosORS.sessao } ] } )

answered Dec 18, 2017 at 15:28

Kevin Smith

14.5k5 gold badges63 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Node Mongo - find multiple parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related