select only two fields in mongodb using monk

Question

My document has around 20 fields in it

I want to select only 2 fields and ignore other fields

I tried the below code as suggested here

collection. find({}, {  Name: 1, District: 1,_id:0},{limit:5}, function (e, docs) {
        res.json(docs);
    });

But its returning all fields. I want to get only name and district.

i.e I have Name,District,Country,Pincode,PhoneNumber, emailId,photo and many other fields. I want to select only Name and District.

P.S I am looking for ways other than giving all other field names as 0

I am using Monk

Which library? I suspect you also mean that either "Name" or "Distrinct" here actually has embedded fields you are trying to exclude, which is not clearly stated without an example. — Blakes Seven, Aug 13 '15 at 11:04
I am using Monk. I have added the details in the question now — Vignesh Subramanian, Aug 13 '15 at 11:13

score 4 · Accepted Answer · answered Aug 13 '15 at 13:25

4

When using Monk, pass the fields to select as a string containing space-delimited field names, using a - prefix to exclude a field.

collection.find({}, 'Name District -_id', function (e, docs) {
    res.json(docs);
});

You can also pass the field selections as an array of strings:

collection.find({}, ['Name', 'District', '-_id'], function (e, docs) {
    res.json(docs);
});

answered Aug 13 '15 at 13:25

JohnnyHK

305,182
66
621
471

I am getting this error `fn should be a function` should i add it after all the options? – Vignesh Subramanian Aug 24 '15 at 05:33
@vignesh Yes, the callback function parameter always goes last. – JohnnyHK Aug 24 '15 at 05:38
I used this query and its throwing the same error `collection. find({} , { limit: 5 ,skip:5*buffer}, 'Name -_id', function (e, docs) { res.json(docs); });` – Vignesh Subramanian Aug 24 '15 at 05:42
@vignesh You really shouldn't be changing your question after you've gotten an answer to your original question. Options go after the field selection parameter and before the callback. – JohnnyHK Aug 24 '15 at 05:50
ok I have accepted the answer thanks. i thought a new question would be a repetition of this – Vignesh Subramanian Aug 24 '15 at 05:53
is it possible to select name age and _id and eliminate the rest? – Vignesh Subramanian Aug 24 '15 at 06:35
This answer does not include the "limit" part. – Laggel Oct 07 '15 at 13:53

score 1 · Answer 2 · answered Aug 13 '15 at 13:01

1

Have you tried:

db.<collection>.find({},{"Name": 1, "District": 1})

answered Aug 13 '15 at 13:01

robjwilkins

5,462
5
43
59

IrfanAnwar · Answer 3 · 2017-02-02T09:36:44.743

While using monk, I prefer something like this

query={'userType':'crew'}; // condition to select users
query2=['_id' ,'firstname' , 'lastname'] ; //Array, Limit the fields to retrieve 
collection.find(query,query2, function(error,crew){
    if(error)
        response.send(error)
    else {
        response.send(crew);
    }
});

Please note that it is better to include "_id" otherwise ng-repeat will cause issues and you will have to iterate it using $index . Hope it helps

score 0 · Answer 4 · answered Aug 13 '21 at 10:59

0

collection.find().select('field1,field2').then((data) =>{res.send(data)})

answered Aug 13 '21 at 10:59

Meet Pandit

1
1

1

Welcome to Stack Overflow, and thank you for contributing an answer. Would you kindly edit your answer to to include an explanation of your code? That will help future readers better understand what is going on, and especially those members of the community who are new to the language and struggling to understand the concepts. That's especially important when there's already an accepted answer that's been validated by the community. Under what conditions might your approach be preferred? Are you taking advantage of new capabilities? – Jeremy Caney Aug 13 '21 at 20:02

select only two fields in mongodb using monk

4 Answers4