Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Returning specific fields with mongoose

I'm trying to accomplish something really easy but still manage to fail.

What I am trying to do is when I get a get request on my server I want to return all documents BUT just the specific fields populated.

My schema goes as follows

var clientSchema = new Schema({
    name:{
        type: String,
        required: true
    },
    phone:{
        type: String,
        required: true
    },
    email:{
        type: String,
        required: true
    },
    address: {
        type: String,
        required: false
    }
});

var orderDetailsSchema = new Schema({
    //isn't added to frontend
   confirmed:{
       type: Boolean,
       required: true,
       default: false
   },    
   service:{
       type: String,
       required: true
   },
   delivery:{
       type: String,
       required: false
   },
    payment:{
        type: String,
        required: false
    },
    status:{
        type: String,
        required: true,
        default: "new order"
    },
});

var orderSchema = new Schema({

   reference:{
       type: String,
       required: true
   },

    orderdetails: orderDetailsSchema,

    client: clientSchema,

    wheelspec: [wheelSchema],

    invoice:{
        type: Schema.Types.ObjectId,
        ref: 'Invoice'
    }


});

What I want is to return only client.phone and client.email plus orderdetails.status but still retain reference field if possible

I have tried using lean() and populate() but had no luck with them. Is there anything utterly simple I am missing? Or what I am trying to achieve is not that easy? Thanks!

like image 817
Jack Wolther Avatar asked Dec 13 '22 23:12

Jack Wolther


1 Answers

You can specify the fields to return like this:

Order.findOne({'_id' : id})
        .select('client.phone client.email orderdetails.status reference')
        .exec(function(err, order) {
        //
});

Alternative syntax

Order.findOne({'_id' : id})
    .select('client.phone client.email orderdetails.status reference')
    .exec(function(err, order) {
      //
});

I've made a number of assumptions here, but you should be able to see the idea.

like image 146
Alex Avatar answered Dec 16 '22 11:12

Alex