How do I input a NodeJS variable as a parameter in a MongoDB Query
I've read through every stack overflow I can find and I don't understand why this still isn't working.
I'm trying to construct a NodeJS Mongo find query and very simply want to use a variable as the values, the key does not need to be dynamic.
This is the code I was working with initially :
collection.find({project_id : project_id_val})
but this simply returns :
Found the following records
I've also tried constructing my own javascript object and passing that in e.g.
Query = {}
Query["project id"] = project_id_val
collection.find(query)
But that doesn't work either, I know the key/value pair is correct because
project_id: "12345" works absolutely fine, and returns exactly what I want it to. I feel like this should be very simple so if someone could let me know where I'm going wrong that would be great.
Thanks.
node.js mongodb
asked Nov 14 '18 at 16:14
ryand88ryand88
1
add a comment |
I've read through every stack overflow I can find and I don't understand why this still isn't working.
I'm trying to construct a NodeJS Mongo find query and very simply want to use a variable as the values, the key does not need to be dynamic.
This is the code I was working with initially :
collection.find({project_id : project_id_val})
but this simply returns :
Found the following records
I've also tried constructing my own javascript object and passing that in e.g.
Query = {}
Query["project id"] = project_id_val
collection.find(query)
But that doesn't work either, I know the key/value pair is correct because
project_id: "12345" works absolutely fine, and returns exactly what I want it to. I feel like this should be very simple so if someone could let me know where I'm going wrong that would be great.
Thanks.
node.js mongodb
asked Nov 14 '18 at 16:14
ryand88ryand88
1
Welcome to SO! When you log out the valueproject_id_valdo you get the value you are expecting? Is there a document in your database that corresponds with that value? Also, is the type of that value correct?
– Max Baldwin
Nov 14 '18 at 16:17
Is yourproject_id_vala number and your data in DB a string?
– ankitjaininfo
Nov 14 '18 at 16:24
Wow! I feel stupid, it was the type, I was inserting it as an int but for some reason when I was passing it as a parameter to my get API it classed the variable as a string. I changed it to a string in the MongoDB and it's working perfectly.
– ryand88
Nov 14 '18 at 16:39
@ryand88 glad you figured it out. One other thing, if it is a MongoDB Object Id, something you would see under_id, you should use the ObjectID type. Just wanted to point that out: docs.mongodb.com/manual/reference/method/ObjectId
– Max Baldwin
Nov 14 '18 at 16:56
add a comment |
I've read through every stack overflow I can find and I don't understand why this still isn't working.
I'm trying to construct a NodeJS Mongo find query and very simply want to use a variable as the values, the key does not need to be dynamic.
This is the code I was working with initially :
collection.find({project_id : project_id_val})
but this simply returns :
Found the following records
I've also tried constructing my own javascript object and passing that in e.g.
Query = {}
Query["project id"] = project_id_val
collection.find(query)
But that doesn't work either, I know the key/value pair is correct because
project_id: "12345" works absolutely fine, and returns exactly what I want it to. I feel like this should be very simple so if someone could let me know where I'm going wrong that would be great.
Thanks.
node.js mongodb
asked Nov 14 '18 at 16:14
ryand88ryand88
1
I've read through every stack overflow I can find and I don't understand why this still isn't working.
I'm trying to construct a NodeJS Mongo find query and very simply want to use a variable as the values, the key does not need to be dynamic.
This is the code I was working with initially :
collection.find({project_id : project_id_val})
but this simply returns :
Found the following records
I've also tried constructing my own javascript object and passing that in e.g.
Query = {}
Query["project id"] = project_id_val
collection.find(query)
But that doesn't work either, I know the key/value pair is correct because
project_id: "12345" works absolutely fine, and returns exactly what I want it to. I feel like this should be very simple so if someone could let me know where I'm going wrong that would be great.
Thanks.
node.js mongodb
node.js mongodb
asked Nov 14 '18 at 16:14
ryand88ryand88
1
asked Nov 14 '18 at 16:14
ryand88ryand88
1
asked Nov 14 '18 at 16:14
ryand88ryand88
1
asked Nov 14 '18 at 16:14
ryand88ryand88
1
asked Nov 14 '18 at 16:14
ryand88ryand88
1
1
Welcome to SO! When you log out the valueproject_id_valdo you get the value you are expecting? Is there a document in your database that corresponds with that value? Also, is the type of that value correct?
– Max Baldwin
Nov 14 '18 at 16:17
Is yourproject_id_vala number and your data in DB a string?
– ankitjaininfo
Nov 14 '18 at 16:24
Wow! I feel stupid, it was the type, I was inserting it as an int but for some reason when I was passing it as a parameter to my get API it classed the variable as a string. I changed it to a string in the MongoDB and it's working perfectly.
– ryand88
Nov 14 '18 at 16:39
@ryand88 glad you figured it out. One other thing, if it is a MongoDB Object Id, something you would see under_id, you should use the ObjectID type. Just wanted to point that out: docs.mongodb.com/manual/reference/method/ObjectId
– Max Baldwin
Nov 14 '18 at 16:56
add a comment |
Welcome to SO! When you log out the valueproject_id_valdo you get the value you are expecting? Is there a document in your database that corresponds with that value? Also, is the type of that value correct?
– Max Baldwin
Nov 14 '18 at 16:17
Is yourproject_id_vala number and your data in DB a string?
– ankitjaininfo
Nov 14 '18 at 16:24
Wow! I feel stupid, it was the type, I was inserting it as an int but for some reason when I was passing it as a parameter to my get API it classed the variable as a string. I changed it to a string in the MongoDB and it's working perfectly.
– ryand88
Nov 14 '18 at 16:39
@ryand88 glad you figured it out. One other thing, if it is a MongoDB Object Id, something you would see under_id, you should use the ObjectID type. Just wanted to point that out: docs.mongodb.com/manual/reference/method/ObjectId
– Max Baldwin
Nov 14 '18 at 16:56
Welcome to SO! When you log out the value
project_id_val do you get the value you are expecting? Is there a document in your database that corresponds with that value? Also, is the type of that value correct?– Max Baldwin
Nov 14 '18 at 16:17
Welcome to SO! When you log out the value
project_id_val do you get the value you are expecting? Is there a document in your database that corresponds with that value? Also, is the type of that value correct?– Max Baldwin
Nov 14 '18 at 16:17
Is your
project_id_val a number and your data in DB a string?– ankitjaininfo
Nov 14 '18 at 16:24
Is your
project_id_val a number and your data in DB a string?– ankitjaininfo
Nov 14 '18 at 16:24
Wow! I feel stupid, it was the type, I was inserting it as an int but for some reason when I was passing it as a parameter to my get API it classed the variable as a string. I changed it to a string in the MongoDB and it's working perfectly.
– ryand88
Nov 14 '18 at 16:39
Wow! I feel stupid, it was the type, I was inserting it as an int but for some reason when I was passing it as a parameter to my get API it classed the variable as a string. I changed it to a string in the MongoDB and it's working perfectly.
– ryand88
Nov 14 '18 at 16:39
@ryand88 glad you figured it out. One other thing, if it is a MongoDB Object Id, something you would see under
_id, you should use the ObjectID type. Just wanted to point that out: docs.mongodb.com/manual/reference/method/ObjectId– Max Baldwin
Nov 14 '18 at 16:56
@ryand88 glad you figured it out. One other thing, if it is a MongoDB Object Id, something you would see under
_id, you should use the ObjectID type. Just wanted to point that out: docs.mongodb.com/manual/reference/method/ObjectId– Max Baldwin
Nov 14 '18 at 16:56
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%2f53304509%2fhow-do-i-input-a-nodejs-variable-as-a-parameter-in-a-mongodb-query%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%2f53304509%2fhow-do-i-input-a-nodejs-variable-as-a-parameter-in-a-mongodb-query%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
Welcome to SO! When you log out the value
project_id_valdo you get the value you are expecting? Is there a document in your database that corresponds with that value? Also, is the type of that value correct?– Max Baldwin
Nov 14 '18 at 16:17
Is your
project_id_vala number and your data in DB a string?– ankitjaininfo
Nov 14 '18 at 16:24
Wow! I feel stupid, it was the type, I was inserting it as an int but for some reason when I was passing it as a parameter to my get API it classed the variable as a string. I changed it to a string in the MongoDB and it's working perfectly.
– ryand88
Nov 14 '18 at 16:39
@ryand88 glad you figured it out. One other thing, if it is a MongoDB Object Id, something you would see under
_id, you should use the ObjectID type. Just wanted to point that out: docs.mongodb.com/manual/reference/method/ObjectId– Max Baldwin
Nov 14 '18 at 16:56