Mongo query to fetch selective fields from the collection [duplicate]
up vote
-2
down vote
favorite
This question already has an answer here:
How to select a single field in MongoDB?
14 answers
Is it possible to fetch selective fields from mongo collections.
Say if my collections is
USer_info
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d5", "date":"2018-07-23T00:00:00.000Z", "Name":"ABC", "ID": "1234", "Subjects":"[Maths, Physics, Science, Music]"}
{"_id" : ObjectId("56e0a3a2d5hjhfjtaese45d5", "date":"2018-07-23T00:00:00.000Z", "Name":"BCS", "ID": "3456", "Subjects":"[CS, Physics, Business]"}
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d6", "date":"2018-07-23T00:00:00.000Z", "Name":"XYZ", "ID": "786", "Subjects": "[Agricultar, Business, Music]"}
Query to list only Name and SUbjects fields:
{"Name":"ABC", "Subjects":"[Maths, Physics, Science, Music]"}
{"Name":"BCS", "Subjects":"[CS, Physics, Business]"}
{"Name":"XYZ", "Subjects": "[Agricultar, Business, Music]"}
Not sure if this a duplicate, but i did not get anything similar so posting it.
mongodb mongodb-query pymongo
asked Nov 21 at 18:17
Rachel
859
marked as duplicate by Neil Lunn mongodb
Users with the mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 24 at 9:31
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
up vote
-2
down vote
favorite
This question already has an answer here:
How to select a single field in MongoDB?
14 answers
Is it possible to fetch selective fields from mongo collections.
Say if my collections is
USer_info
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d5", "date":"2018-07-23T00:00:00.000Z", "Name":"ABC", "ID": "1234", "Subjects":"[Maths, Physics, Science, Music]"}
{"_id" : ObjectId("56e0a3a2d5hjhfjtaese45d5", "date":"2018-07-23T00:00:00.000Z", "Name":"BCS", "ID": "3456", "Subjects":"[CS, Physics, Business]"}
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d6", "date":"2018-07-23T00:00:00.000Z", "Name":"XYZ", "ID": "786", "Subjects": "[Agricultar, Business, Music]"}
Query to list only Name and SUbjects fields:
{"Name":"ABC", "Subjects":"[Maths, Physics, Science, Music]"}
{"Name":"BCS", "Subjects":"[CS, Physics, Business]"}
{"Name":"XYZ", "Subjects": "[Agricultar, Business, Music]"}
Not sure if this a duplicate, but i did not get anything similar so posting it.
mongodb mongodb-query pymongo
asked Nov 21 at 18:17
Rachel
859
marked as duplicate by Neil Lunn mongodb
Users with the mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 24 at 9:31
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
up vote
-2
down vote
favorite
up vote
-2
down vote
favorite
This question already has an answer here:
How to select a single field in MongoDB?
14 answers
Is it possible to fetch selective fields from mongo collections.
Say if my collections is
USer_info
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d5", "date":"2018-07-23T00:00:00.000Z", "Name":"ABC", "ID": "1234", "Subjects":"[Maths, Physics, Science, Music]"}
{"_id" : ObjectId("56e0a3a2d5hjhfjtaese45d5", "date":"2018-07-23T00:00:00.000Z", "Name":"BCS", "ID": "3456", "Subjects":"[CS, Physics, Business]"}
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d6", "date":"2018-07-23T00:00:00.000Z", "Name":"XYZ", "ID": "786", "Subjects": "[Agricultar, Business, Music]"}
Query to list only Name and SUbjects fields:
{"Name":"ABC", "Subjects":"[Maths, Physics, Science, Music]"}
{"Name":"BCS", "Subjects":"[CS, Physics, Business]"}
{"Name":"XYZ", "Subjects": "[Agricultar, Business, Music]"}
Not sure if this a duplicate, but i did not get anything similar so posting it.
mongodb mongodb-query pymongo
asked Nov 21 at 18:17
Rachel
859
This question already has an answer here:
How to select a single field in MongoDB?
14 answers
Is it possible to fetch selective fields from mongo collections.
Say if my collections is
USer_info
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d5", "date":"2018-07-23T00:00:00.000Z", "Name":"ABC", "ID": "1234", "Subjects":"[Maths, Physics, Science, Music]"}
{"_id" : ObjectId("56e0a3a2d5hjhfjtaese45d5", "date":"2018-07-23T00:00:00.000Z", "Name":"BCS", "ID": "3456", "Subjects":"[CS, Physics, Business]"}
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d6", "date":"2018-07-23T00:00:00.000Z", "Name":"XYZ", "ID": "786", "Subjects": "[Agricultar, Business, Music]"}
Query to list only Name and SUbjects fields:
{"Name":"ABC", "Subjects":"[Maths, Physics, Science, Music]"}
{"Name":"BCS", "Subjects":"[CS, Physics, Business]"}
{"Name":"XYZ", "Subjects": "[Agricultar, Business, Music]"}
Not sure if this a duplicate, but i did not get anything similar so posting it.
This question already has an answer here:
How to select a single field in MongoDB?
14 answers
mongodb mongodb-query pymongo
mongodb mongodb-query pymongo
asked Nov 21 at 18:17
Rachel
859
asked Nov 21 at 18:17
Rachel
859
asked Nov 21 at 18:17
Rachel
859
asked Nov 21 at 18:17
Rachel
859
asked Nov 21 at 18:17
Rachel
859
859
marked as duplicate by Neil Lunn mongodb
Users with the mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 24 at 9:31
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
marked as duplicate by Neil Lunn mongodb
Users with the mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 24 at 9:31
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
You have to define projection part of .find() method to specify which fields should be returned. You alsow have to explicitly exclude _id, try:
col.find({}, { "_id": 0, "Name": 1, "Subjects": 1 })
answered Nov 21 at 18:28
mickl
10.5k51435
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
You have to define projection part of .find() method to specify which fields should be returned. You alsow have to explicitly exclude _id, try:
col.find({}, { "_id": 0, "Name": 1, "Subjects": 1 })
answered Nov 21 at 18:28
mickl
10.5k51435
add a comment |
up vote
1
down vote
accepted
You have to define projection part of .find() method to specify which fields should be returned. You alsow have to explicitly exclude _id, try:
col.find({}, { "_id": 0, "Name": 1, "Subjects": 1 })
answered Nov 21 at 18:28
mickl
10.5k51435
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
You have to define projection part of .find() method to specify which fields should be returned. You alsow have to explicitly exclude _id, try:
col.find({}, { "_id": 0, "Name": 1, "Subjects": 1 })
answered Nov 21 at 18:28
mickl
10.5k51435
You have to define projection part of .find() method to specify which fields should be returned. You alsow have to explicitly exclude _id, try:
col.find({}, { "_id": 0, "Name": 1, "Subjects": 1 })
answered Nov 21 at 18:28
mickl
10.5k51435
answered Nov 21 at 18:28
mickl
10.5k51435
answered Nov 21 at 18:28
mickl
10.5k51435
answered Nov 21 at 18:28
mickl
10.5k51435
10.5k51435
add a comment |
add a comment |
