Get Value between to columns in Mongo
1
make:"AC"
model:"ACE"
generation:"1 generation"
year_begin:1993
year_end:2000
serie:"Cabriolet"
I want to wite a mongodb query to get cars if the model year between year_begin and year_end I tried to write it but not work this is my query :
> {'year_begin':{'$gte':1994},'year_end':{'$lte':1994}}
mongodb mongodb-query
asked Nov 26 '18 at 11:08
Ahmed Mohamed TalaatAhmed Mohamed Talaat
61
add a comment |
1
make:"AC"
model:"ACE"
generation:"1 generation"
year_begin:1993
year_end:2000
serie:"Cabriolet"
I want to wite a mongodb query to get cars if the model year between year_begin and year_end I tried to write it but not work this is my query :
> {'year_begin':{'$gte':1994},'year_end':{'$lte':1994}}
mongodb mongodb-query
asked Nov 26 '18 at 11:08
Ahmed Mohamed TalaatAhmed Mohamed Talaat
61
Your query should work. What's the issue?
– Anthony Winzlet
Nov 26 '18 at 16:42
add a comment |
1
1
1
make:"AC"
model:"ACE"
generation:"1 generation"
year_begin:1993
year_end:2000
serie:"Cabriolet"
I want to wite a mongodb query to get cars if the model year between year_begin and year_end I tried to write it but not work this is my query :
> {'year_begin':{'$gte':1994},'year_end':{'$lte':1994}}
mongodb mongodb-query
asked Nov 26 '18 at 11:08
Ahmed Mohamed TalaatAhmed Mohamed Talaat
61
make:"AC"
model:"ACE"
generation:"1 generation"
year_begin:1993
year_end:2000
serie:"Cabriolet"
I want to wite a mongodb query to get cars if the model year between year_begin and year_end I tried to write it but not work this is my query :
> {'year_begin':{'$gte':1994},'year_end':{'$lte':1994}}
mongodb mongodb-query
mongodb mongodb-query
asked Nov 26 '18 at 11:08
Ahmed Mohamed TalaatAhmed Mohamed Talaat
61
asked Nov 26 '18 at 11:08
Ahmed Mohamed TalaatAhmed Mohamed Talaat
61
asked Nov 26 '18 at 11:08
Ahmed Mohamed TalaatAhmed Mohamed Talaat
61
asked Nov 26 '18 at 11:08
Ahmed Mohamed TalaatAhmed Mohamed Talaat
61
asked Nov 26 '18 at 11:08
Ahmed Mohamed TalaatAhmed Mohamed Talaat
61
61
Your query should work. What's the issue?
– Anthony Winzlet
Nov 26 '18 at 16:42
add a comment |
Your query should work. What's the issue?
– Anthony Winzlet
Nov 26 '18 at 16:42
Your query should work. What's the issue?
– Anthony Winzlet
Nov 26 '18 at 16:42
Your query should work. What's the issue?
– Anthony Winzlet
Nov 26 '18 at 16:42
add a comment |
1 Answer
1
active
oldest
votes
0
Try using $and and query should look like below:
db.collection.find({$and:[{year_begin:{$lte: 1994 }}, {year_end:{$gte:1994}}]} )
answered Nov 26 '18 at 11:54
Praveen RewarPraveen Rewar
13
I tried it but I got a single year for example '1994' I have to search with this year between two columns values and if it found between this range begin and end retrieve all the document.
– Ahmed Mohamed Talaat
Nov 26 '18 at 12:12
My bad i made a mistake and didn't change the year, also your logic is correct, the only mistake you made was to use $gte for year_begin and $lte for for year_end, this way you won't get the result for that range.
– Praveen Rewar
Nov 27 '18 at 6:53
add a comment |
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%2f53479839%2fget-value-between-to-columns-in-mongo%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
Try using $and and query should look like below:
db.collection.find({$and:[{year_begin:{$lte: 1994 }}, {year_end:{$gte:1994}}]} )
answered Nov 26 '18 at 11:54
Praveen RewarPraveen Rewar
13
I tried it but I got a single year for example '1994' I have to search with this year between two columns values and if it found between this range begin and end retrieve all the document.
– Ahmed Mohamed Talaat
Nov 26 '18 at 12:12
My bad i made a mistake and didn't change the year, also your logic is correct, the only mistake you made was to use $gte for year_begin and $lte for for year_end, this way you won't get the result for that range.
– Praveen Rewar
Nov 27 '18 at 6:53
add a comment |
0
Try using $and and query should look like below:
db.collection.find({$and:[{year_begin:{$lte: 1994 }}, {year_end:{$gte:1994}}]} )
answered Nov 26 '18 at 11:54
Praveen RewarPraveen Rewar
13
I tried it but I got a single year for example '1994' I have to search with this year between two columns values and if it found between this range begin and end retrieve all the document.
– Ahmed Mohamed Talaat
Nov 26 '18 at 12:12
My bad i made a mistake and didn't change the year, also your logic is correct, the only mistake you made was to use $gte for year_begin and $lte for for year_end, this way you won't get the result for that range.
– Praveen Rewar
Nov 27 '18 at 6:53
add a comment |
0
0
0
Try using $and and query should look like below:
db.collection.find({$and:[{year_begin:{$lte: 1994 }}, {year_end:{$gte:1994}}]} )
answered Nov 26 '18 at 11:54
Praveen RewarPraveen Rewar
13
Try using $and and query should look like below:
db.collection.find({$and:[{year_begin:{$lte: 1994 }}, {year_end:{$gte:1994}}]} )
answered Nov 26 '18 at 11:54
Praveen RewarPraveen Rewar
13
edited Nov 27 '18 at 6:50
answered Nov 26 '18 at 11:54
Praveen RewarPraveen Rewar
13
answered Nov 26 '18 at 11:54
Praveen RewarPraveen Rewar
13
answered Nov 26 '18 at 11:54
Praveen RewarPraveen Rewar
13
13
I tried it but I got a single year for example '1994' I have to search with this year between two columns values and if it found between this range begin and end retrieve all the document.
– Ahmed Mohamed Talaat
Nov 26 '18 at 12:12
My bad i made a mistake and didn't change the year, also your logic is correct, the only mistake you made was to use $gte for year_begin and $lte for for year_end, this way you won't get the result for that range.
– Praveen Rewar
Nov 27 '18 at 6:53
add a comment |
I tried it but I got a single year for example '1994' I have to search with this year between two columns values and if it found between this range begin and end retrieve all the document.
– Ahmed Mohamed Talaat
Nov 26 '18 at 12:12
My bad i made a mistake and didn't change the year, also your logic is correct, the only mistake you made was to use $gte for year_begin and $lte for for year_end, this way you won't get the result for that range.
– Praveen Rewar
Nov 27 '18 at 6:53
I tried it but I got a single year for example '1994' I have to search with this year between two columns values and if it found between this range begin and end retrieve all the document.
– Ahmed Mohamed Talaat
Nov 26 '18 at 12:12
I tried it but I got a single year for example '1994' I have to search with this year between two columns values and if it found between this range begin and end retrieve all the document.
– Ahmed Mohamed Talaat
Nov 26 '18 at 12:12
My bad i made a mistake and didn't change the year, also your logic is correct, the only mistake you made was to use $gte for year_begin and $lte for for year_end, this way you won't get the result for that range.
– Praveen Rewar
Nov 27 '18 at 6:53
My bad i made a mistake and didn't change the year, also your logic is correct, the only mistake you made was to use $gte for year_begin and $lte for for year_end, this way you won't get the result for that range.
– Praveen Rewar
Nov 27 '18 at 6:53
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%2f53479839%2fget-value-between-to-columns-in-mongo%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
Your query should work. What's the issue?
– Anthony Winzlet
Nov 26 '18 at 16:42