Cypher结果返回特定的结构

Question

我试图返回一个特定的结构。下面是我的问题：

MATCH (tracker:tracker { active: true }) OPTIONAL MATCH (tracker { active: true })--(timer:timer) RETURN { tracker:tracker, timers:COLLECT(timer) } as trackers

到目前为止，我返回的内容如下：

{
  "results": [{
    "columns": ["trackers"],
    "data": [{
      "row": [{
        "tracker": {
          "title": "a",
          "id": "04e3fddc-5aef-4c3a-9aeb-62a9fb15bd75",
          "active": true
        },
        "timers": []
      }]
    }]
  }],
  "errors": []
}

我希望计时器嵌套在带有跟踪器属性的"tracker“下，如下所示：

{
  "results": [{
    "columns": ["trackers"],
    "data": [{
      "row": [{
        "tracker": {
          "title": "a",
          "id": "04e3fddc-5aef-4c3a-9aeb-62a9fb15bd75",
          "active": true,
          "timers": []
      }]
    }]
  }],
  "errors": []
}

Answer 1

试试这个：

MATCH (tr:tracker {active: true}) 
OPTIONAL MATCH (tr)--(ti:timer) 
WITH { 
    title: tr.title, 
    id: tr.id,
    active: tr.active,
    timers: COLLECT(ti)
} as trackers
RETURN trackers