Waterline, find array in array

Question

I have Video model:

module.exports = {

  attributes: {
    id: 'string',
    tags: 'array'
  },
}

I want to find all videos with tags for example "Hello" or "World". I could easy get all videos like: Video.find({tags:"Hello"}). I saw examples where searching id: [1,2,3] but not when key(id => tags) is array.

i updated whole model without functions like (beforeCreate, etc) — vromanch, Jun 11 '14 at 15:08
Check out this answer http://stackoverflow.com/questions/19110553/sails-mongo-find-in-array — kidwon, Jun 11 '14 at 15:41
Probably this helps , too http://stackoverflow.com/questions/22708069/mongodb-find-a-value-inside-the-array — kidwon, Jun 11 '14 at 15:45

score 2 · Answer 1 · edited Jul 25 '15 at 22:25

2

Use the "in"-Statement in combination with "contains"

Video.find({tags: { contains: ["some1","some2"]}}).exec(function(err,res){
    console.log(res);
});

See: https://github.com/balderdashy/waterline-docs/blob/master/queries/query-language.md

edited Jul 25 '15 at 22:25

adriaan

1,088
1
12
29

answered Jun 12 '14 at 08:27

mdunisch

3,627
5
25
41

1

True, this doesn't work. Any idea how to solve this? @harianus did you solve this? – Suisse Jan 22 '18 at 22:56
1

@Suisse: maybe, but that was in 2015 and I don't use Sails anymore. – adriaan Jan 25 '18 at 20:47

vromanch · Accepted Answer · 2019-12-08T21:24:03.203

1

try this:

Video.find({tags: {"$in" : ["sometag1", "sometag2"]}})

edited Dec 08 '19 at 21:24

answered Jun 11 '14 at 16:08

vromanch

939
10
22

4

This is when using a mongodb wrapper, here he is using Waterline. – Julien Fouilhé Jun 11 '14 at 16:27

score -2 · Answer 3 · edited Jun 11 '14 at 15:29

-2

Maybe this..

var filtered = module.exports.filter(function () {
    return this.tags.indexOf("string") != -1
});

edited Jun 11 '14 at 15:29

kidwon

4,448
5
28
45

answered Jun 11 '14 at 15:25

Erik Simonic

457
3
13

Waterline, find array in array

3 Answers3

Linked