How to skip a document based on condition in mongodb aggregation
Let say I have a schema of blog post which contain many keys and one of them is author (ObjectId). Now I have an another collection of Block users which contains two keys: userid (ObjectId) and userWhoHasBeenBlocked (ObjectId).
Now in aggregation I want to skip those collection which has a author equals to the userWhoHasBeenBlocked.
My Approch: First level I have a match query which chcecks the country from which the post has been made. Let say there is a key of a country.
After this I have a $lookup query for block user collection as
{ $match: { country: "usa" } },
{
$lookup:
{
from: "ublocks",
let: { whoHasBeenBlocked: "$author", currentUser: userid },
pipeline: [
{
$match:
{
$expr:
{
$and:
[
{ $eq: ["$blockedUser", "$$whoHasBeenBlocked"] },
]
}
}
},
],
as: "isBlocked"
},
}
},
{ $match: { "$author": { $ne: "$isBlocked.userId" } } }
}
after this I have $projection block. this is not working. How to skip a document within aggregation. I also have pagination after this.
node.js mongodb mongoose mongodb-query aggregation-framework
asked Nov 23 '18 at 16:21
user9009353user9009353
793
add a comment |
Let say I have a schema of blog post which contain many keys and one of them is author (ObjectId). Now I have an another collection of Block users which contains two keys: userid (ObjectId) and userWhoHasBeenBlocked (ObjectId).
Now in aggregation I want to skip those collection which has a author equals to the userWhoHasBeenBlocked.
My Approch: First level I have a match query which chcecks the country from which the post has been made. Let say there is a key of a country.
After this I have a $lookup query for block user collection as
{ $match: { country: "usa" } },
{
$lookup:
{
from: "ublocks",
let: { whoHasBeenBlocked: "$author", currentUser: userid },
pipeline: [
{
$match:
{
$expr:
{
$and:
[
{ $eq: ["$blockedUser", "$$whoHasBeenBlocked"] },
]
}
}
},
],
as: "isBlocked"
},
}
},
{ $match: { "$author": { $ne: "$isBlocked.userId" } } }
}
after this I have $projection block. this is not working. How to skip a document within aggregation. I also have pagination after this.
node.js mongodb mongoose mongodb-query aggregation-framework
asked Nov 23 '18 at 16:21
user9009353user9009353
793
1
Could you post the sample collections and the desired output
– Anthony Winzlet
Nov 23 '18 at 18:17
I just want to skip the collection which matches the condition.
– user9009353
Nov 23 '18 at 18:33
I read that. I just want to know the exact field names so that it can be answered at once
– Anthony Winzlet
Nov 23 '18 at 18:46
I have solved that issue, I have made a condition on $projection that will return true/false to the projection field. After that I have made a $match to fetch only those collection which has key with true values. Thanks
– user9009353
Nov 24 '18 at 19:13
Just put either an answer or delete the question.
– Anthony Winzlet
Nov 24 '18 at 19:51
add a comment |
Let say I have a schema of blog post which contain many keys and one of them is author (ObjectId). Now I have an another collection of Block users which contains two keys: userid (ObjectId) and userWhoHasBeenBlocked (ObjectId).
Now in aggregation I want to skip those collection which has a author equals to the userWhoHasBeenBlocked.
My Approch: First level I have a match query which chcecks the country from which the post has been made. Let say there is a key of a country.
After this I have a $lookup query for block user collection as
{ $match: { country: "usa" } },
{
$lookup:
{
from: "ublocks",
let: { whoHasBeenBlocked: "$author", currentUser: userid },
pipeline: [
{
$match:
{
$expr:
{
$and:
[
{ $eq: ["$blockedUser", "$$whoHasBeenBlocked"] },
]
}
}
},
],
as: "isBlocked"
},
}
},
{ $match: { "$author": { $ne: "$isBlocked.userId" } } }
}
after this I have $projection block. this is not working. How to skip a document within aggregation. I also have pagination after this.
node.js mongodb mongoose mongodb-query aggregation-framework
asked Nov 23 '18 at 16:21
user9009353user9009353
793
Let say I have a schema of blog post which contain many keys and one of them is author (ObjectId). Now I have an another collection of Block users which contains two keys: userid (ObjectId) and userWhoHasBeenBlocked (ObjectId).
Now in aggregation I want to skip those collection which has a author equals to the userWhoHasBeenBlocked.
My Approch: First level I have a match query which chcecks the country from which the post has been made. Let say there is a key of a country.
After this I have a $lookup query for block user collection as
{ $match: { country: "usa" } },
{
$lookup:
{
from: "ublocks",
let: { whoHasBeenBlocked: "$author", currentUser: userid },
pipeline: [
{
$match:
{
$expr:
{
$and:
[
{ $eq: ["$blockedUser", "$$whoHasBeenBlocked"] },
]
}
}
},
],
as: "isBlocked"
},
}
},
{ $match: { "$author": { $ne: "$isBlocked.userId" } } }
}
after this I have $projection block. this is not working. How to skip a document within aggregation. I also have pagination after this.
node.js mongodb mongoose mongodb-query aggregation-framework
node.js mongodb mongoose mongodb-query aggregation-framework
asked Nov 23 '18 at 16:21
user9009353user9009353
793
asked Nov 23 '18 at 16:21
user9009353user9009353
793
asked Nov 23 '18 at 16:21
user9009353user9009353
793
asked Nov 23 '18 at 16:21
user9009353user9009353
793
asked Nov 23 '18 at 16:21
user9009353user9009353
793
793
1
Could you post the sample collections and the desired output
– Anthony Winzlet
Nov 23 '18 at 18:17
I just want to skip the collection which matches the condition.
– user9009353
Nov 23 '18 at 18:33
I read that. I just want to know the exact field names so that it can be answered at once
– Anthony Winzlet
Nov 23 '18 at 18:46
I have solved that issue, I have made a condition on $projection that will return true/false to the projection field. After that I have made a $match to fetch only those collection which has key with true values. Thanks
– user9009353
Nov 24 '18 at 19:13
Just put either an answer or delete the question.
– Anthony Winzlet
Nov 24 '18 at 19:51
add a comment |
1
Could you post the sample collections and the desired output
– Anthony Winzlet
Nov 23 '18 at 18:17
I just want to skip the collection which matches the condition.
– user9009353
Nov 23 '18 at 18:33
I read that. I just want to know the exact field names so that it can be answered at once
– Anthony Winzlet
Nov 23 '18 at 18:46
I have solved that issue, I have made a condition on $projection that will return true/false to the projection field. After that I have made a $match to fetch only those collection which has key with true values. Thanks
– user9009353
Nov 24 '18 at 19:13
Just put either an answer or delete the question.
– Anthony Winzlet
Nov 24 '18 at 19:51
1
1
Could you post the sample collections and the desired output
– Anthony Winzlet
Nov 23 '18 at 18:17
Could you post the sample collections and the desired output
– Anthony Winzlet
Nov 23 '18 at 18:17
I just want to skip the collection which matches the condition.
– user9009353
Nov 23 '18 at 18:33
I just want to skip the collection which matches the condition.
– user9009353
Nov 23 '18 at 18:33
I read that. I just want to know the exact field names so that it can be answered at once
– Anthony Winzlet
Nov 23 '18 at 18:46
I read that. I just want to know the exact field names so that it can be answered at once
– Anthony Winzlet
Nov 23 '18 at 18:46
I have solved that issue, I have made a condition on $projection that will return true/false to the projection field. After that I have made a $match to fetch only those collection which has key with true values. Thanks
– user9009353
Nov 24 '18 at 19:13
I have solved that issue, I have made a condition on $projection that will return true/false to the projection field. After that I have made a $match to fetch only those collection which has key with true values. Thanks
– user9009353
Nov 24 '18 at 19:13
Just put either an answer or delete the question.
– Anthony Winzlet
Nov 24 '18 at 19:51
Just put either an answer or delete the question.
– Anthony Winzlet
Nov 24 '18 at 19:51
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f53450025%2fhow-to-skip-a-document-based-on-condition-in-mongodb-aggregation%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f53450025%2fhow-to-skip-a-document-based-on-condition-in-mongodb-aggregation%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
1
Could you post the sample collections and the desired output
– Anthony Winzlet
Nov 23 '18 at 18:17
I just want to skip the collection which matches the condition.
– user9009353
Nov 23 '18 at 18:33
I read that. I just want to know the exact field names so that it can be answered at once
– Anthony Winzlet
Nov 23 '18 at 18:46
I have solved that issue, I have made a condition on $projection that will return true/false to the projection field. After that I have made a $match to fetch only those collection which has key with true values. Thanks
– user9009353
Nov 24 '18 at 19:13
Just put either an answer or delete the question.
– Anthony Winzlet
Nov 24 '18 at 19:51