Can we do $all query in sails/waterline js?
I am using mongodb and sails/waterlinejs
One of my documents has a field "participants": ["1" ,"2" ,"3"]
I would like to make a mongodb query:
Document.find({participants: {$all: ["1", "2"]}})
But I notice that if I do it in waterline, it returns me all the documents that contains EITHER "1" OR "2".
I would like to get BOTH "1" AND "2"
Is this something that I have to do in native query? Does waterline have a doc somewhere that lists all the available operators for .find()?
Thanks
sails.js waterline
edited Nov 22 '18 at 16:22
JustLearning
1,21421637
asked Nov 22 '18 at 16:16
Zhen LiuZhen Liu
1,78722647
add a comment |
I am using mongodb and sails/waterlinejs
One of my documents has a field "participants": ["1" ,"2" ,"3"]
I would like to make a mongodb query:
Document.find({participants: {$all: ["1", "2"]}})
But I notice that if I do it in waterline, it returns me all the documents that contains EITHER "1" OR "2".
I would like to get BOTH "1" AND "2"
Is this something that I have to do in native query? Does waterline have a doc somewhere that lists all the available operators for .find()?
Thanks
sails.js waterline
edited Nov 22 '18 at 16:22
JustLearning
1,21421637
asked Nov 22 '18 at 16:16
Zhen LiuZhen Liu
1,78722647
add a comment |
I am using mongodb and sails/waterlinejs
One of my documents has a field "participants": ["1" ,"2" ,"3"]
I would like to make a mongodb query:
Document.find({participants: {$all: ["1", "2"]}})
But I notice that if I do it in waterline, it returns me all the documents that contains EITHER "1" OR "2".
I would like to get BOTH "1" AND "2"
Is this something that I have to do in native query? Does waterline have a doc somewhere that lists all the available operators for .find()?
Thanks
sails.js waterline
edited Nov 22 '18 at 16:22
JustLearning
1,21421637
asked Nov 22 '18 at 16:16
Zhen LiuZhen Liu
1,78722647
I am using mongodb and sails/waterlinejs
One of my documents has a field "participants": ["1" ,"2" ,"3"]
I would like to make a mongodb query:
Document.find({participants: {$all: ["1", "2"]}})
But I notice that if I do it in waterline, it returns me all the documents that contains EITHER "1" OR "2".
I would like to get BOTH "1" AND "2"
Is this something that I have to do in native query? Does waterline have a doc somewhere that lists all the available operators for .find()?
Thanks
sails.js waterline
sails.js waterline
edited Nov 22 '18 at 16:22
JustLearning
1,21421637
asked Nov 22 '18 at 16:16
Zhen LiuZhen Liu
1,78722647
edited Nov 22 '18 at 16:22
JustLearning
1,21421637
asked Nov 22 '18 at 16:16
Zhen LiuZhen Liu
1,78722647
edited Nov 22 '18 at 16:22
JustLearning
1,21421637
edited Nov 22 '18 at 16:22
JustLearning
1,21421637
edited Nov 22 '18 at 16:22
JustLearning
1,21421637
1,21421637
asked Nov 22 '18 at 16:16
Zhen LiuZhen Liu
1,78722647
asked Nov 22 '18 at 16:16
Zhen LiuZhen Liu
1,78722647
asked Nov 22 '18 at 16:16
Zhen LiuZhen Liu
1,78722647
1,78722647
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You could use the modifier in.
Searches for records where the value is in the list of values.
Model.find({
participants: { in: ['foo', 'bar'] }
})
Docs: https://sailsjs.com/documentation/concepts/models-and-orm/query-language#?in
Edit
Provide an array to find records whose value for this attribute exactly matches any of the specified search terms.
Model.find({
participants : ['foo', 'bar']
});
Docs: https://sailsjs.com/documentation/concepts/models-and-orm/query-language#?in-modifier
answered Nov 22 '18 at 16:46
Luis ReinosoLuis Reinoso
417
This does not work. It gives me all documents where the participants field contains EITHER "foo" OR "BAR"
– Zhen Liu
Nov 22 '18 at 16:48
add a comment |
Try to use $and, You should do like this.
query = Model.where({"$and": [ { "participants": "1" }, { "participants": "2" } ] });
answered Dec 6 '18 at 11:58
Mayur ShahMayur Shah
2,2201630
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
});
}
});
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%2f53434879%2fcan-we-do-all-query-in-sails-waterline-js%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You could use the modifier in.
Searches for records where the value is in the list of values.
Model.find({
participants: { in: ['foo', 'bar'] }
})
Docs: https://sailsjs.com/documentation/concepts/models-and-orm/query-language#?in
Edit
Provide an array to find records whose value for this attribute exactly matches any of the specified search terms.
Model.find({
participants : ['foo', 'bar']
});
Docs: https://sailsjs.com/documentation/concepts/models-and-orm/query-language#?in-modifier
answered Nov 22 '18 at 16:46
Luis ReinosoLuis Reinoso
417
This does not work. It gives me all documents where the participants field contains EITHER "foo" OR "BAR"
– Zhen Liu
Nov 22 '18 at 16:48
add a comment |
You could use the modifier in.
Searches for records where the value is in the list of values.
Model.find({
participants: { in: ['foo', 'bar'] }
})
Docs: https://sailsjs.com/documentation/concepts/models-and-orm/query-language#?in
Edit
Provide an array to find records whose value for this attribute exactly matches any of the specified search terms.
Model.find({
participants : ['foo', 'bar']
});
Docs: https://sailsjs.com/documentation/concepts/models-and-orm/query-language#?in-modifier
answered Nov 22 '18 at 16:46
Luis ReinosoLuis Reinoso
417
This does not work. It gives me all documents where the participants field contains EITHER "foo" OR "BAR"
– Zhen Liu
Nov 22 '18 at 16:48
add a comment |
You could use the modifier in.
Searches for records where the value is in the list of values.
Model.find({
participants: { in: ['foo', 'bar'] }
})
Docs: https://sailsjs.com/documentation/concepts/models-and-orm/query-language#?in
Edit
Provide an array to find records whose value for this attribute exactly matches any of the specified search terms.
Model.find({
participants : ['foo', 'bar']
});
Docs: https://sailsjs.com/documentation/concepts/models-and-orm/query-language#?in-modifier
answered Nov 22 '18 at 16:46
Luis ReinosoLuis Reinoso
417
You could use the modifier in.
Searches for records where the value is in the list of values.
Model.find({
participants: { in: ['foo', 'bar'] }
})
Docs: https://sailsjs.com/documentation/concepts/models-and-orm/query-language#?in
Edit
Provide an array to find records whose value for this attribute exactly matches any of the specified search terms.
Model.find({
participants : ['foo', 'bar']
});
Docs: https://sailsjs.com/documentation/concepts/models-and-orm/query-language#?in-modifier
answered Nov 22 '18 at 16:46
Luis ReinosoLuis Reinoso
417
edited Nov 22 '18 at 17:00
answered Nov 22 '18 at 16:46
Luis ReinosoLuis Reinoso
417
answered Nov 22 '18 at 16:46
Luis ReinosoLuis Reinoso
417
answered Nov 22 '18 at 16:46
Luis ReinosoLuis Reinoso
417
417
This does not work. It gives me all documents where the participants field contains EITHER "foo" OR "BAR"
– Zhen Liu
Nov 22 '18 at 16:48
add a comment |
This does not work. It gives me all documents where the participants field contains EITHER "foo" OR "BAR"
– Zhen Liu
Nov 22 '18 at 16:48
This does not work. It gives me all documents where the participants field contains EITHER "foo" OR "BAR"
– Zhen Liu
Nov 22 '18 at 16:48
This does not work. It gives me all documents where the participants field contains EITHER "foo" OR "BAR"
– Zhen Liu
Nov 22 '18 at 16:48
add a comment |
Try to use $and, You should do like this.
query = Model.where({"$and": [ { "participants": "1" }, { "participants": "2" } ] });
answered Dec 6 '18 at 11:58
Mayur ShahMayur Shah
2,2201630
add a comment |
Try to use $and, You should do like this.
query = Model.where({"$and": [ { "participants": "1" }, { "participants": "2" } ] });
answered Dec 6 '18 at 11:58
Mayur ShahMayur Shah
2,2201630
add a comment |
Try to use $and, You should do like this.
query = Model.where({"$and": [ { "participants": "1" }, { "participants": "2" } ] });
answered Dec 6 '18 at 11:58
Mayur ShahMayur Shah
2,2201630
Try to use $and, You should do like this.
query = Model.where({"$and": [ { "participants": "1" }, { "participants": "2" } ] });
answered Dec 6 '18 at 11:58
Mayur ShahMayur Shah
2,2201630
edited Dec 6 '18 at 12:05
answered Dec 6 '18 at 11:58
Mayur ShahMayur Shah
2,2201630
answered Dec 6 '18 at 11:58
Mayur ShahMayur Shah
2,2201630
answered Dec 6 '18 at 11:58
Mayur ShahMayur Shah
2,2201630
2,2201630
add a comment |
add a comment |
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%2f53434879%2fcan-we-do-all-query-in-sails-waterline-js%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
