OR query in rethink

Question

Is it possible to do OR search on values of array in Rethink.

Eg: I have table called "post" with field "tags" which is an array. I want to do an OR search on values of tags.

post1 {
tags : ["young","agreesive"]
}

post2 {
tags : ["cricket","India"]
}

Give me all posts which contains tags "young" or "cricket" should return be both the posts.

score 2 · Accepted Answer · answered Jun 26 '15 at 17:29

As mlucy said, you can use filter in conjunction with or and contains to get all documents with a specific tag.

If you have an array of tags, you can do the following too:

var tags = ["young", "cricket"];

r.table('posts').filter(function (row) {
  return r.expr(tags).contains(function (value) { 
    return row("tags").contains(value) 
  });
})

This is more easily extensible than using or.

Multi Index

You can also create a multi-index for that property. Multi-indexes let you lookup data by any of the values in an array. So, for example:

r.table("posts").indexCreate("tags", {multi: true})
r.table("posts").getAll("young", "cricket", {index: "tags"})

This query would get all the documents with the "young" and "cricket" tag, and it's more performant and cleaner than using the nested contains.

Thanks Jorge :) For array of tags, this is perfect. – user3783195 Jun 29 '15 at 11:00 — user3783195, Jun 29 '15 at 11:00

score 1 · Answer 2 · answered Jun 26 '15 at 09:55

1

You can do that with or and contains:

r.table('posts').filter(function(row) {
  return row('tags').contains('young').or(row('tags').contains('cricket'));
})

answered Jun 26 '15 at 09:55

mlucy

5,249
1
17
21

OR query in rethink

2 Answers2

Multi Index