Using duplicate intermediate vertex?

[Frank Russell]

How to re-use node as intermediate node ?

When I return the result as path it have all path walked

[2]  A -> B -> C

[3]  A -> B -> D

but when return vertex it remove duplicate vertex B

["A", "B", "C", "D"]

Expected result:

["A", "B", "B", "C", "D"]

| A |   |
|---|---|
| B |   |
| C | D |

Query:

FOR v,e,p IN 1..3 OUTBOUND "columns/0" `table1` RETURN v.title

columns.json

[
    {
        "_key": "0",
        "id": 0,
        "title": "root",
        "visible": false
    },
    {
        "_key": "1",
        "id": 1,
        "title": "A",
        "visible": true
    },
    {
        "_key": "2",
        "id": 2,
        "title": "B",
        "visible": false
    },
    {
        "_key": "3",
        "id": 3,
        "title": "C",
        "visible": true
    },
    {
        "_key": "4",
        "id": 4,
        "title": "D",
        "visible": true
    }
]

table1.json

[
  {
    "_key": "1",
    "_from": "columns/0",
    "_to": "columns/1"
  },
  {
    "_key": "2",
    "_from": "columns/1",
    "_to": "columns/2"
  },
  {
    "_key": "4",
    "_from": "columns/2",
    "_to": "columns/3"
  },
  {
    "_key": "5",
    "_from": "columns/2",
    "_to": "columns/4"
  }
]

[mpv1989]

You could return all vertices of every path `p` und flatten them into one array.

see docu here

RETURN FLATTEN(FOR v,e,p IN 1..3 OUTBOUND "columns/0" `table1` RETURN p.vertices[*].title)

or alternative see docu here

RETURN (FOR v,e,p IN 1..3 OUTBOUND "columns/0" `table1` RETURN p.vertices[*].title)[**]