2024 3月21日

with
    example :=  (
        select Org {
            _id := .org_id,
            label := .cur_org_name,
            parent_id := .parent.org_id,
            img := .img,
        } filter not .org_name like "%负责人%"
        limit 5
    )

select {
    nodes := example{
        _id,
        label,
        img,
    },
    edges := (
        source := example.parent_id,
        target := example._id, 
    ),
}

[
  {
    "nodes": [
      {
        "img": null,
        "description": "员工数:26   |  部门负责人:张JJ00028310",
        "_id": "JD00000050",
        "label": "郁锦香品牌BU"
      },
      {
        "img": null,
        "description": "员工数:75   |  部门负责人:张JJ00001346",
        "_id": "JD00000044",
        "label": "丽系矩阵BU"
      },
      {
        "img": null,
        "description": null,
        "_id": "JD00000051",
        "label": "欧暇·地中海品牌BU"
      },
      {
        "img": null,
        "description": "员工数:23   |  部门负责人:张JJ00001346",
        "_id": "JD00000052",
        "label": "丽柏品牌BU"
      },
      {
        "img": null,
        "description": "员工数:3   |  部门负责人:张JJ00001346",
        "_id": "JD00078571",
        "label": "丽柏经营部"
      }
    ],
    "edges": [
      {
        "source": "JD00000043",
        "target": "JD00000050"
      },
      {
        "source": "JD00000040",
        "target": "JD00000044"
      },
      {
        "source": "JD00000044",
        "target": "JD00000051"
      },
      {
        "source": "JD00000044",
        "target": "JD00000052"
      },
      {
        "source": "JD00000052",
        "target": "JD00078571"
      }
    ]
  }
]