How to inner join two tables by one table's pid with other table's embeded array field value?

Question

(sorry,the question title is quite awkward) Hello,I have two table with data like this:

//friend_group table
{
    .....
    {
       "id":"user-me"//owner id 
       "FriendGroups":[
             {"id":"friendGroup_1","Members":["friend_1","friend_2"]},
             {"id":"friendGroup_2","Members":["friend_1","friend_3","friend_4"]},
        ]
    }
    .....
}

//friend table
{
    .....
    {"id":"friend_1","Skills":["java","c++"]}
    {"id":"friend_2","Skills":["python","ruby"]}
    {"id":"friend_3","Skills":["golang","c++"]}
    {"id":"friend_4","Skills":["javascript","ruby"]}
    ....
}

and I want to query out "user-me"'s friends who have been assigned to group "friendGroup-2" and have skill "c++",for given data result should be:

["friend_1","friend_3"]

and I have tried like this:

r.db("test").table("friend").filter(function(u){
    return r.table("friendGroup").get("user-me")("FriendGroups").filter(function(fg){
      return fg("id").eq("friendGroup_2").and(fg("Members").contains(u("id")))
})}).pluck("id")

What is the problem of my script?

Update my script is:

r.db("test").table("friend").filter(function(u){
    return r.table("friendGroup").get("user-me")("FriendGroups").filter(function(fg){
      return fg("id").eq("friendGroup_2").and(fg("Members").contains(u("id")))
})}).filter(function(u){return u("Skills").contains("skill-2")}).pluck("id").pluck("id")

I am not good at reql,do you mean the first return,I have thought about it but didn't figure out how to fix it. — Alex Luya, Aug 06 '15 at 08:36

score 0 · Answer 1 · answered Aug 06 '15 at 09:21

It turns out that change out out return's "filter" to "contains" will solve this problem,right script should be:

r.db("test").table("friend").filter(function(u){
return r.table("friendGroup").get("user-me")("FriendGroups").**contains**(function(fg){
  return fg("id").eq("friendGroup_2").and(fg("Members").contains(u("id")))
})}).filter(function(u){return u("Skills").contains("skill-2")}).pluck("id").pluck("id")

How to inner join two tables by one table's pid with other table's embeded array field value?

1 Answers1