Mongo query for the below result
0
I have a scenario where I want to find all the documents where the same value exists for different transaction ID’s. If the value exists in two documents for the same transactionID’s then it should not print those documents.
Below are few sample documents.
Document 1:
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
Document 2:
{
"_id" : 2,
"trxId" : “efgh”,
“transactionID” : “5678”,
“Value” : “abcd”
}
Document 3:
{
"_id" : 1,
"trxId" : “ijkl”,
“transactionID” : “12345”,
“Value” : “abcd1234hjgn”
}
Document 4:
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
The query should print only document 1 and document 2 because “Value” : “abcd1234hjgn” exists for two different transactionID’s.
The result should be below. How do I accomplish this?
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
{
"_id" : 1,
"trxId" : “ijkl”,
“transactionID” : “12345”,
“Value” : “abcd1234hjgn”
}
mongodb mongodb-query
edited Nov 17 '18 at 4:54
Anthony Winzlet
14.7k41339
asked Nov 16 '18 at 22:40
SSKSSK
135
add a comment |
0
I have a scenario where I want to find all the documents where the same value exists for different transaction ID’s. If the value exists in two documents for the same transactionID’s then it should not print those documents.
Below are few sample documents.
Document 1:
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
Document 2:
{
"_id" : 2,
"trxId" : “efgh”,
“transactionID” : “5678”,
“Value” : “abcd”
}
Document 3:
{
"_id" : 1,
"trxId" : “ijkl”,
“transactionID” : “12345”,
“Value” : “abcd1234hjgn”
}
Document 4:
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
The query should print only document 1 and document 2 because “Value” : “abcd1234hjgn” exists for two different transactionID’s.
The result should be below. How do I accomplish this?
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
{
"_id" : 1,
"trxId" : “ijkl”,
“transactionID” : “12345”,
“Value” : “abcd1234hjgn”
}
mongodb mongodb-query
edited Nov 17 '18 at 4:54
Anthony Winzlet
14.7k41339
asked Nov 16 '18 at 22:40
SSKSSK
135
add a comment |
0
0
0
I have a scenario where I want to find all the documents where the same value exists for different transaction ID’s. If the value exists in two documents for the same transactionID’s then it should not print those documents.
Below are few sample documents.
Document 1:
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
Document 2:
{
"_id" : 2,
"trxId" : “efgh”,
“transactionID” : “5678”,
“Value” : “abcd”
}
Document 3:
{
"_id" : 1,
"trxId" : “ijkl”,
“transactionID” : “12345”,
“Value” : “abcd1234hjgn”
}
Document 4:
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
The query should print only document 1 and document 2 because “Value” : “abcd1234hjgn” exists for two different transactionID’s.
The result should be below. How do I accomplish this?
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
{
"_id" : 1,
"trxId" : “ijkl”,
“transactionID” : “12345”,
“Value” : “abcd1234hjgn”
}
mongodb mongodb-query
edited Nov 17 '18 at 4:54
Anthony Winzlet
14.7k41339
asked Nov 16 '18 at 22:40
SSKSSK
135
I have a scenario where I want to find all the documents where the same value exists for different transaction ID’s. If the value exists in two documents for the same transactionID’s then it should not print those documents.
Below are few sample documents.
Document 1:
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
Document 2:
{
"_id" : 2,
"trxId" : “efgh”,
“transactionID” : “5678”,
“Value” : “abcd”
}
Document 3:
{
"_id" : 1,
"trxId" : “ijkl”,
“transactionID” : “12345”,
“Value” : “abcd1234hjgn”
}
Document 4:
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
The query should print only document 1 and document 2 because “Value” : “abcd1234hjgn” exists for two different transactionID’s.
The result should be below. How do I accomplish this?
{
"_id" : 1,
"trxId" : “abcd”,
“transactionID” : “1234”,
“Value” : “abcd1234hjgn”
}
{
"_id" : 1,
"trxId" : “ijkl”,
“transactionID” : “12345”,
“Value” : “abcd1234hjgn”
}
mongodb mongodb-query
mongodb mongodb-query
edited Nov 17 '18 at 4:54
Anthony Winzlet
14.7k41339
asked Nov 16 '18 at 22:40
SSKSSK
135
edited Nov 17 '18 at 4:54
Anthony Winzlet
14.7k41339
asked Nov 16 '18 at 22:40
SSKSSK
135
edited Nov 17 '18 at 4:54
Anthony Winzlet
14.7k41339
edited Nov 17 '18 at 4:54
Anthony Winzlet
14.7k41339
edited Nov 17 '18 at 4:54
Anthony Winzlet
14.7k41339
14.7k41339
asked Nov 16 '18 at 22:40
SSKSSK
135
asked Nov 16 '18 at 22:40
SSKSSK
135
asked Nov 16 '18 at 22:40
SSKSSK
135
135
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
0
This is a long winded way but it gets to the result.
db.getCollection("stackoverflow").aggregate(
// Pipeline
[
// Stage 1
{
$group: {
_id: '$Value',
records: {
$push: {
trxId: '$trxId',
transactionID: '$transactionID',
Value: '$Value',
_id: '$_id'
}
}
}
},
// Stage 2
{
$addFields: {
duplicates: {
$size: "$records"
}
}
},
// Stage 3
{
$match: {
duplicates: {
$gt: 1
}
}
},
// Stage 4
{
$unwind: {
path: "$records"
}
},
// Stage 5
{
$project: {
_id: '$records._id',
transactionID: '$records.transactionID',
Value: '$records.Value',
trxld: '$records.trxId'
}
},
]
);answered Nov 17 '18 at 2:36
Aadhi ViveAadhi Vive
6511
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%2f53346354%2fmongo-query-for-the-below-result%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
0
This is a long winded way but it gets to the result.
db.getCollection("stackoverflow").aggregate(
// Pipeline
[
// Stage 1
{
$group: {
_id: '$Value',
records: {
$push: {
trxId: '$trxId',
transactionID: '$transactionID',
Value: '$Value',
_id: '$_id'
}
}
}
},
// Stage 2
{
$addFields: {
duplicates: {
$size: "$records"
}
}
},
// Stage 3
{
$match: {
duplicates: {
$gt: 1
}
}
},
// Stage 4
{
$unwind: {
path: "$records"
}
},
// Stage 5
{
$project: {
_id: '$records._id',
transactionID: '$records.transactionID',
Value: '$records.Value',
trxld: '$records.trxId'
}
},
]
);answered Nov 17 '18 at 2:36
Aadhi ViveAadhi Vive
6511
add a comment |
0
This is a long winded way but it gets to the result.
db.getCollection("stackoverflow").aggregate(
// Pipeline
[
// Stage 1
{
$group: {
_id: '$Value',
records: {
$push: {
trxId: '$trxId',
transactionID: '$transactionID',
Value: '$Value',
_id: '$_id'
}
}
}
},
// Stage 2
{
$addFields: {
duplicates: {
$size: "$records"
}
}
},
// Stage 3
{
$match: {
duplicates: {
$gt: 1
}
}
},
// Stage 4
{
$unwind: {
path: "$records"
}
},
// Stage 5
{
$project: {
_id: '$records._id',
transactionID: '$records.transactionID',
Value: '$records.Value',
trxld: '$records.trxId'
}
},
]
);answered Nov 17 '18 at 2:36
Aadhi ViveAadhi Vive
6511
add a comment |
0
0
0
This is a long winded way but it gets to the result.
db.getCollection("stackoverflow").aggregate(
// Pipeline
[
// Stage 1
{
$group: {
_id: '$Value',
records: {
$push: {
trxId: '$trxId',
transactionID: '$transactionID',
Value: '$Value',
_id: '$_id'
}
}
}
},
// Stage 2
{
$addFields: {
duplicates: {
$size: "$records"
}
}
},
// Stage 3
{
$match: {
duplicates: {
$gt: 1
}
}
},
// Stage 4
{
$unwind: {
path: "$records"
}
},
// Stage 5
{
$project: {
_id: '$records._id',
transactionID: '$records.transactionID',
Value: '$records.Value',
trxld: '$records.trxId'
}
},
]
);answered Nov 17 '18 at 2:36
Aadhi ViveAadhi Vive
6511
This is a long winded way but it gets to the result.
db.getCollection("stackoverflow").aggregate(
// Pipeline
[
// Stage 1
{
$group: {
_id: '$Value',
records: {
$push: {
trxId: '$trxId',
transactionID: '$transactionID',
Value: '$Value',
_id: '$_id'
}
}
}
},
// Stage 2
{
$addFields: {
duplicates: {
$size: "$records"
}
}
},
// Stage 3
{
$match: {
duplicates: {
$gt: 1
}
}
},
// Stage 4
{
$unwind: {
path: "$records"
}
},
// Stage 5
{
$project: {
_id: '$records._id',
transactionID: '$records.transactionID',
Value: '$records.Value',
trxld: '$records.trxId'
}
},
]
);db.getCollection("stackoverflow").aggregate(
// Pipeline
[
// Stage 1
{
$group: {
_id: '$Value',
records: {
$push: {
trxId: '$trxId',
transactionID: '$transactionID',
Value: '$Value',
_id: '$_id'
}
}
}
},
// Stage 2
{
$addFields: {
duplicates: {
$size: "$records"
}
}
},
// Stage 3
{
$match: {
duplicates: {
$gt: 1
}
}
},
// Stage 4
{
$unwind: {
path: "$records"
}
},
// Stage 5
{
$project: {
_id: '$records._id',
transactionID: '$records.transactionID',
Value: '$records.Value',
trxld: '$records.trxId'
}
},
]
);db.getCollection("stackoverflow").aggregate(
// Pipeline
[
// Stage 1
{
$group: {
_id: '$Value',
records: {
$push: {
trxId: '$trxId',
transactionID: '$transactionID',
Value: '$Value',
_id: '$_id'
}
}
}
},
// Stage 2
{
$addFields: {
duplicates: {
$size: "$records"
}
}
},
// Stage 3
{
$match: {
duplicates: {
$gt: 1
}
}
},
// Stage 4
{
$unwind: {
path: "$records"
}
},
// Stage 5
{
$project: {
_id: '$records._id',
transactionID: '$records.transactionID',
Value: '$records.Value',
trxld: '$records.trxId'
}
},
]
);answered Nov 17 '18 at 2:36
Aadhi ViveAadhi Vive
6511
answered Nov 17 '18 at 2:36
Aadhi ViveAadhi Vive
6511
answered Nov 17 '18 at 2:36
Aadhi ViveAadhi Vive
6511
answered Nov 17 '18 at 2:36
Aadhi ViveAadhi Vive
6511
6511
add a comment |
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%2f53346354%2fmongo-query-for-the-below-result%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
