Mongoose Select a specific field with find

Question

I m trying to select only a specific field with  exports someValue   function req  res  next          query with mongoose     var query   dbSchemas SomeValue find     select  name         query exec function  err  someValue            if  err  return next err           res send someValue                But in my json response i m receiving also the  id  my document schema only has two fiels   id and name      id  70672  name   SOME VALUE 1      id  71327  name   SOME VALUE 2      Why

User · Answer

I found a really good option in mongoose that uses distinct returns array all of a specific field in document  User find     distinct  email   then  err  emails    gt       do something

User · Answer

The  id field is always present unless you explicitly exclude it  Do so using the - syntax   exports someValue   function req  res  next          query with mongoose     var query   dbSchemas SomeValue find     select  name - id         query exec function  err  someValue            if  err  return next err           res send someValue                Or explicitly via an object   exports someValue   function req  res  next          query with mongoose     var query   dbSchemas SomeValue find     select    name   1    id   0         query exec function  err  someValue            if  err  return next err           res send someValue

User · Answer

The precise way to do this is it to  use  project   cursor method with the new mongodb and nodejs driver   var query   await dbSchemas SomeValue find     project   name  1   id  0

User · Answer

There is a shorter way of doing this now   exports someValue   function req  res  next          query with mongoose     dbSchemas SomeValue find      name   function err  someValue         if err  return next err         res send someValue                 this eliminates the  select   and  exec   methods      In case you want most of the Schema fields and want to omit only a few  you can prefix the field name with a -   For ex  -name  in the second argument will not include name field in the doc whereas the example given here will have only the name field in the returned docs

User · Answer

There s a better way to handle it using Native MongoDB code in Mongoose   exports getUsers   function req  res  next         var usersProjection                v  false           id  false             User find     usersProjection  function  err  users            if  err  return next err           res json users                   http   docs mongodb org manual reference method db collection find   Note      var usersProjection   The list of objects listed here will not be returned   printed

User · Answer

DB Data              id    70001        name    peter                 id    70002        name    john                 id    70003        name    joseph          Query  db collection find           id   0     name   1    exec  Result   gt       console log Result        Output              name    peter                name    john                name    joseph          Working sample playground  link

User · Answer

Exclude  Below code will retrieve all fields other than password within each document   const users   await UserModel find         password  0      console log users     Output              id    5dd3fb12b40da214026e0658        email    example example com          Include  Below code will only retrieve email field within each document   const users   await UserModel find         email  1     console log users     Output             email    example example com

User · Answer

Example 1  0 means ignore 1 means show User find       createdAt  0  updatedAt  0  isActive  0   id   1    then        Example 2  User findById id  select  quot  id  isActive quot   then

[javascript] Mongoose, Select a specific field with find

Examples related to javascript

Examples related to node.js

Examples related to mongodb

Examples related to mongoose