Mixing
mongodb Filtering of content state associated with objectid in array
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
2
I want to import the data through the filtering function.
I think we should probably use 'aggregate' instead of 'find'.
The conditions for the data I want are:
There is A Collection and B Collection.
The 'contents' of A Collection points to the "_id" of B Collection.
The corresponding value is only fetched when the "Visibility" value of the B Collection is "true".
"A" Collection:
{
"_id" : ObjectId("aaaaa"),
"title" : "study list",
"contents" : [ ObjectId("11111"), ObjectId("22222") ]
}
{
"_id" : ObjectId("bbbbb"),
"title" : "study list",
"contents" : [ ObjectId("33333"), ObjectId("44444") ]
}
{
"_id" : ObjectId("ccccc"),
"title" : "study list",
"contents" : [ ObjectId("55555") ]
}
"B" Collection:
{
"_id" : ObjectId("11111"),
"visibility" : true
}
{
"_id" : ObjectId("22222"),
"visibility" : true
}
{
"_id" : ObjectId("33333"),
"visibility" : true
}
{
"_id" : ObjectId("44444"),
"visibility" : false
}
{
"_id" : ObjectId("55555"),
"visibility" : false
}
== Data Result
{
"_id" : ObjectId("aaaaa"),
"title" : "study list",
"contents" : [ ObjectId("11111"), ObjectId("22222") ]
}
How can I get the data I want?
android mongodb mongodb-query aggregation-framework edited Jan 3 at 10:41
Anthony Winzlet
18.2k42346
asked Jan 3 at 5:08
서창범서창범
274
add a comment |
2
I want to import the data through the filtering function.
I think we should probably use 'aggregate' instead of 'find'.
The conditions for the data I want are:
There is A Collection and B Collection.
The 'contents' of A Collection points to the "_id" of B Collection.
The corresponding value is only fetched when the "Visibility" value of the B Collection is "true".
"A" Collection:
{
"_id" : ObjectId("aaaaa"),
"title" : "study list",
"contents" : [ ObjectId("11111"), ObjectId("22222") ]
}
{
"_id" : ObjectId("bbbbb"),
"title" : "study list",
"contents" : [ ObjectId("33333"), ObjectId("44444") ]
}
{
"_id" : ObjectId("ccccc"),
"title" : "study list",
"contents" : [ ObjectId("55555") ]
}
"B" Collection:
{
"_id" : ObjectId("11111"),
"visibility" : true
}
{
"_id" : ObjectId("22222"),
"visibility" : true
}
{
"_id" : ObjectId("33333"),
"visibility" : true
}
{
"_id" : ObjectId("44444"),
"visibility" : false
}
{
"_id" : ObjectId("55555"),
"visibility" : false
}
== Data Result
{
"_id" : ObjectId("aaaaa"),
"title" : "study list",
"contents" : [ ObjectId("11111"), ObjectId("22222") ]
}
How can I get the data I want?
android mongodb mongodb-query aggregation-framework edited Jan 3 at 10:41
Anthony Winzlet
18.2k42346
asked Jan 3 at 5:08
서창범서창범
274
Why output is_id: ObjectId('aaa')? Contents ofObjectId("bbbbb")also containtruevalue
– Anthony Winzlet
Jan 3 at 5:29
Sorry, I can not speak English, The bottom line is what I want There is an Array in the Document, the Array has an ObjectId, ObjectId refers to the Id of another collection (B) Gets only if all of the referenced collection B's "Visibility" is true.
– 서창범
Jan 3 at 7:32
add a comment |
2
2
2
I want to import the data through the filtering function.
I think we should probably use 'aggregate' instead of 'find'.
The conditions for the data I want are:
There is A Collection and B Collection.
The 'contents' of A Collection points to the "_id" of B Collection.
The corresponding value is only fetched when the "Visibility" value of the B Collection is "true".
"A" Collection:
{
"_id" : ObjectId("aaaaa"),
"title" : "study list",
"contents" : [ ObjectId("11111"), ObjectId("22222") ]
}
{
"_id" : ObjectId("bbbbb"),
"title" : "study list",
"contents" : [ ObjectId("33333"), ObjectId("44444") ]
}
{
"_id" : ObjectId("ccccc"),
"title" : "study list",
"contents" : [ ObjectId("55555") ]
}
"B" Collection:
{
"_id" : ObjectId("11111"),
"visibility" : true
}
{
"_id" : ObjectId("22222"),
"visibility" : true
}
{
"_id" : ObjectId("33333"),
"visibility" : true
}
{
"_id" : ObjectId("44444"),
"visibility" : false
}
{
"_id" : ObjectId("55555"),
"visibility" : false
}
== Data Result
{
"_id" : ObjectId("aaaaa"),
"title" : "study list",
"contents" : [ ObjectId("11111"), ObjectId("22222") ]
}
How can I get the data I want?
android mongodb mongodb-query aggregation-framework edited Jan 3 at 10:41
Anthony Winzlet
18.2k42346
asked Jan 3 at 5:08
서창범서창범
274
I want to import the data through the filtering function.
I think we should probably use 'aggregate' instead of 'find'.
The conditions for the data I want are:
There is A Collection and B Collection.
The 'contents' of A Collection points to the "_id" of B Collection.
The corresponding value is only fetched when the "Visibility" value of the B Collection is "true".
"A" Collection:
{
"_id" : ObjectId("aaaaa"),
"title" : "study list",
"contents" : [ ObjectId("11111"), ObjectId("22222") ]
}
{
"_id" : ObjectId("bbbbb"),
"title" : "study list",
"contents" : [ ObjectId("33333"), ObjectId("44444") ]
}
{
"_id" : ObjectId("ccccc"),
"title" : "study list",
"contents" : [ ObjectId("55555") ]
}
"B" Collection:
{
"_id" : ObjectId("11111"),
"visibility" : true
}
{
"_id" : ObjectId("22222"),
"visibility" : true
}
{
"_id" : ObjectId("33333"),
"visibility" : true
}
{
"_id" : ObjectId("44444"),
"visibility" : false
}
{
"_id" : ObjectId("55555"),
"visibility" : false
}
== Data Result
{
"_id" : ObjectId("aaaaa"),
"title" : "study list",
"contents" : [ ObjectId("11111"), ObjectId("22222") ]
}
How can I get the data I want?
android mongodb mongodb-query aggregation-framework android mongodb mongodb-query aggregation-framework edited Jan 3 at 10:41
Anthony Winzlet
18.2k42346
asked Jan 3 at 5:08
서창범서창범
274
edited Jan 3 at 10:41
Anthony Winzlet
18.2k42346
asked Jan 3 at 5:08
서창범서창범
274
edited Jan 3 at 10:41
Anthony Winzlet
18.2k42346
edited Jan 3 at 10:41
Anthony Winzlet
18.2k42346
edited Jan 3 at 10:41
Anthony Winzlet
18.2k42346
18.2k42346
asked Jan 3 at 5:08
서창범서창범
274
asked Jan 3 at 5:08
서창범서창범
274
asked Jan 3 at 5:08
서창범서창범
274
274
Why output is_id: ObjectId('aaa')? Contents ofObjectId("bbbbb")also containtruevalue
– Anthony Winzlet
Jan 3 at 5:29
Sorry, I can not speak English, The bottom line is what I want There is an Array in the Document, the Array has an ObjectId, ObjectId refers to the Id of another collection (B) Gets only if all of the referenced collection B's "Visibility" is true.
– 서창범
Jan 3 at 7:32
add a comment |
Why output is_id: ObjectId('aaa')? Contents ofObjectId("bbbbb")also containtruevalue
– Anthony Winzlet
Jan 3 at 5:29
Sorry, I can not speak English, The bottom line is what I want There is an Array in the Document, the Array has an ObjectId, ObjectId refers to the Id of another collection (B) Gets only if all of the referenced collection B's "Visibility" is true.
– 서창범
Jan 3 at 7:32
Why output is
_id: ObjectId('aaa') ? Contents of ObjectId("bbbbb") also contain true value– Anthony Winzlet
Jan 3 at 5:29
Why output is
_id: ObjectId('aaa') ? Contents of ObjectId("bbbbb") also contain true value– Anthony Winzlet
Jan 3 at 5:29
Sorry, I can not speak English, The bottom line is what I want There is an Array in the Document, the Array has an ObjectId, ObjectId refers to the Id of another collection (B) Gets only if all of the referenced collection B's "Visibility" is true.
– 서창범
Jan 3 at 7:32
Sorry, I can not speak English, The bottom line is what I want There is an Array in the Document, the Array has an ObjectId, ObjectId refers to the Id of another collection (B) Gets only if all of the referenced collection B's "Visibility" is true.
– 서창범
Jan 3 at 7:32
add a comment |
1 Answer
1
active
oldest
votes
1
You can use below aggregation
db.collectionA.aggregate([
{ "$lookup": {
"from": "collectionB",
"localField": "contents",
"foreignField": "_id",
"as": "data"
}},
{ "$match": {
"data": {
"$not": {
"$elemMatch": { "visibility": false }
}
}
}}
])
answered Jan 3 at 7:40
Anthony WinzletAnthony Winzlet
18.2k42346
Thank You, This is the answer I wanted. I learned a lot.
– 서창범
Jan 3 at 7:47
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54016647%2fmongodb-filtering-of-content-state-associated-with-objectid-in-array%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
You can use below aggregation
db.collectionA.aggregate([
{ "$lookup": {
"from": "collectionB",
"localField": "contents",
"foreignField": "_id",
"as": "data"
}},
{ "$match": {
"data": {
"$not": {
"$elemMatch": { "visibility": false }
}
}
}}
])
answered Jan 3 at 7:40
Anthony WinzletAnthony Winzlet
18.2k42346
Thank You, This is the answer I wanted. I learned a lot.
– 서창범
Jan 3 at 7:47
add a comment |
1
You can use below aggregation
db.collectionA.aggregate([
{ "$lookup": {
"from": "collectionB",
"localField": "contents",
"foreignField": "_id",
"as": "data"
}},
{ "$match": {
"data": {
"$not": {
"$elemMatch": { "visibility": false }
}
}
}}
])
answered Jan 3 at 7:40
Anthony WinzletAnthony Winzlet
18.2k42346
Thank You, This is the answer I wanted. I learned a lot.
– 서창범
Jan 3 at 7:47
add a comment |
1
1
1
You can use below aggregation
db.collectionA.aggregate([
{ "$lookup": {
"from": "collectionB",
"localField": "contents",
"foreignField": "_id",
"as": "data"
}},
{ "$match": {
"data": {
"$not": {
"$elemMatch": { "visibility": false }
}
}
}}
])
answered Jan 3 at 7:40
Anthony WinzletAnthony Winzlet
18.2k42346
You can use below aggregation
db.collectionA.aggregate([
{ "$lookup": {
"from": "collectionB",
"localField": "contents",
"foreignField": "_id",
"as": "data"
}},
{ "$match": {
"data": {
"$not": {
"$elemMatch": { "visibility": false }
}
}
}}
])
answered Jan 3 at 7:40
Anthony WinzletAnthony Winzlet
18.2k42346
answered Jan 3 at 7:40
Anthony WinzletAnthony Winzlet
18.2k42346
answered Jan 3 at 7:40
Anthony WinzletAnthony Winzlet
18.2k42346
answered Jan 3 at 7:40
Anthony WinzletAnthony Winzlet
18.2k42346
18.2k42346
Thank You, This is the answer I wanted. I learned a lot.
– 서창범
Jan 3 at 7:47
add a comment |
Thank You, This is the answer I wanted. I learned a lot.
– 서창범
Jan 3 at 7:47
Thank You, This is the answer I wanted. I learned a lot.
– 서창범
Jan 3 at 7:47
Thank You, This is the answer I wanted. I learned a lot.
– 서창범
Jan 3 at 7:47
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54016647%2fmongodb-filtering-of-content-state-associated-with-objectid-in-array%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Why output is
_id: ObjectId('aaa')? Contents ofObjectId("bbbbb")also containtruevalue– Anthony Winzlet
Jan 3 at 5:29
Sorry, I can not speak English, The bottom line is what I want There is an Array in the Document, the Array has an ObjectId, ObjectId refers to the Id of another collection (B) Gets only if all of the referenced collection B's "Visibility" is true.
– 서창범
Jan 3 at 7:32