如何迭代和过滤对rethinkdb db提交

Question

我在DB中有一个：

{
    "id": "d40110a1-c0ca-47e0-95ca-086e905dd53c",
    "somefiled": [
        {
            "city_name": "Aadorf",
            "de": "Aadorf",
            "en": "Aadorf",
            "fr": "Aadorf",
            "it": "Aadorf",
            "kanton_de": "Thurgau",
            "kanton_en": "Thurgovie",
            "kanton_fr": "Thurgau",
            "kanton_it": "Turgovia"
        },
        {
            "city_name": "Aarau",
            "de": "Aarau",
            "en": "Aarau",
            "fr": "Aarau",
            "it": "Aarau",
            "kanton_de": "Aargau",
            "kanton_en": "Argovie",
            "kanton_fr": "Aargau",
            "kanton_it": "Argovia"
        }//many more records here]
}

如何在 somefiled中提取所有数组元素， kanton_en的值是argovie？

类似的东西：

r.db("test").table("table").getField("somefiled").filter(function(row){
  return row("kanton_en").eq("Argovie")
})

但这当然什么都没有。

Answer 1

用：

解决

r.db("test").table("test").getField("somefiled").concatMap(function(row){
  return row.filter(function(b){
    return b("kanton_en").eq("Argovie")
  })
})